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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
