Running multiple PostgreSQL instances on gentoo?

[LordVan]

hi.

i was wondering if there was some standard way of running multiple instances of postgresql (e.g. on port 5432 and 5433) with different Data dirs (same postgres version).
I know i can copy the init script and config and modify them so that it works but did anyone do this already?

Thanks
_________________
I don't suffer from insanity. I enjoy every minute of it.

[Tekeli Li]

I've never done it, and I believe if I did, I'd be doing separate init script for that. Although I believe the data dir env var is still being ignored (bug)?

Still, why would you want to run multiple pgsql instances on the same machine?

[LordVan]

With dbmail and several other apps i found it to be an issue with vacuum and optimize .. also dbmail has lots and lots of inserts which seem to degrade performance on other apps/dbs as well as it takes up resources (i think)
_________________
I don't suffer from insanity. I enjoy every minute of it.

[hannibal218bc]

Sorry to revive this old thread, but I'm also searching for a sensible way to run multiple instances / clusters on one Gentoo machine. What I'd like to do is to have one machine serve as a server for one cluster and also as a streaming replication slave. So, I need two clusters and two instances.

Thanks for any input!

[hannibal218bc]

I added this "enhancement request" to bugzilla:

https://bugs.gentoo.org/show_bug.cgi?id=375185

[titanofold]

I won't be adding support in the init scripts for multiple instances per slot.

You'll have to create an additional cluster manually using initdb. (The init script assumes the user will be postgres, so make it easy on yourself and instruct initdb that the owner is postgres.)

ln -s /etc/init.d/postgresql-${SLOT} /etc/init.d/something-else

cp /etc/conf.d/postgresql-${SLOT} /etc/conf.d/something-else

Edit /etc/conf.d/something-else to point to the proper directory where you've created the additional cluster, where the configuration files are, and the port you want it to run on.

You should be good to go at that point.
_________________
The best things in life are free.
Guy-1: Surely, you will fold with me...
Guy-2: Alright, but don't call me Shirley

[hannibal218bc]

Ah, I see -- it's that easy!? Cool, already works. Thank you!

[Vieri]

I was looking for that too.

Could it be possible to have this information within the postgresql-server ebuilds (just as plain einfo)?
And/or on the official Gentoo postgresql documentation web page?

Thanks

[titanofold]

[svoop]

[quote="titanofold"]

[KAMIKAZE_]

another case: I don't want to replicate all my databases in one archive. If I will run recovery for one - it will rollback other dbs too, that's bad
_________________
-=[powered by Gentoo]=-