I ever use: /usr/bin/psql -d mydb -f file.dump
and for make the dump: pg_dump -d mydb -f file.dump -E utf8 -U postgres allways from postgres user. Regards 2010/7/9 Bertrand Chenal <[email protected]> > Le Fri, 09 Jul 2010 17:10:11 +0200, > Ralf Peschke <[email protected]> a écrit : > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > Sorry fo rm yenglish. There is no answer to an existing thread. > > I think,the LDAP-stuff may be the reason for the > > postgre/tryton-connection problem. It's just an idea, because I'm > > running out of them. > > > > > > > Am 09.07.2010 16:08, schrieb Cédric Krier: > > >> On 09/07/10 15:13 +0200, Ralf Peschke wrote: > > >>> Hi, > > >>> > > >>> I am trying to restore a tryton-database that was pg_dumped on a > > >>> customers server. ( pg_dump -Fc). > > >>> With pg_restore I can restore the database succesfully on my > > >>> server. The owner is set to tryton, everything seems okay. > > >>> Just the tryton-client refuses to connect to the tryton-server at > > >>> all: I can't connect to any of the other databases: Of course, > > This is really strange, is it not even possible to connect to other > DB ?? Is there any log message on the client or server shells ? Also if > you want to know if the problem comes from the ldap module, try to > remove it (or just blank __tryton__.py and __init__.py inside it). > > I would also check that I can connect with the psql client. > > > >>> after deleting the customers database, everything is okay again. > > >>> Restoring the customers database with the tryton-included > > >>> database-facility results always in an "connection pool exhausted" > > >>> error, regardless of the max number of connections. > > >>> > > >>> Problem of the restored database could be the configured > > >>> LDAP-connection. For sure, the customers LDAP-server is not > > >>> reachable! Could this be the reason of the problems or are there > > >>> any other ideas/hints? > > > > > >> I have no idea. LDAP module should failed back to standard > > >> authentification. > > > > > >> But could you please start a new thread instead of answering to an > > >> existing. > > > > > > > > > > > -----BEGIN PGP SIGNATURE----- > > Version: GnuPG v1.4.10 (GNU/Linux) > > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > > > iEYEARECAAYFAkw3O80ACgkQb2+5ZL6Nh6EJCACgpAJCJprYk+SRr5g4YHJ1VWNd > > coUAni3WwvrkSqXiYyKy56YIYVGwm2mG > > =dFTo > > -----END PGP SIGNATURE----- > > > > > > -- > Bertrand Chenal > > B2CK SPRL > Rue de Rotterdam, 4 > 4000 Liège > Belgium > Tel: +32 472 54 46 59 > Email: [email protected] > Website: http://www.b2ck.com/ > > -- > [email protected] mailing list > -- [email protected] mailing list
