Good morning, > Yes, you can do it. All you have to do is create four seperate accounts > for it to run under (pgsql1, pgsql2, pgsql3, pgsql4) and then in each of > those accounts, set up a different PGDATA value and initdb as that user. > Then edit each account's postgresql.conf to have a different port number > (I just incremented from 5432 to 5433 etc...) and start them up. Well, it looks easy *g* I will do this today and hope, it work.
> Then when you connect just specify the port of the database instance you > need. Since each one is running as a different user with different > postgresql.conf and pg_hba.conf files you can lock the production instance > down tight to prevent brain farts (oops, I just dropped a table in the > production database) and you're gold. Ok, at the moment , I only can say: thank you, and I had to test it during this weekend to start at the next week with the configuration. Daniel ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
