Re: database export in pgsql - Mailing list pgsql-general

From Dinesh Pandey
Subject Re: database export in pgsql
Date
Msg-id 20050511045113.1A6CD53C3B@svr1.postgresql.org
Whole thread Raw
In response to Re: database export in pgsql  (Vikas <vikas.yadav@ctwoodapple.com>)
List pgsql-general

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

pgsql-general by date:

Previous
From: Vikas
Date:
Subject: Re: database export in pgsql
Next
From: Bruno Wolff III
Date:
Subject: Re: Age() calculation question