[ADMIN] General queries regarding backup

Hi everyone, I have some queries regarding the PITR backup procedure on Postgres 8.3. Here are the steps I follow for backup 1. I set up WAL archiving and checked that this is working. 2. Execute SELECT pg_start_backup('label') 3. Zip the entire data directory excluding the pg_xlog directory. 4.

[ADMIN] First SV PostgreSQL Meetup

Hello People, I announce the first SV PostgreSQL Meetup. Date: Sunday July 26 2pm Location: Rhomobile HQ 10950 North Blaney Avenue Cupertino, CA 95014 Topic: Running PostgreSQL on your laptop to support development of Rails sites and Rhosync sites. If we have enough interest, we may try to est

Re: [ADMIN] Cannot connect to postgresql

On Tuesday 21 July 2009 10:35:46 Carol Walter wrote: > Hello, > > I emailed to the group last week about being able to access one of my > postgres databases from other machines on my network. I thought the > problem was a installation of 8.2.10 that I had been testing an > upgrade on had clobbered

[ADMIN] Cannot connect to postgresql

Hello, I emailed to the group last week about being able to access one of my postgres databases from other machines on my network. I thought the problem was a installation of 8.2.10 that I had been testing an upgrade on had clobbered some of the files that the system needed. I had been

[ADMIN] COUNT(DISTINCT field) OVER (PARTITION BY another_field)

Hi list, Does someone knows why this is not a supported feature? I was happily SQL querying when I woke up from my dreams with this message: ERROR: DISTINCT is not implemented for window functions LINE 6: COUNT(DISTINCT handle) OVER (PARTITION BY pk_pessoas) AS ha... It could be very useful t

Re: [ADMIN] COUNT(DISTINCT field) OVER (PARTITION BY another_field)

Auto-answer: WITH uniques AS ( SELECT group_key, COUNT(DISTINCT reference) AS unique_references FROM record_data GROUP BY group_key ) SELECT group_key, record_data.*, uniques.unique_references FROM record_data JOIN uniques USING (group_key) ORDER BY group_key; Super-PostgreSQL is my hero.

Re: [ADMIN] implement ldap authentication in PostgreSQL

Andreas Wenk schrieb: mitra nazemian schrieb: thanks but I has read them. I dont understand where I shoud spacify the cn, dn in postgresql too use them in pg_hba.conf. please help me On Mon, Jul 20, 2009 at 11:50 AM, Andreas Wenk > wrote: mitra n

Re: [ADMIN] implement ldap authentication in PostgreSQL

mitra nazemian schrieb: thanks but I has read them. I dont understand where I shoud spacify the cn, dn in postgresql too use them in pg_hba.conf. please help me On Mon, Jul 20, 2009 at 11:50 AM, Andreas Wenk mailto:a.w...@netzmeister-st-pauli.de>> wrote: mitra nazemian schrieb:

Re: [ADMIN] Cannot create UTF8 database

On Tue, Jul 21, 2009 at 11:50 AM, Ibrahim Shaame wrote: > Thanks. It worked. > Ibrahim > > On Mon, Jul 20, 2009 at 11:58 AM, J. Carlos Muro wrote: > >> I think you need to setup locale of the user who inits/runs the cluster >> (generally "postgres') to unicode in order to init a unicode cluster.