http://www.postgresql.org/docs/8.0/static/app-pgdump.html 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:57 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: database export in pgsql 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend