Re: [ADMIN] md5 password authentication does not work when db_user_namespace = on

2008-08-15 Thread Bruce Momjian
Sava Chankov wrote: > Hi, > when I set db_user_namespace = on in postgresql.conf and my pg_hba.conf > contains only the line: > local sameroleallpassword > users can be authenticated (I have created users as [EMAIL PROTECTED]). > However, when I change pg_hba's METHOD to md5, it doesn't w

Re: [ADMIN] pgCluster and PostgreSQL

2008-08-15 Thread Mathias Stjernström
Hi! It seems like pgClusters-1.9 i built on Postgres 8.3 if you read the docs at http://www.pgcluster.org/svn/pgcluster-1.9/ So i think it should work. But http://pgcluster.projects.postgresql.org/ have not been updated since 2005 ;) /Mathias On 15 aug 2008, at 21.55, DANIEL CRISTIAN C

Re: [ADMIN] New postgres installation

2008-08-15 Thread Steve Crawford
H. Hall wrote: Carol Walter wrote: It been suggested that I download the binary and just go from there. All the documentation I've read says that for Unix installations should compile source. Would using the binary allow me to do the customization my site requires. I want to put the databas

[ADMIN] pgCluster and PostgreSQL

2008-08-15 Thread DANIEL CRISTIAN CRUZ
Hi all. I was looking at PostgreSQL docs, and didn't found any reference about a merge of PostgreSQL. A long time ago I saw somenthig about this. Does anyone know why there is no mention about it on the todo? I've used some pgClusters and they worked well. Is it still working? Kind regards,

Re: [ADMIN] New postgres installation

2008-08-15 Thread H. Hall
Carol Walter wrote: It been suggested that I download the binary and just go from there. All the documentation I've read says that for Unix installations should compile source. Would using the binary allow me to do the customization my site requires. I want to put the database in it's origi

Re: [ADMIN] New postgres installation

2008-08-15 Thread Simon Riggs
On Fri, 2008-08-15 at 09:44 -0400, Carol Walter wrote: > All the documentation I've read says that for Unix installations > should compile source. You're right. We should fix that so it also describes using pre-packaged options also. -- Simon Riggs www.2ndQuadrant.com PostgreSQL

Re: [ADMIN] New postgres installation

2008-08-15 Thread Carol Walter
It been suggested that I download the binary and just go from there. All the documentation I've read says that for Unix installations should compile source. Would using the binary allow me to do the customization my site requires. I want to put the database in it's original location so t

Re: [ADMIN] DB Dump Size

2008-08-15 Thread Tino Schwarze
On Fri, Aug 15, 2008 at 11:09:02AM +1000, [EMAIL PROTECTED] wrote: > Nice, that has cleared it up. > > I am on 8.1 also. > > On my test box, a standard dump took 6m 26sec & a -Fc dump took 11min 2sec. > That's not a great difference, but the size difference is quite noticeable. You might use --c