Thread

1. Multiple Postgres Instances

   David Giffin <david@agent911.com> — 1999-01-21T01:19:15Z

   Hello,
   
   I'm trying to run postgres on two different post 5432 and port 5433 with
   different data directories for each instance:
   
   
   [ -x /usr/local/pgsql/bin/postmaster ] && {
           su -l postgres -c '/usr/local/pgsql/bin/postmaster -S -i'
           echo -n ' pgsql'
   }
   
   [ -x /usr/local/pgsql/bin/postmaster ] && {
           su -l postgres -c '/usr/local/pgsql/bin/postmaster
   -D/usr/local/pgsql/data_5433 -p5433 -S -i'
           echo -n ' pgsql'
   }
   
   
   But when I do a psql -p 5433 and drop a table it seems to drop in both
   instances. If anyone has attempted this before I like to hear how it
   worked.
   
   David
   
   
   

2. Re: [GENERAL] Multiple Postgres Instances

   Jeff Hoffmann <jeff@remapcorp.com> — 1999-01-21T14:46:56Z

   David Giffin wrote:
   > 
   > Hello,
   > 
   > I'm trying to run postgres on two different post 5432 and port 5433 with
   > different data directories for each instance:
   > 
   > [ -x /usr/local/pgsql/bin/postmaster ] && {
   >         su -l postgres -c '/usr/local/pgsql/bin/postmaster -S -i'
   >         echo -n ' pgsql'
   > }
   > 
   > [ -x /usr/local/pgsql/bin/postmaster ] && {
   >         su -l postgres -c '/usr/local/pgsql/bin/postmaster
   > -D/usr/local/pgsql/data_5433 -p5433 -S -i'
   >         echo -n ' pgsql'
   > }
   > 
   > But when I do a psql -p 5433 and drop a table it seems to drop in both
   > instances. If anyone has attempted this before I like to hear how it
   > worked.
   > 
   > David
   
   just a guess on my part, but i think what you're going to want to do is
   set the PG_DATA environment variable to /usr/local/pgsql/data_5433 in
   your script before you start the second instance.  they screwed around
   with the ability to specify absolute paths to the data directory in
   6.4.x and didn't document it, so i'm not sure what the truth is about
   it.  i'm not sure if that's what  is causing the problem in _this case_,
   but it has happened with other cases.  (it makes good sense to require
   you to use environment variables in all cases, as far as i'm
   concerned.)  i submitted some doc patches, but apparently they haven't
   shown up yet.
   
   again, this is just a guess, but an educated one.  
   
   jeff
   
   jeff@remapcorp.com
   
   

3. Re: [GENERAL] Multiple Postgres Instances

   Alex P. Rudnev <alex@relcom.eu.net> — 1999-01-21T14:55:59Z

   Looks like you are running two PSQL server with THE SAME DATA BASE 
   DIRECTORY!
   
   
   
   
   On Thu, 21 Jan 1999, Jeff Hoffmann wrote:
   
   > Date: Thu, 21 Jan 1999 08:46:56 -0600
   > From: Jeff Hoffmann <jeff@remapcorp.com>
   > To: David Giffin <david@agent911.com>
   > Cc: pgsql-general@hub.org
   > Subject: Re: [GENERAL] Multiple Postgres Instances
   > 
   > David Giffin wrote:
   > > 
   > > Hello,
   > > 
   > > I'm trying to run postgres on two different post 5432 and port 5433 with
   > > different data directories for each instance:
   > > 
   > > [ -x /usr/local/pgsql/bin/postmaster ] && {
   > >         su -l postgres -c '/usr/local/pgsql/bin/postmaster -S -i'
   > >         echo -n ' pgsql'
   > > }
   > > 
   > > [ -x /usr/local/pgsql/bin/postmaster ] && {
   > >         su -l postgres -c '/usr/local/pgsql/bin/postmaster
   > > -D/usr/local/pgsql/data_5433 -p5433 -S -i'
   > >         echo -n ' pgsql'
   > > }
   > > 
   > > But when I do a psql -p 5433 and drop a table it seems to drop in both
   > > instances. If anyone has attempted this before I like to hear how it
   > > worked.
   > > 
   > > David
   > 
   > just a guess on my part, but i think what you're going to want to do is
   > set the PG_DATA environment variable to /usr/local/pgsql/data_5433 in
   > your script before you start the second instance.  they screwed around
   > with the ability to specify absolute paths to the data directory in
   > 6.4.x and didn't document it, so i'm not sure what the truth is about
   > it.  i'm not sure if that's what  is causing the problem in _this case_,
   > but it has happened with other cases.  (it makes good sense to require
   > you to use environment variables in all cases, as far as i'm
   > concerned.)  i submitted some doc patches, but apparently they haven't
   > shown up yet.
   > 
   > again, this is just a guess, but an educated one.  
   > 
   > jeff
   > 
   > jeff@remapcorp.com
   > 
   > 
   
   Aleksei Roudnev, Network Operations Center, Relcom, Moscow
   (+7 095) 194-19-95 (Network Operations Center Hot Line),(+7 095) 230-41-41, N 13729 (pager)
   (+7 095) 196-72-12 (Support), (+7 095) 194-33-28 (Fax)
   
   
   

