Sorry I am not familiar with hyperic. Do you mean I can use hyperic to do the
job, or do you mean I can take the same approach as hyperic?
- Original Message
From: Scott Marlowe <[EMAIL PROTECTED]>
To: Sean Z. <[EMAIL PROTECTED]>
Cc: pgsql-general@postgresql.org
Sen
BTW, what's the best way to determine the installation folder, port number used
by an existing postgres server? From registry
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations ?
- Original Message
From: Scott Marlowe <[EMAIL PROTECTED]>
To: Sean Z. <[EMAIL PROTECT
any version existing on the same windows
box?
- Original Message
From: Scott Marlowe <[EMAIL PROTECTED]>
To: Sean Z. <[EMAIL PROTECTED]>
Cc: pgsql-general@postgresql.org
Sent: Wednesday, December 19, 2007 1:04:19 PM
Subject: Re: [GENERAL] Deploy postgres - upgrade strategy
Hi,
I need your kind advice on postgres deployment strategy. My application is
developed on 8.2.4 and need to be deployed to Windows server 2003. Clients may
/may not have postgres installed. How can I deploy postgres silently on client
machine? Specifically:
1. How to determine if postgres
Hi,
I need to write a maintenance function to delete oldest records of a table,
leaving only a certain number of records, say 50. The task should run once per
day. How can I write it?
The oldest record carries the smallest ID.
Thanks a lot!
Sean
__
Hi,
I partitioned a table "events" into 31 tables, based on "day" of event_time.
I did 3 steps to setup partition, after creating partition tables:
1. Add the constraint to the 31 partition tables like:
ALTER TABLE events_day_1
ADD CONSTRAINT events_day_1_event_time_check CHECK (date_part('da
