Search Postgresql Archives

Re: database export in pgsql

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

 



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.

I ignore those function definations but then it crashes on some create table statement.

Neither pg_dump nor pg_restore should crash.

I believe there is a easy way to generate the database script which does not include so many types of objects
since my db does not use functions only generic tables and views.

If you don't have any functions, there shouldn't be any functions in the dump.


What exact commands are you running?
What is the precise error message you receive?

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[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