Re: [SQL] pg_restore problem

2012-09-14 Thread Adrian Klaver
On 09/14/2012 01:58 AM, Kjell Øygard wrote: 1 - Ok, I was not aware of that 2 - I used version 9.1.4 of pg_dump 3 - The command was in a script, se below pdir=/usr/local/postgresql-9.1.4/ bdir=/backup/`hostname -s`/dump/ export PATH=${pdir}/bin:$PATH # make sure tmp files are not readable

Re: [SQL] pg_restore problem

2012-09-13 Thread Adrian Klaver
On 09/12/2012 12:23 AM, Kjell Øygard wrote: Morning guys... I have two servers , one with postgres 9.2rc1 and one with postgres 9.1.4. I need to do a restore from a dump from 9.1.4 to 9.2rc1 and I get this error: pg_restore: [archiver (db)] Error from TOC entry 177675; 2613 579519 BLOB 579519 p

[SQL] pg_restore problem

2012-09-12 Thread Kjell Øygard
Morning guys... I have two servers , one with postgres 9.2rc1 and one with postgres 9.1.4. I need to do a restore from a dump from 9.1.4 to 9.2rc1 and I get this error: pg_restore: [archiver (db)] Error from TOC entry 177675; 2613 579519 BLOB 579519 primar pg_restore: [archiver (db)] could not ex

[SQL] pg_restore problem -- MORE?!?

2005-02-03 Thread Bradley Miller
This is getting ridiculous . . . I dump from the database into another one (just for grins) on the same server to a different name and I don't even get all the info? My functions are coming through fine (finally) but now I've got missing tables and missing data. Could someone point me somewhere

Re: [SQL] pg_restore problem

2005-02-03 Thread Bradley Miller
Interestingly, I made a new database on my test server and then was able to do a pg_dump from my mac box to the test server and I think it got just about everything . . . I've got some constraint issues and other oddities happening, but at least my functions came in fine. I used the pipe command t

Re: [SQL] pg_restore problem

2005-02-03 Thread Richard Huxton
Bradley Miller wrote: So in the current version I'm running (7.4.6) and I do a pg_dump I have to then manually manipulate the order by doing a -l to get a table of contents and then reorder (just changing the first number; or the oid also??) just to get it to work right? Does anyone else have

Re: [SQL] pg_restore problem

2005-02-03 Thread Bradley Miller
So in the current version I'm running (7.4.6) and I do a pg_dump I have to then manually manipulate the order by doing a -l to get a table of contents and then reorder (just changing the first number; or the oid also??) just to get it to work right? Does anyone else have these issues? How exactl

Re: [SQL] pg_restore problem

2005-02-02 Thread Tom Lane
Bradley Miller <[EMAIL PROTECTED]> writes: > I'm attempting to restore a dump from one server to another (one is a > Mac and one is a Linux base, if that makes any difference). I keep > running into issues like this: > pg_restore: [archiver (db)] could not execute query: ERROR: function > pub

Re: [SQL] pg_restore problem

2005-02-02 Thread Joel Fradkin
MAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bradley Miller Sent: Wednesday, February 02, 2005 3:17 PM To: Postgres List Subject: [SQL] pg_restore problem   I'm attempting to restore a dump from one server to another (one is a Mac and one is a Linux base, if that makes any difference

[SQL] pg_restore problem

2005-02-02 Thread Bradley Miller
I'm attempting to restore a dump from one server to another (one is a Mac and one is a Linux base, if that makes any difference). I keep running into issues like this: pg_restore: [archiver (db)] could not execute query: ERROR: function public.random_page_link_id_gen() does not exist This is wh