Re: database export in pgsql

What is the command you have used while dumping the objects?

Thanks

Dinesh Pandey

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Vikas
Sent: Wednesday, May 11, 2005 10:00 AM
To: pgsql-general(at)postgresql(dot)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