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 PROTECTED]
Cc: pgsql-general
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
Sent: Wednesday, December
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
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
On Dec 19, 2007 11:12 AM, Sean Z. [EMAIL
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
