postgres scripting - Mailing list pgsql-admin

From John P Weatherman
Subject postgres scripting
Date
Msg-id 1253136362.13716.38.camel@darkflame.weatherman.net
Whole thread Raw
Responses Re: postgres scripting
Re: postgres scripting
List pgsql-admin
Hi all,

I have to reindex 2 indexes in pg_catalog using postgres --single.
There are 16 seperate databases on each of 4 servers that I have to do
this on, so obviously it would be much better to script the changes.  I
can handle identifying the dbs and starting postgres no problem, but I
can't seem to find a way to pass a CTRL-D character from within a bash
script to the postgres executable.

Has anyone done anything like this?  Any suggestions? I am running
postgres 3.1.1.8 on Solaris 5.10.

Thanks!

John


John P Weatherman
Sr DBA
Asurion, Inc.


pgsql-admin by date:

Previous
From: "Dmitry Samokhin"
Date:
Subject: pgAgent Windows service startup time
Next
From: "Kevin Grittner"
Date:
Subject: Re: postgres scripting