hai
Recently we migrated our database from 8.2.4 to 8.2.12 , went through
manuals and followed the below steps
1.pg_dumpall to take data dump of current database
2.stopped database
3.moved the pgsql to backup folder
4.downloaded 8.2.12 , configured - gmake - gmake install
5.recreated cluster
Can we automate this process , maintained by postmaster itself
Regards
Sathish
On Thu, Mar 5, 2009 at 10:01 PM, Joshua Tolley eggyk...@gmail.com wrote:
On Thu, Mar 05, 2009 at 04:50:09AM -0800, paulo matadr wrote:
I need to procedure to kill users in idle,anybody have this made?
Thanks for ur reply John
For information , We have Novell SuSe 11.0 server ON x86_32 and we have
installed from source code
Regards
sathish
On Fri, Mar 6, 2009 at 1:46 AM, John R Pierce pie...@hogranch.com wrote:
Sathish Duraiswamy wrote:
hai
Recently we migrated our database from 8.2.4
Thanks for your reply.
Can we have script in cron jobs to do this step periodically
If possible , can anyone help for cron script to do this job .
Regards
sathish
On Fri, Mar 6, 2009 at 1:21 AM, Joshua D. Drake j...@commandprompt.comwrote:
On Fri, 2009-03-06 at 01:09 +0530, Sathish
Sure , i 'll try with our database log
Regards
sathish
On Tue, Nov 4, 2008 at 5:55 PM, sathiya psql [EMAIL PROTECTED] wrote:
Dear All,
Recently i have released the next version of the epqa. which is a very
useful tool for, gives input for optimizing psql queries, and fine tuning
it.
Dear murali,
We use psql for our ERP software .We found CREATE TYPE is useful in creating
new data type similar to creating domain.
For eg
CREATE TYPE date_condition (
condition_id int,
from_date date,
to_datedate);
Instead ,
as cursor
SQL state: 42P11
Context: PL/pgSQL function fun_orderreport line 30 at for over execute
statement
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
*Sent:* Tuesday, August 12, 2008 6:53 PM
*To:* 'Willy-Bas Loos'
*Cc:* 'Sathish Duraiswamy'; 'pgsql-general@postgresql.org
