Re: [ADMIN] suggestions/hints for multimaster solution

2009-01-09 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > we're looking for a multi-master solution (whole database not only some > tables) for our production database (Postgres 8.3.5 64bit on OpenSuse), > and I wanted to know what are your experiences/suggestions with/for such > a scenario (multimas

[ADMIN] initdb Q rewritten please remove or ignore my last email

2009-01-09 Thread dx k9
Hi, I recently initdb'd with pwfile to create a new instance. The command is below. As the postgres user on the local server. /usr/local/pgsql.v835/bin/initdb --pwfile=/home/postgres/pgp -D /data/Linux.pgsql/serray5432 -E UTF8 I nromally use PAM as my METHOD in my hba files to allow ldap use

Re: [ADMIN] ssl database connection problems...

2009-01-09 Thread Ray Stell
On Fri, Jan 09, 2009 at 04:08:00PM -0500, Ray Stell wrote: > ./configure --prefix=/usr/local/pgsql826 > --with-libraries=/usr/local/openssl/lib > --with-includes=/usr/local/openssl/include/ --with-openssl > > > On Fri, Jan 09, 2009 at 03:47:54PM -0500, Carol Walter wrote: > > Well, back from

Re: [ADMIN] ssl database connection problems...

2009-01-09 Thread Ray Stell
./configure --prefix=/usr/local/pgsql826 --with-libraries=/usr/local/openssl/lib --with-includes=/usr/local/openssl/include/ --with-openssl On Fri, Jan 09, 2009 at 03:47:54PM -0500, Carol Walter wrote: > Well, back from the flu. =P > > How do I tell postgres where to look for ssl. I've got

[ADMIN] initdb

2009-01-09 Thread dx k9
Hi, I recently initdb'd with pwfile to create a new instance. The command is below. I use pam in my hba files as my METHOD to allow ldap users in, but I normally don't initialize with --pwfile(wish I wouldn't have). Using --pwfile seems to have disabled my ability to use LDAP. I also noticed

Re: [ADMIN] ssl database connection problems...

2009-01-09 Thread Carol Walter
Well, back from the flu. =P How do I tell postgres where to look for ssl. I've got both the new and the original versions of openssl. I don't want to remove the original one because it's loaded on the global zone and I don't know what other dependencies it might have. Do I have to back

Re: [ADMIN] suggestions/hints for multimaster solution

2009-01-09 Thread Jaume Sabater
2009/1/9 Gerd König : > we want to have a scenario where (at least) 2 servers are r/w accessible > and if one of the server crashes this should cause (almost) no downtime > for the database. > Yes, you're right, it's more like "keeping two databases in sync". I would call this replication with fa

Re: [ADMIN] suggestions/hints for multimaster solution

2009-01-09 Thread Jaume Sabater
On Fri, Jan 9, 2009 at 11:32 AM, Gerd König wrote: > Perhaps we should have a look at > * pg_pool(II) I can only speak of pgpool-II. It's working fine for me in a setup which is exactly the same one you have (change OpenSuse for Debian, but the rest is the same). The thing is that pgpool-II itse

[ADMIN] suggestions/hints for multimaster solution

2009-01-09 Thread Gerd König
Hello, we're looking for a multi-master solution (whole database not only some tables) for our production database (Postgres 8.3.5 64bit on OpenSuse), and I wanted to know what are your experiences/suggestions with/for such a scenario (multimaster for failover purpose). I know there are some tools