Re: Scripting a new db server setup

Douglas McNaught <doug@mcnaught.org>

From: Doug McNaught <doug@mcnaught.org>
To: A E <cooljoint@yahoo.com>
Cc: pgsql-general@postgresql.org
Date: 2004-01-04T15:57:05Z
Lists: pgsql-general
A E <cooljoint@yahoo.com> writes:

>    Hi,
>
>
>
>    Was wondering if there are ways to completely script a new postgresql
>    installation. I need to be able to create the db, users, and db
>    elements from one command so that I can included it in a setup
>    routine.

Absolutely--write SQL scripts that do the work and feed them to 'psql'
in a shell script.  

-Doug