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