[ADMIN] Error while starting postgreSQL service

2007-11-19 Thread Bebarta, Simanchala
Hi, Need immediate attention to my concern. While starting the postgreSQL service, i get the error message as Could not open process token "error code-5" Appreciate if any one can help me out on this issue. Thanks & Regards, Sima

Re: [ADMIN] Error while starting postgreSQL service

2007-11-19 Thread Gregory Williamson
Sima asked: <...> > > While starting the postgreSQL service, i get the error message as > > Could not open process token "error code-5" > > Appreciate if any one can help me out on this issue. > Without more information its hard to say -- you might provide some information about what operati

Re: [ADMIN] [GENERAL] Error while starting postgreSQL service

2007-11-19 Thread Richard Huxton
Bebarta, Simanchala wrote: Need immediate attention to my concern. OK. While starting the postgreSQL service, i get the error message as Could not open process token "error code-5" What version of PostgreSQL? What operating-system? Have you had any problems before this point? -- Richard

Re: [ADMIN] Error while starting postgreSQL service

2007-11-19 Thread Bebarta, Simanchala
Hi, My postgreSQL 8.2.4 is installed on Windows server 2003 Enterprise Edition. Windows Server configuration: RAM 4GB HDD 50 GB Processor: Pentium 4 CPU 3.20 GHz When the shared_buffers = 2048 MB is set in the Postgresql.conf file, while starting the service, I got the error Could not

Re: [ADMIN] [GENERAL] Error while starting postgreSQL service

2007-11-19 Thread Richard Huxton
Don't forget to cc: the list, other people will probably know more than me. Bebarta, Simanchala wrote: Hi, My postgreSQL 8.2.4 is installed on Windows server 2003 Enterprise Edition. OK. Thanks. 8.2.5 has been released, and you should consider upgrading soon. The Windows-related changes se

Re: [ADMIN] [GENERAL] Error while starting postgreSQL service

2007-11-19 Thread Bebarta, Simanchala
Yes, when I set the value to 1300 MB, everything goes fine. Any value higher than this value does not allow me to start the service. sima -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Monday, November 19, 2007 3:40 PM To: Bebarta, Simanchala Cc: PG-General Maili

Re: [ADMIN] [GENERAL] Error while starting postgreSQL service

2007-11-19 Thread Richard Huxton
Bebarta, Simanchala wrote: >> >> Does the problem go away when you put shared_buffers back to a lower >> number? >> Yes, when I set the value to 1300 MB, everything goes fine. Any value higher than this value does not allow me to start the service. It's quite possible that you can't go any high

Re: [ADMIN] [GENERAL] Error while starting postgreSQL service

2007-11-19 Thread Scott Marlowe
On Nov 19, 2007 4:15 AM, Bebarta, Simanchala <[EMAIL PROTECTED]> wrote: > Yes, when I set the value to 1300 MB, everything goes fine. Any value > higher than this value does not allow me to start the service. Please don't top post. Anyway, are you sure that increasing shared_buffers that high is

Re: [ADMIN] [GENERAL] Error while starting postgreSQL service

2007-11-19 Thread Magnus Hagander
On Mon, 2007-11-19 at 10:33 +, Richard Huxton wrote: > Bebarta, Simanchala wrote: > >> > >> Does the problem go away when you put shared_buffers back to a lower > >> number? > >> > > Yes, when I set the value to 1300 MB, everything goes fine. Any value > > higher than this value does not a

[ADMIN] Get a list of ALL tables

2007-11-19 Thread Kevin Kempter
Hi List; I'm working with a client with several highly active 8.1.4 servers. I want to run a weekly cron that will vacuum ALL db tables except those with entries in pg_autovacuum (where we've setup manual/cron vacuums) in order to eliminate transaction ID wraparound failure warnings (which come

Re: [ADMIN] Get a list of ALL tables

2007-11-19 Thread Tom Lane
Kevin Kempter <[EMAIL PROTECTED]> writes: > I'm working with a client with several highly active 8.1.4 servers. I want to > run a weekly cron that will vacuum ALL db tables except those with entries in > pg_autovacuum (where we've setup manual/cron vacuums) in order to eliminate > transaction ID

Re: [ADMIN] Get a list of ALL tables

2007-11-19 Thread Kevin Kempter
Sorry, I meant to send this to the list: We have a handful of tables that are quite large and take several hours to vacuum. We're managing these large tables by using cron via a schedule that accounts for system load. I want to pull the list of all tables and exclude these large tables from th

Re: [ADMIN] Get a list of ALL tables

2007-11-19 Thread adey
This usually does it for me:- select * from -- information_schema.tables pg_catalog.pg_tables --WHERE -- table_schema = 'public' --ORDER BY -- table_name On 11/20/07, Kevin Kempter <[EMAIL PROTECTED]> wrote: > > Sorry, I meant to send this to the list: > > > We have a handful of tables

Re: [ADMIN] Get a list of ALL tables

2007-11-19 Thread Joshua D. Drake
Kevin Kempter wrote: Sorry, I meant to send this to the list: We have a handful of tables that are quite large and take several hours to vacuum. We're managing these large tables by using cron via a schedule that accounts for system load. I want to pull the list of all tables and exclude the