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 Nabbl
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 Po
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-tp4723
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 m
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
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 Po
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 N
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
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 process
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
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 /
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:
htt
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
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
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 arch
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@postgres
16 matches
Mail list logo