RE : RE : Restore and back up OGo database

Thanks for your answer
But now it works very well;

To save completely the database, I execute this commands :
# adduser OGo 
# su - OGo
# pg_dump  OGo > (database name)

to restore completely the database, I execute this commands :
# su - postgres
$ dropdb OGo
$ createdb OGo
$ exit
# su - OGo
$ psql OGo < ogodb		ogodb is in the folder /home/OGo

To save, I execute this commands :
# su - OGo
$ pg_dump OGo -t enterprise > t_enterprise

to restore one database table, I execute this commands :
# su - OGo
$ psql OGo -c "drop table enterprise"
$ psql OGo
\i   t_enterprise

Thanks =)


Alexandre POLLET 
 

-----Message d'origine-----
De : Karsten Rasmussen [mailto:[email protected]] 
Envoyé : lundi 8 août 2005 10:23
À : [email protected]
Objet : Re: [OGo-Discuss] RE : Restore and back up OGo database

Some inputs:
1) Did you  "su -" to root before restoring?
2) It looks like your database/postgress does not know the OGo user name or the access rights is not set proberly
The OGo user must be added to the database
3) Try installing the database rpm before restoring
 
PS: I think you should use the [email protected] list insteed for this kind of questions
>>Sorry for my english... 
You should see me french:-)
 
/Karsten

 
  
" 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. "
-- 
OpenGroupware.org Discussion [email protected]
http://mail.opengroupware.org/mailman/listinfo/discuss