Search Postgresql Archives

Re: Postgres architecture for multiple instances

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Feb 23, 2015 5:29 AM, "Samuel Smith" <pgsql@xxxxxxxxxx> wrote:
>
> On 02/22/2015 01:53 PM, Scott Marlowe wrote:>
> > I'd run a debian based distro (Ubuntu or Debian work well) and use the
> > pg_* commands to create the clusters the same way. Gives you the
> > maximum separation for clients.
> >
> > pg_createcluster
> >
> > Usage: /usr/bin/pg_createcluster [options] <version> <cluster name>
> > [-- <initdb options>]
> >
> > Options:
> >    -u <uid>      cluster owner and superuser (default: 'postgres')
> >    -g <gid>      group for data files (default: primary group of owner)
> >    -d <dir>      data directory (default:
> >                  /var/lib/postgresql/<version>/<cluster name>)
> >    -s <dir>      socket directory (default: /var/run/postgresql for clusters
> >                  owned by 'postgres', /tmp for other clusters)
> >    -l <dir>      path to desired log file (default:
> >                  /var/log/postgresql/postgresql-<version>-<cluster>.log)
> >    --locale <encoding>
> >                  set cluster locale (default: inherit from environment)
> >    --lc-collate/ctype/messages/monetary/numeric/time <locale>
> >                  like --locale, but only set for a particular category
> >    -e <encoding> Default encoding (default: derived from locale)
> >    -p <port>     port number (default: next free port starting from 5432)
> >    --start       start the cluster after creating it
> >    --start-conf auto|manual|disabled
> >                  Set automatic startup behaviour in start.conf (default: 'auto')
> >    --createclusterconf=file alternative createcluster.conf to use
> >    --environment=file alternative environment file to use
> >    <initdb options> other options to pass to initdb
> >
> > Just use -u and -d to put it where you want, -l to setup logging and
> > -p to set the port you want.
> >
>
> I am stuck with redhat as the OS so I'll only have initdb. But this is a good point. I assume there is nothing wrong with having multiple postgres instances (clusters) all running under a single postgres user on different ports on the same machine?
> But then what is the best way to handle connecting to an individual cluster  (local only for admin purposes) with psql?  Doesn't look like I could go by the cluster name alone, but would have to manage (memorize) connections by port number?
>

You can use shell aliases and name it as you please.

Petr
> Thanks,
> Sam
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux