Search Postgresql Archives

Re: database export in pgsql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux