View Single Post

   
  #3 (permalink)  
Old 04-08-2008, 09:58 PM
Vikas
 
Posts: n/a
Default 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

Reply With Quote