4. Re: [GENERAL] Multiple Postgres Instances

   David Giffin <david@agent911.com> — 1999-01-21T19:54:14Z

   It looks like the .profile and /etc/profile were overriding the -D option.
   I set the profile to this:
   
   PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:/usr/local/pgsql/bin
   MANPATH=:/usr/local/pgsql/bin
   PGLIB=/usr/local/pgsql/lib
   # note: PGDATA overwrites the -D startup option
   # PGDATA=/usr/local/pgsql/data
   
   I also had to take the PGDATA value out of the /etc/profile (I had it set 
   there because most of the users on the system are database users). Then
   changed the rc script to this:
   
   [ -x /usr/local/pgsql/bin/postmaster ] && {
           su -l postgres -c '/usr/local/pgsql/bin/postmaster -p5432 -D
   /usr/local/pgsql/data_5432 -S -i'
           echo -n ' pgsql 5432'
   }
   [ -x /usr/local/pgsql/bin/postmaster ] && {
           su -l postgres -c '/usr/local/pgsql/bin/postmaster -p5433 -D
   /usr/local/pgsql/data_5433 -S -i'
           echo -n ' pgsql 5433'
   }
   
   Presto! Everything seems to be working! Thanks for the suggestions!
   
   David
   
   
   On Thu, 21 Jan 1999, Jeff Hoffmann wrote:
   
   > David Giffin wrote:
   > > 
   > > Hello,
   > > 
   > > I'm trying to run postgres on two different post 5432 and port 5433 with
   > > different data directories for each instance:
   > > 
   > > [ -x /usr/local/pgsql/bin/postmaster ] && {
   > >         su -l postgres -c '/usr/local/pgsql/bin/postmaster -S -i'
   > >         echo -n ' pgsql'
   > > }
   > > 
   > > [ -x /usr/local/pgsql/bin/postmaster ] && {
   > >         su -l postgres -c '/usr/local/pgsql/bin/postmaster
   > > -D/usr/local/pgsql/data_5433 -p5433 -S -i'
   > >         echo -n ' pgsql'
   > > }
   > > 
   > > But when I do a psql -p 5433 and drop a table it seems to drop in both
   > > instances. If anyone has attempted this before I like to hear how it
   > > worked.
   > > 
   > > David
   > 
   > just a guess on my part, but i think what you're going to want to do is
   > set the PG_DATA environment variable to /usr/local/pgsql/data_5433 in
   > your script before you start the second instance.  they screwed around
   > with the ability to specify absolute paths to the data directory in
   > 6.4.x and didn't document it, so i'm not sure what the truth is about
   > it.  i'm not sure if that's what  is causing the problem in _this case_,
   > but it has happened with other cases.  (it makes good sense to require
   > you to use environment variables in all cases, as far as i'm
   > concerned.)  i submitted some doc patches, but apparently they haven't
   > shown up yet.
   > 
   > again, this is just a guess, but an educated one.  
   > 
   > jeff
   > 
   > jeff@remapcorp.com
   >