Postgres and more than 2 Locations for storage 
Author Message
 Postgres and more than 2 Locations for storage

Hello all,

I am trying to setup Postgresql to run in more that 2 locations.

Setting PGDATA and PGDATA2 work fine with out a problem but I would like to
setup more that those 2 locations ie PGDATA3(4,5,ect) and can not seem to
find if this is possible or not.

I know that i need to initdb the location if i want to run a separate
server on a separate port or just initlocation for the same (atleast I
think i understand that) and have tried both for PGDATA3 and i get error
pertaining to "ERROR:  Postmaster environment variable 'PGDATA3' not set"

What can I change to make this work?

Thank you all for your help

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Sun, 25 Jul 2004 18:26:19 GMT
 Postgres and more than 2 Locations for storage

Quote:
> Setting PGDATA and PGDATA2 work fine with out a problem but I would like to
> setup more that those 2 locations ie PGDATA3(4,5,ect) and can not seem to
> find if this is possible or not.

Certainly it is possible. Follow the directions in the admin docs (use
createlocation etc) and make sure that any new environment variables are
set just like PGDATA2 is already set (maybe in the postgres account's
.bashrc/.cshrc/?? script?).

                    - Thomas

---------------------------(end of broadcast)---------------------------



Sun, 25 Jul 2004 23:51:54 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Storage Location Patch Proposal for V7.3

2. Recommended Database Storage Locations

3. Storage Location Patch Proposal for V7.3

4. ROLAP Storage Location?

5. Storage Location Patch Proposal for V7.3

6. Column/Table Description Storage Location

7. Storage Location / Tablespaces (try 3)

8. Storage Location Patch Proposal for V7.3

9. Setting logfile location with pg_ctl and postgres.conf

10. Informix DSA : Default storage database location ........

11. MySQL vs. Postgres - congratulations to the postgres team

12. enable pl/pgsql in postgres from postgres-server-7.0.3-2 RPM


 
Powered by phpBB® Forum Software