Re: [ADMIN] maximum rows to retrive

2011-02-08 Thread Antonio Biondo
Hi, tnx for the answer. Do you think that will be add a option in the menù for query editor too? Mysql workbench has it, i would appreciate it in Pgadmin III... Best regards, Antonio Il 04/02/2011 00:44, Guillaume Lelarge ha scritto: Le 01/02/2011 18:44, Antonio Biondo a écrit :

[ADMIN] phpPgAdmin configuration

2011-02-08 Thread Marc Fromm
I installed phpPgAdmin on my red hat box in the /var/www/html directory. I edited the pg_hba.conf file as many tutorials stated with the lines. local allalltrust host allall127.0.0.1/32 trust When I

Re: [ADMIN] maximum rows to retrive

2011-02-08 Thread Guillaume Lelarge
Le 08/02/2011 10:27, Antonio Biondo a écrit : Hi, tnx for the answer. Do you think that will be add a option in the menù for query editor too? Mysql workbench has it, i would appreciate it in Pgadmin III... No. The user writes his query, I'm not sure he would like we mess with it adding

Re: [ADMIN] phpPgAdmin configuration

2011-02-08 Thread Guillaume Lelarge
Le 08/02/2011 23:23, Marc Fromm a écrit : I installed phpPgAdmin on my red hat box in the /var/www/html directory. I edited the pg_hba.conf file as many tutorials stated with the lines. local allall trust host all

Re: [ADMIN] phpPgAdmin configuration

2011-02-08 Thread Marc Fromm
Yes, the database server is on the same server as the http server. The complete error message is just Login failed. There is nothing in the pg_log file, that the FAQ's say to check. Marc -Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org]

Re: [ADMIN] phpPgAdmin configuration

2011-02-08 Thread Guillaume Lelarge
Le 09/02/2011 00:27, Marc Fromm a écrit : Yes, the database server is on the same server as the http server. The complete error message is just Login failed. There is nothing in the pg_log file, that the FAQ's say to check. How did you configure phpPgAdmin? -- Guillaume

Re: [ADMIN] [PERFORM] Query Core Dumping

2011-02-08 Thread Sam Stearns
Thanks, Tom. Forwarded from pgsql-performance. Working on stack trace. perl -V: perl -V Summary of my perl5 (revision 5 version 8 subversion 8) configuration: Platform: osname=solaris, osvers=2.10, archname=i86pc-solaris uname='sunos katana7 5.10 generic_118855-15 i86pc i386 i86pc '

Re: [ADMIN] [PERFORM] Query Core Dumping

2011-02-08 Thread Sam Stearns
Segmentation Fault - core dumped === pollsys(0x080475B8, 1, 0x, 0x) = 1 recv(4, i t z _ l i s a @ h o t.., 16005, 0) = 8192 brk(0x095FBCF0) = 0 brk(0x095FDCF0) = 0 pollsys(0x080475B8, 1, 0x, 0x) = 1 recv(4, \0\0\007 U L L - N

Re: [ADMIN] [PERFORM] Query Core Dumping

2011-02-08 Thread Sam Stearns
Thanks, Tom. Forwarded from pgsl-performance. Segmentation Fault - core dumped === pollsys(0x080475B8, 1, 0x, 0x) = 1 recv(4, i t z _ l i s a @ h o t.., 16005, 0) = 8192 brk(0x095FBCF0) = 0 brk(0x095FDCF0) = 0 pollsys(0x080475B8, 1,

[ADMIN] Postgres Replication Options

2011-02-08 Thread Rangi, Jai
Hello, I am looking for a replication solution for PG 9.x. Idea is to have one master replication server and multiple (around 20) slave servers read only. I see PG 9 has inbuilt Streaming replication. Is this the best replication solution. How about slony? Which option will keep the slave nodes

Re: [ADMIN] phpPgAdmin configuration

2011-02-08 Thread barbara
Hello: Is it a passwordless account? I ran in such an error using a passwordless account. Since the error supposes a successful connection to the server unsuccessful login attempt, I guess apache is running ok and the vhost is also correctly configured, but maybe you could have a look at its

Re: [ADMIN] Postgres Replication Options

2011-02-08 Thread Rosser Schwarz
On Tue, Feb 8, 2011 at 5:34 PM, Rangi, Jai jra...@automotive.com wrote: I am looking for a replication solution for PG 9.x. Idea is to have one master replication server and multiple (around 20) slave servers read only. I know (anecdotally) of at least one organization that's using Bucardo [1]

Re: [ADMIN] Postgres Replication Options

2011-02-08 Thread Gabriele Bartolini
Hi, Il 09/02/11 01:34, Rangi, Jai ha scritto: Hello, I am looking for a replication solution for PG 9.x. Idea is to have one master replication server and multiple (around 20) slave servers read only. I see PG 9 has inbuilt Streaming replication. Is this the best replication solution. How