SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 08:57 PM
| ||||
| ||||
 database export in pgsql 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. I ignore those function definations but then it crashes on some create table statement. 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. Please help, Thanks and Regards, Vikas ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend      |
|
04-08-2008, 08:57 PM
| |||
| |||
| 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings |
|
04-08-2008, 08:58 PM
| |||
| |||
| 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 |
|
04-08-2008, 08:58 PM
| ||||
| ||||
| Re: database export in pgsql What is the command you have used while dumping the objects? Thanks Dinesh Pandey -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto  gsql-general-owner@postgresql.org] On Behalf Of VikasSent: 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 |
Linear Mode
