(nobody could help me a week ago... any new volunteers?)
I am not an expert with Postgres (version 6.4.2) but I never had a
problem with using pg_dump on a remote server and rebuilding a local
I have this new database working well under the same postgres version
I make a dump:
pg_dump -d -o -z -f dump_db_name db_name
I then copy the file on my computer. I make:
psql -f dump_db_name db_name
I tried without the -o but I got many error on some tables like:
INSERT INTO "typehotel" values (0,'camping','camping site');
query buffer max length of 20000 exceeded
query line ignored
this db uses sequence for the first time. I read that the dump file
So I did that...
the same restore command made:
box:~/data/base>$ psql -f dump_db_name db_name
CREATE TABLE pgdump_oid (dummy int4);
COPY pgdump_oid WITH OIDS FROM stdin;
Enter info followed by a newline
End with a backslash and a period on a line by itself.
Since I don't know what this is... I put "\."
the file is read...
The result was the same as with no -o
The only difference I see between this new db and the other ones is the
sequence and some text field (quite big).
Marc Andre Paquin
Le Réseau Touristique INTER-Rés@
The INTER-Res@ tourism network
pgsql-sql by date
|Next:||From: Bruce Momjian||Date: 2000-01-22 19:37:39|
|Subject: Re: [SQL] More efficient DELETE ... ?|
|Previous:||From: Tom Lane||Date: 2000-01-22 18:07:47|
|Subject: Re: [SQL] More efficient DELETE ... ? |