What is the command you have used while dumping the objects?
Thanks
Dinesh Pandey
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Vikas
Sent: Wednesday, May 11, 2005 10:00 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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