[GENERAL] warm standby sheme and postgres service stoping

2009-09-09 Thread Alexandr Varlamov
I use postgres 8.3 on Windows I try to realize warm standby sheme, described in Chapter 24. Backup and Restore in postgres docs (http://www.postgresql.org/docs/8.3/interactive/warm-standby.html#WARM-STANDBY-RECORD). When i try to stop postgres server, it can't be stop because 'restore_command'

[GENERAL] Keys and indexes

2009-09-01 Thread Alexandr Varlamov
Does indexing working for foreignkeys column automaticaly? Or i need create index manually. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] service stopping and pg_standby on windows

2009-07-23 Thread Alexandr Varlamov
Hello. I use postgres on windows and try setup warm standby. For restore_command i use pg_standby program. When i try to stop postgres service, that runs in recovery mod, service not stopping correctly, because pg_standby still works. Thanks. -- Sent via pgsql-general mailing list (pgsql-