Re: Scripting a new db server setup

Thanks Doug! I got some weird errors though when trying to run a command to create db, create user, create elements from the pgAdmin sql editor. I was trying to test and in a nutshell it not allow me to create the db in the same script as everything else, because I seperated the parts and it worked fine.
 
Thanks Karsten, but I was unsure of what I was looking at.
 
Alex

Doug McNaught <doug@mcnaught.org> wrote:
A E 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