Re: [GENERAL] PGPool in Master-Master mode, is it possible?

Thank you Tatsuo for the Reply, I will post this in list you mentioned. By Master-Master, I meant two pgpool servers both active accepting connections from Application, If one Pgpool Server becomes unlavailable other still accepting connections. At an Ideal time, both Pgpool instances on each PgPo

[GENERAL] PGPool in Master-Master mode, is it possible?

Hello There, I need to setup two PGPool Servers in Master-Master mode, First thing I want to know, is it possible? I know we can setup 2 PGPool servers in master-slave mode using watchdog. http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/en.html Could anyone please enlight

[GENERAL] Postgresql 9.3 service doesn't start on RedHat Linux 6.8

3/bin/postmaster -D /var/lib/pgsql/9.3/data & and it is working fine. Can someone let me know where to look at for why I can't start the service? Thanks Vikas

[GENERAL] unsubscribe

unsubscribe ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] database export in pgsql

PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vikas Sent: Wednesday, May 11, 2005 10:00 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] database export in pgsql Richard Huxton wrote: Vikas wrote: Hi, Im having problems in exporting my local pgdb to my server with data

Re: [GENERAL] database export in pgsql

Richard Huxton wrote: Vikas wrote: Hi, Im having problems in exporting my local pgdb to my server with data. I do a backup and everytime i get stuck in functions or some $libdir or function pg_logdir_ls() etc. pg_dump shouldn't ever "get stuck" at any point. It was not the pg

[GENERAL] database export in pgsql

generate the database script which does not include so many types of objects since my db does not use functions only generic tables and views. Please help, Thanks and Regards, Vikas ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] Regarding Postgres installation and administration on linux suse 9.0

 Dear Sir /Madam,  We are working on Linux suse 9.0 and we have installed Postgres 7.3 through yast with the privileges of  "root" user. But we are not able to start / configure the postgres database, Kindly help us in configuring and starting the same database and how can we create database

Re: [GENERAL] statement level triggers in PostgreSQL , anybody??

> This has nothing to do with triggers, it has to do with not being able > to defer UNIQUE constraints. The classic solution is: > > update SET column = -column; > update SET column = -column+1; Thanks for the reply. Is changing query the only way to do this in postgres? I would expect some mor

[GENERAL] JDBC: what exactly does nullsAreSortedHigh() return?

Hi all, I am a bit confused about the method java.sql.DatabaseMetaData.nullsAreSortedHigh(). What exactly does this return? If this returns true, are nulls considered as the highest value? Or does this mean that nulls comes first when sorted in ascending order (opposite in meaning to the first).

[GENERAL] Installing PostgreSQL on winNT

e C compiler (gcc -O2 ) works... no configure: error: installation or configuration problem: C compiler cannot creat e executables. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>&g