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
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) |