[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 Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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: http://postgresql.1045698.n5.nabble.com/Error-with-pg-filenode-map-file-tp4723167p4723167.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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 PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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 PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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 - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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 mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/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 /projects/data_dir/data -l /projects/data_dir/data/pg_log/startup.log* Server was started but when I try connect to database I see in lgo such messages /FATAL: role postgres does not exist/ What is this? I use another user? -- View this message in context: http://postgresql.1045698.n5.nabble.com/call-initdb-as-regular-user-tp4712980p4714889.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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 list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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 processes ... create database waiting for 0/XX and when I strace to wal I see ... select ... timeout getpid() select ... timeout getpid() ... and so on. What so '*' mean in this GUC? version 9.1beta3 linux x86_64 -- View this message in context: http://postgresql.1045698.n5.nabble.com/synchronous-standby-names-with-tp4715117p4715117.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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 mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/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 Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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 Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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:
http://postgresql.1045698.n5.nabble.com/call-initdb-as-regular-user-tp4712980p4713090.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[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 archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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 make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
