pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joel Fradkin <jfradkin@wazagua.com>
To: pgsql-admin@postgresql.org
Subject: Setting up data on two drives newb version.
Date: Sat, 12 Feb 2005 10:56:08 -0500
Message-ID: <000001c5111b$5e95c530$797ba8c0@jfradkin> (raw)

I just wanted to thank everyone who jumped in to help me.
Hopefully I have it set up ok.

Postgres install using more then one raid array for drives.

Install Postgres (I did not let the OS install it as I was wanting to use 8
and Fedora Core 3 was shipping with 7.4)
After I installed Fedora, I went to :
http://www.postgresql.org/ 
Downloads off main menu
FTP browser link
Binary link
8.0
Linux
rpms
fedora
fedora-core-3
http://www.postgresql.org/ftp/binary/v8.0/linux/rpms/fedora/fedora-core-3/
I was able to pull all the rpms (it did ask for the cd for fedora a few
times).

Once that is completed, you should be able to pull up the start services and
see pgsql as a service.
If you start it it will create a /var/lib/pgsql/lib/data folder. Data is the
initdb folder.
When you run initdb it creates this folder for you inside whatever folder
you are running intdb for.

What I did (I have a machine where I set up two additional raid arrays for
the data and the wal files;
 I was told it is best to use raid 10, 10k drives for the data and raid 1
15k drives for the wa/) was initdb /pgsql.
pgsql is what I called my raid 10 array and /wal is what I called my 15k
raid 1 array. This creates a data folder in /pgsql.
in /var/lib/pgsql/data I edited the pgsql.config and changed to
data_directory = '/pgdata/data'. I also: 
listen_addresses = '*'
shared_buffers = 4000
max_fsm_pages = 30000		# min max_fsm_relations*16, 6 bytes each
max_fsm_relations = 1000	# min 100, ~50 bytes each
effective_cache_size = 40000	# typically 8KB each (my box is 8 gig so I
may edit this)
These settings I got from looking at
http://www.desknow.com/kb/idx/0/061/article/
It said to do a vacuum verbose total pages should be lower the
max_fsm_pages.
in pg_hba.conf I added
host    all         all         192.168.123.121 255.255.255.0       trust
to allow me to connect from my desktop.

Before starting the system up a second time (after adding the
data_directory) I went in to the
/pgsql/data folder and (A fellow from the mailing list helped me here to
relocate the wal)
0) backup your data
1) stop postmaster and verify.
2) cd $PGDATA; mv pg_xlog original_pg_xlog; ln -s /wal pg_xlog; cp 
original_pg_xlog/* pg_xlog
3) start postmaster and confirm correct startup in log files.

only diference was I am not using $PGDATA I am using the directory command
in conf. So I chabged dir to /pgsql/data.

WHen I started postgres I could see data growing on both the /wal and /pgsql
drives.
I am still not 100% sure that just the data is on /pgsql/data, but at least
it is using a different drive then the OS 
and the wal and data are on different drives. 





view thread (3+ messages)  latest in thread

Message-ID: <000001c5111b$5e95c530$797ba8c0@jfradkin>
Permalink:  ../000001c5111b$5e95c530$797ba8c0@jfradkin/
Also on:    postgresql.org/message-id/000001c5111b$5e95c530$797ba8c0@jfradkin

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jfradkin@wazagua.com
  Subject: Re: Setting up data on two drives newb version.
  In-Reply-To: <000001c5111b$5e95c530$797ba8c0@jfradkin>
  References: <000001c5111b$5e95c530$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