specifying different location for data and wal on fedora core 3 /backup question again

From: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: specifying different location for data and wal on fedora core 3 /backup question again
Date: 2005-02-06 00:24:50
Message-ID: 000001c50be2$48bf2cd0$797ba8c0@jfradkin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 = postgres

ENCODING = '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 = '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

Browse pgsql-sql by date

  From Date Subject
Next Message Premsun Choltanwanich 2005-02-07 04:40:40 How can I use large object on PostgreSQL Linux Version?
Previous Message Joel Fradkin 2005-02-05 22:36:09 postgres8 install on fedora core 3 (or redhat4 beta AS)