[GENERAL] Wal archiving and streaming replication

Hi! Do I need setup wal archiving (archiving_mode = on) setup when I use streaming replication? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Wal-archiving-and-streaming-replication-tp4726040p4726040.html Sent from the PostgreSQL - general mailing list archive at

[GENERAL] Error with pg_filenode.map file

Hi! Sometimes I got this error FATAL: could not open relation mapping file global/pg_filenode.map: No such file or directory and after restart computer all is fine. What mean this? -- View this message in context:

[GENERAL] pg_controldata return wrong version

Hi! I use postgresql version 9.1beta3 and use pg_controldata and when I see first row pg_controldata version number: 903 Is this right version? -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-controldata-return-wrong-version-tp4723194p4723194.html Sent from the

[GENERAL] Streaming replication without hot standby

Hi! If I use streaming replication must I setup hot stanby mode on my slave-server? If not then this server would not accept any connections? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-replication-without-hot-standby-tp4719918p4719918.html Sent from the

Re: [GENERAL] Streaming replication without hot standby

So, how can I check is the slave-server up and properly work (recovery is in progress) in this case? Check the log for some messages? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-replication-without-hot-standby-tp4719918p4720156.html Sent from the PostgreSQL

Re: [GENERAL] Streaming replication without hot standby

But still, how to do it (check server state) in this case? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-replication-without-hot-standby-tp4719918p4720634.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general

Re: [GENERAL] call initdb as regular user

I call initdb with such params */opt/PostgreSQL/9.1/bin/initdb -D /projects/data_dir/data -E UTF-8 -U u*ser after that create pg_log dir when I would create log (but why I must do this step?) change hba file and start database server with this command /*opt/PostgreSQL/9.1/bin/pg_ctl start -w -D

Re: [GENERAL] call initdb as regular user

sorry, my mistake when I connect to user I set login to postgres -- View this message in context: http://postgresql.1045698.n5.nabble.com/call-initdb-as-regular-user-tp4712980p4714912.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing

[GENERAL] synchronous_standby_names with '*'

Hi! I try create master for replication and in his config I set synchronous_standby_names = '*' so I can connect with other slave's (name of this slave I don't know at this moment) But if I try execute some commands (I hung on 'create database') my program hang and after some time I see in

Re: [GENERAL] synchronous_standby_names with '*'

but if I don't have any slave at this time why my command hang? -- View this message in context: http://postgresql.1045698.n5.nabble.com/synchronous-standby-names-with-tp4715117p4715224.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general

Re: [GENERAL] synchronous_standby_names with '*'

so can I somehow disable|enable synchronous replication at runtime (not only for session but for the server)? -- View this message in context: http://postgresql.1045698.n5.nabble.com/synchronous-standby-names-with-tp4715117p4715296.html Sent from the PostgreSQL - general mailing list archive at

[GENERAL] call initdb as regular user

Hi! Can I call initdb with some params as regular user (not root or postgres)? May I have some problem with replication, backup or with some other subsystem? Thank you! -- View this message in context: http://postgresql.1045698.n5.nabble.com/call-initdb-as-regular-user-tp4712980p4712980.html

Re: [GENERAL] call initdb as regular user

I have some single-purpose system and user can interact only with special software (on computer would start only this software{daemon and gui}, postgresql and other system daemons). And I don't wont change user when I call psql, pg_ctl, rsync and other stuff. -- View this message in context:

Re: [GENERAL] Run server recovery

Or recovery mode start only when server load? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Run-server-recovery-tp4707673p4707685.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list

[GENERAL] Run server recovery

Hi! Can I on server which is master (already work) run recovery mode: 1. start server 2. change recovery.conf 3. reload config ? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Run-server-recovery-tp4707673p4707673.html Sent from the PostgreSQL - general mailing list

Re: [GENERAL] Change master to standby

Thank you for the answer! -- View this message in context: http://postgresql.1045698.n5.nabble.com/Change-master-to-standby-tp4703925p4707810.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To