Im doing through the GUI...
pg_dump.exe -i -h 192.168.1.31 -p 5432 -U postgres -F p -v -f "c:\del.sql" -n public "DBNAME"
Dinesh Pandey wrote:
What is the command you have used while dumping the objects?
Thanks
Dinesh Pandey
-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Vikas
Sent: Wednesday, May 11, 2005 10:00 AM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: database export in pgsql
Richard Huxton wrote:
Vikas wrote:
Hi,
Im having problems in exporting my local pgdb to my server with data.
I do a backup and everytime i get stuck in functions or some $libdir
or function pg_logdir_ls() etc.
pg_dump shouldn't ever "get stuck" at any point.
It was not the pg_dump which got stuck. it was the importing the
generated SQL where I got stuck.
How do I prevent functions of other system type objects from being
dumped in the SQL?
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
