X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 376128B9B50 for ; Sun, 6 Feb 2005 00:21:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63124-07 for ; Sun, 6 Feb 2005 00:21:27 +0000 (GMT) Received: from out002.verizon.net (out002pub.verizon.net [206.46.170.141]) by svr1.postgresql.org (Postfix) with ESMTP id 8B76C8B9E17 for ; Sun, 6 Feb 2005 00:21:28 +0000 (GMT) Received: from jfradkin ([66.15.127.235]) by out002.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050206002127.YAYG26937.out002.verizon.net@jfradkin> for ; Sat, 5 Feb 2005 18:21:27 -0600 From: "Joel Fradkin" To: Subject: specifying different location for data and wal on fedora core 3 /backup question again Date: Sat, 5 Feb 2005 19:24:50 -0500 Message-ID: <000001c50be2$48bf2cd0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C50BB8.5FE924D0" X-Authentication-Info: Submitted using SMTP AUTH at out002.verizon.net from [66.15.127.235] at Sat, 5 Feb 2005 18:21:24 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.196 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: *** X-Archive-Number: 200502/95 X-Sequence-Number: 20206 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C50BB8.5FE924D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Being new to Linux I am not 100% sure on a few items. =20 I could find=20 % setenv PGDATA2 /home/postgres/data % initlocation $PGDATA2 Creating Postgres database system directory /home/postgres/data =20 Creating Postgres database system directory /home/postgres/data/base =20 For defining data in another spot, but was not sure how to put the environment into the Postgres superuser's .profile or .cshrc =20 I have two file systems (on separate raids per a suggestion from a list member) They are /pgdata and /wal respectively. Can anyone point me to a walkthrough how to do this (assuming its = documented somewhere)? =20 I still have had no luck with the backup (I did notice when the database = is created using dbcreate ; logged in as postgres) it had=20 CREATE DATABASE wazagua WITH OWNER =3D postgres ENCODING =3D 'SQL_ASCII'; =20 The backup seemed to blow up on=20 pg_restore: ERROR: invalid byte sequence for encoding "UNICODE": 0xe9 =20 Do I have to specify ENCODING =3D 'SQL_ASCII'; some how? If so can anyone give me the backup and restore syntax. It gives no errors backing up, just restoring. =20 =20 Joel Fradkin =20 =20 =20 ------=_NextPart_000_0001_01C50BB8.5FE924D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Being new to Linux I am not 100% sure on a few = items.

I could find

% setenv PGDATA2 =
/home/postgres/data

% initlocation =
$PGDATA2

Creating Postgres database system directory =
/home/postgres/data

Creating Postgres database system directory =
/home/postgres/data/base

For defining data in another spot, but was not sure = how to put the environment into the Postgres superuser's .profile or .cshrc

I have two file systems (on separate raids per a suggestion from = a list member)

They are /pgdata and /wal respectively.

Can anyone point me to a walkthrough how to do this (assuming = its documented somewhere)?

I still have had no luck with the backup (I did notice when the database is created using dbcreate ; logged in as postgres) it had =

CREATE DATABASE wazagua

WITH OWNER =3D postgres

ENCODING =3D = 'SQL_ASCII';

The backup seemed to blow up on

pg_restore: = ERROR: invalid byte sequence for encoding "UNICODE": = 0xe9

Do I have to specify ENCODING =3D 'SQL_ASCII'; some = how?

If so can anyone give me the backup and restore = syntax.

It gives no errors backing up, just = restoring.

Joel Fradkin

------=_NextPart_000_0001_01C50BB8.5FE924D0--