[ADMIN] Installation Questions (FreeBSD / Windows / Postgres 9)

2010-11-03 Thread Panos Katergiathis
Hello all My goal is to install and run Postgresql 9 under FreeBSD and Windows with selected database cluster encoding / collation / locale to be UTF-8. Unfortunately, it has been a while since i last compiled and installed Postgresql on Linux machines. I remember that selecting the proper locale

Re: [ADMIN] PANIC killing vacuum process

2010-11-03 Thread Kevin Grittner
Scott Marlowe wrote: > Silvio Brandani wrote: >> we have develop a script to execute the vacuum full on all tables > Vacuum full is more of a recovery / offline command and is to be > used sparingly, especially before 9.0. And before 9.0, most of the situations where you might reasonably co

Re: [ADMIN] PANIC killing vacuum process

2010-11-03 Thread Scott Marlowe
On Wed, Nov 3, 2010 at 10:06 AM, Silvio Brandani wrote: > > Alls, > > we have develop a script to execute the vacuum full on all tables of our Vacuum full is more of a recovery / offline command and is to be used sparingly, especially before 9.0. > very big database , since it is a 24 x 7 availa

Re: [ADMIN] PANIC killing vacuum process

2010-11-03 Thread Silvio Brandani
Tom Lane ha scritto: "Kevin Grittner" writes: Silvio Brandani wrote: we have develop a script to execute the vacuum full on all tables of our very big database , since it is a 24 x 7 available system we have not a timeframe to exec the vacuum full. so we try with this script running t

Re: [ADMIN] PANIC killing vacuum process

2010-11-03 Thread Silvio Brandani
Kevin Grittner ha scritto: Silvio Brandani wrote: we have develop a script to execute the vacuum full on all tables of our very big database , since it is a 24 x 7 available system we have not a timeframe to exec the vacuum full. so we try with this script running the vauum full table by t

Re: [ADMIN] PANIC killing vacuum process

2010-11-03 Thread Silvio Brandani
Kevin Grittner ha scritto: Silvio Brandani wrote: we have develop a script to execute the vacuum full on all tables of our very big database , since it is a 24 x 7 available system we have not a timeframe to exec the vacuum full. so we try with this script running the vauum full table by t

Re: [ADMIN] PANIC killing vacuum process

2010-11-03 Thread Tom Lane
"Kevin Grittner" writes: > Silvio Brandani wrote: >> we have develop a script to execute the vacuum full on all tables >> of our very big database , since it is a 24 x 7 available system >> we have not a timeframe to exec the vacuum full. >> so we try with this script running the vauum full table

Re: [ADMIN] PANIC killing vacuum process

2010-11-03 Thread Kevin Grittner
Silvio Brandani wrote: > we have develop a script to execute the vacuum full on all tables > of our very big database , since it is a 24 x 7 available system > we have not a timeframe to exec the vacuum full. > so we try with this script running the vauum full table by table > and if the vacuum

[ADMIN] PANIC killing vacuum process

2010-11-03 Thread Silvio Brandani
Alls, we have develop a script to execute the vacuum full on all tables of our very big database , since it is a 24 x 7 available system we have not a timeframe to exec the vacuum full. so we try with this script running the vauum full table by table and if the vacuum generate the waiting sta

Re: [ADMIN] Using LDAP with postgresql 8.2

2010-11-03 Thread Kieren Scott
Hi, I have made some progress on this, in that I've managed to get LDAP authentication working, but not quite as I expected. I found out that the Canonical Name in AD was set to "PG Test" for the account name "pgtest". If I add "PG Test" as the user in pg_hba.conf and create a login "PG Test"

[ADMIN] Compiling PostgreSql 9.0 on Sparc Solaris (64 bit)

2010-11-03 Thread Gerrit Seré
Hallo A few weeks ago, we saw questions on the mailing list about compiling PostgreSql on Solaris Sparc. Compiling on Solaris is always an adventure. It took us nearly a 2 weeks for compiling and making a package for PostgreSql and Postgis. We heavily use spare zones. That's one of the reasons