[GENERAL] PostgreSQL Installation Question

2004-09-28 Thread Geisler, Jim
Title: Message I am trying to create an installer that will run PostgreSQL as a service onto a Windows machine( 2000 or Server 2003). The problem that I am having is that I need to have the database be initialized by a restricted windows user.  However, I do not want to demand that the user

[GENERAL] failure to restart postgresql service after improper shutdown

2004-09-29 Thread Geisler, Jim
Title: Message after an improper shutdown (power failure) the postgres service cannot be restarted. simply restoring the postmaster.pid does not allow the postgres service to start.   also, is there somekind of data integrity check built in with postgresql that can notify me of any data co

[GENERAL] Verifying Referential Integrity

2004-10-05 Thread Geisler, Jim
Title: Message So, as far as I know, PostgreSQL does not have any way of verifying the loss of referential integrity.   Are there any recommended methods or utilities for checking referential integrity in a PostgreSQL database?