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