Re: database export in pgsql

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