From: Joel Fradkin <jfradkin@wazagua.com>
To: pgsql-sql@postgresql.org
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> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jfradkin@wazagua.com
Subject: Re: specifying different location for data and wal on fedora core 3 /backup question again
In-Reply-To: <000001c50be2$48bf2cd0$797ba8c0@jfradkin>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox