Re: [SQL] problem with backup and restore (probaly stupit newb thing)

2005-02-03 Thread Joel Fradkin
lete and destroy all copies of the original message, including attachments. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 1:17 PM To: Richard Huxton Cc: Joel Fradkin; pgsql-sql@postgresql.org Subject: Re: [SQL] problem with backup

Re: [SQL] problem with backup and restore (probaly stupit newb thing)

2005-02-03 Thread Tom Lane
Richard Huxton writes: > Joel Fradkin wrote: >> ServerVersion: 07.03.0200 PostgreSQL 7.4.6 on i386-redhat-linux-gnu, >> compiled by GCC i386-redhat-linux-gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2 > OK - let's start here. The syntax here is fine, I just tested it on an > 8.0 database. Are you sure

Re: [SQL] problem with backup and restore (probaly stupit newb thing)

2005-02-03 Thread Richard Huxton
Joel Fradkin wrote: Can anyone help me out on this (I will need to backup and restore the data base, but am not savy on the proper save and restore syntax). I used the default ones in PGadmin as detailed below and it blew up on pg_restore: restoring data for table "tblaction" pg_restore: ERROR: i

[SQL] problem with backup and restore (probaly stupit newb thing)

2005-02-03 Thread Joel Fradkin
Can anyone help me out on this (I will need to backup and restore the data base, but am not savy on the proper save and restore syntax). I used the default ones in PGadmin as detailed below and it blew up on pg_restore: restoring data for table "tblaction" pg_restore: ERROR:  invalid byte sequence