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(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
>