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

From: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Richard Huxton'" <dev(at)archonet(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: problem with backup and restore (probaly stupit newb thing)
Date: 2005-02-03 19:58:29
Message-ID: 000001c50a2a$bc552cd0$797ba8c0@jfradkin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am not running version 8 (I did try this on the linux box as well, but the
version I documented was the server is linux and the client is XP).

I ran it from PG admin in both cases, maybe I need to just run from the
command line on the linux box (this is fine as long as I can backup the file
and restore it if need be). I did the dump and restore from the PGadminIII
program so maybe the data base is not (UTF-8). I am new to this so I do not
know how to determine and set the types so they match up.
I did a create database and am running a .net app to read the data from
MSSQL and add it to Postgres.

If anyone know a quick to determine this and what the syntax mods are for
the dump and restore I would be very happy, if not I can play around. Thanks
so much for all the help, maybe I should load version 8 (I was not sure
there were rpms for fedora 3 that worked, I tried to load it and was
obviously not doing it correctly).

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305

jfradkin(at)wazagua(dot)com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, February 03, 2005 1:17 PM
To: Richard Huxton
Cc: Joel Fradkin; pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] problem with backup and restore (probaly stupit newb
thing)

Richard Huxton <dev(at)archonet(dot)com> 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 the DB you are restoring to is version 8?

Looks to me like he's trying to use 8.0 pg_dump/pg_restore to reload
into a 7.4 server. This definitely won't work without specifying
--disable-dollar-quoting to pg_dump; and if you care about restoring
object ownership correctly, also --use-set-session-authorization.
I don't recall if there are any other gotchas.

The unicode issue I'm not sure about. Perhaps the original database was
SQL_ASCII encoding and so was allowed to contain byte sequences that
aren't legal unicode?

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Karsten Hilbert 2005-02-03 20:04:18 Re: Information about the command SQL " create synonym".
Previous Message Jeff Boes 2005-02-03 19:56:14 Re: Calendar Function