Hello, I want to discuss a little bit about the following situation: I only have one server for my databases.I had to develope on this server and also had to manage several databases, so I can expect problems if I had to restart postgreSQL, if I changed the logging..... What do you think about this solution: For each database I want to let run one server, and the different servers a located in /usr/local/pgsql-733-1 data-dir: /db/pgsql-1 /usr/local/pgsql-733-2 data.......................
Is this a good idea? What problems can happen? I compile postgreSQL only with the --prefix flag. What things I should do? Each db got his own user, like postgres1, postgres2 or pgsql7331,....... I sometimes need to log everything, but this is maybe once or twice a week, but I can't restart the server during the day. Daniel ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
