Re: Configure Postgres From SQL

Le 12/07/2010 17:02, Tom Wilcox a écrit :
> Hi Thom,
>
> Yeah They can be divided up, but my main issue is that I would like
> these functions wrapped up so that the client (who has little to no
> experience using PostgreSQL) can just run a SQL function that will
> execute all of these updates and prepare many tables and functions for a
> product. (Essentially SELECT install_the_program() to setup up the DB
> and build the tables).
>
> However, I keep running into problems because the queries are very time
> consuming (several days on fast computers with lots of memory) and
> individual queries seem to require different configuration parameters..
>
> I have a feeling it is all going to boil down to writing a (python)
> script to build the DB from CLI in Linux. But they really want all the
> functionality encapsulated in the PostgreSQL server, including this
> building process.
>

Well, you can still use the adminpack contrib module to write the config
file from a PostgreSQL connection. But you won't be able to restart
PostgreSQL.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com