Re: RE : Restore and back up OGo database

> I want to restore and back up OGo database with postgreSQl
> So I manage to save database like that
> $ su - postgres
> $ pg_dump -boFt OGo > OGo.tar

Why do you do this backup as postgres?  Seems to me you'd want to do it
as OGo.

> the file called OGo.tar is created in /var/lib/pgsql

Create the file somwhere like /tmp so you don't have to be the postgres
super user.

> And to back up database, I execute this commands :
> $ pg_restore -U OGo -d OGo OGo.tar
> Errors : pg_restore: [archiver (db)] connection to database "OGo"
> failed: FATAL: IDENT authentication failed for user "OGo"

Of course,  you're PostgreSQL configuration prevents this.  Be the OGo
user, or supply a password to verify the connection.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)

iD8DBQBC/1AqLRePpNle04MRAjj5AJ4hwwroWYPUcuNP8PYzLCFf09z0TgCfdYS6
rA80rEVhoST2o+IZvwe22cI=
=Yy3s
-----END PGP SIGNATURE-----