RE : Restore and back up OGo database
"Alexandre Pollet" <[email protected]>
| Newsgroups | gmane.comp.cms.opengroupware.discuss.general |
|---|---|
| Message-ID | <C7C2D80E78A0CB4A993F361B695AF52F5C42AC@srvmail.groupe-altitude.fr> |
Hello 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 the file called OGo.tar is created in /var/lib/pgsql 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" and $ pg_restore -d OGo OGo.tar Errors : pg_restore: [archiver (db)] could not reconnect to database "OGo" failed: FATAL: IDENT authentication failed for user "OGo" I need some help ? Some idea to resolve my problem ? Sorry for my english... " Ce message et toutes les pieces jointes sont etablis a l'attention exclusive de ses destinataires et sont confidentiels. L'internet ne permettant pas d'assurer l'integrite de ce message, le contenu de ce message ne represente en aucun cas un engagement de la part de notre societe. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir immediatement l'expediteur. This message contains privileged and confidential information. Given that the internet does not allow us to make sure of the communication's integrity, the content of this message does not represent in any case a commitment from our compagny. If you are not the intended recipient, please notify us immediately and delete this e-mail (including any attachments) from your system. "