On Thu, Sep 19, 2013 at 11:31 AM, ascot.m...@gmail.com
>>> <mailto:ascot.m...@gmail.com> >> <mailto:ascot.m...@gmail.com>> wrote:
>>>
>>>I use PG 9.2.4 with streaming replication. What will be the
>>>manual procedure to failover from Prim
Hi,
I use PG 9.2.4 with streaming replication. What will be the manual procedure
to failover from Primary to Standby and Set the old Primary as a new standby?
step 1: standby's recovery.conf :
# Specifies a trigger file whose presence should cause streaming replication to
end (i.e., failover
Hi,
I am using pg 9.2.4 and ubuntu 12.04 to set up a pair of pg-Master and pg-Slave
with streaming replication.
The archive_command is enabled and the "rsync" is used in pg-Master to save all
its archived WAL files to the 3rd machine for backup purpose, by default, both
fsync and wal_sync_
Hi, any idea? can you please advise?
On 10 Sep 2013, at 3:22 AM, ascot.m...@gmail.com wrote:
> Hi,
>
> For special testing reason, I am trying to restore PG from a backup that the
> basebase is from Standby and WAL files are from Master. During recovery
> phase, for every W
Hi,
For special testing reason, I am trying to restore PG from a backup that the
basebase is from Standby and WAL files are from Master. During recovery phase,
for every WAL file process, it returned 'invalid resource manager ID in primary
checkpoint record' and paused, I had to manually run "
Hi,
From the pg_xlog folder, I found some files with interesting time stamps: older
file names with newer timestamps, can you please advise why?
Set 1: How come 00040F49008D is 10 minutes newer than
00040F49008E?
-rw--- 1 111 115 16777216 Sep 4 15:28 00040F4
Hi,
I am planing to backup archived WAL files from master to another machine, is
there a way to check and make sure the backup archive file are all good and no
any file missing or corrupted?
regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
sage.
>
>
> On Tue, Sep 3, 2013 at 12:14 PM, Raghavendra
> wrote:
> On Tue, Sep 3, 2013 at 11:36 AM, ascot.m...@gmail.com
> wrote:
> Hi,
>
> Can you please advise how to find out all unused indexes in PG?
>
> regards
>
> Below wiki link should help; und
Hi,
Can you please advise how to find out all unused indexes in PG?
regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I am planning Streaming Replication to a new remote server, can you please
suggest how to set up data encryption by SSL or tunnelling in Postgresql?
regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
Thanks so much.
On 11 Aug 2013, at 9:50 PM, Michael Paquier wrote:
> On Sun, Aug 11, 2013 at 5:51 AM, ascot.m...@gmail.com
> wrote:
>> Hi,
>>
>> I have a pair of PG servers, a master and a replica, all read-write queries
>> are handled by the master, rea
Thanks so much.
On 11 Aug 2013, at 7:36 PM, Jov wrote:
> This means the slave meet the end of the WAL when it replay the WAL
> files/records.The message level is "LOG",so it can be safely ignored.
>
> Jov
> blog: http:amutu.com/blog
>
>
> 2013/8/11 ascot.
Hi,
I want to archive WAL log files in the replication server as well, the
postgresql.conf is added with following new lines, after restarting PG, the
/var/pgsql/data/archive/ is still empty after 1 hour:
### new lines added today
#
# to enable the replica as Hot Standby
hot_standby = on
#
#
Hi,
I found 'LOG: invalid magic number in log file 169, segment 77, offset
4325376" from the replica's log:
LOG: entering standby mode
LOG: redo starts at A8/BE81B200
LOG: consistent recovery state reached at A9/4CF8
LOG: database system is ready to accept read only connections
LOG
Hi,
I have a pair of PG servers, a master and a replica, all read-write queries are
handled by the master, read-only ones are by the replica.
>From time to time the replica itself is too busy, all read-only queries will
>get inconsistent results because of replication lag, sometimes it can
hi
>> 16:47:12
SELECT pg_start_backup('hot_backup');
"tar cfP" the PG "data" folder
SELECT pg_stop_backup();
regards
On 9 Aug 2013, at 9:55 PM, Albe Laurenz wrote:
> ascot.m...@gmail.com wrote:
>> I am trying another way to test PITR: by recovery
Hi,
I am trying another way to test PITR: by recovery_target_time.
The test machine has the same PG version 9.2.4 and same O/S Ubuntu 12.04 64
bit.All archived WAL files are shipped and saved in
/var/pgsql/data/archive, the latest time stamp of them is "2013-08-09
19:30:01", the full hot b
On 9 Aug 2013, at 7:09 PM, Luca Ferrari wrote:
> Uhm...I guess the problem is not about the txid being included or not:
> the recovery target was 75634 and the transaction 75666 appeared, so
> the problem seems to be an out-of-order commit of the transactions. In
> such case making the inclusive
Hi,
I have enabled archive in PG (v 9.2.4):
archive_mode = on
archive_command = 'test ! -f /usr/local/pgsql/data/archive/%f && cp %p
/usr/local/pgsql/data/archive/%f'
I know that pg_xlog folder is maintained by PostgreSQL automatically, when the
pg_xlog folder hits to certain limit (pg_xlog
Hi,
I am trying PITR in a test machine (same PG version 9.2.4 same O/S Ubuntu 12.04
64 bit). All archived WAL files are shipped and saved in
/var/pgsql/data/archive, the latest transaction txid of them is 75666. I want
to recover PG at a point of time that if XIDs are equal or smaller than
Hi,
I am trying some restore tools, can you advise how to find the latest
transaction ID in PostgreSQL and the transaction ID at a particular
"Point-In-Time"?
regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgr
Thanks. I increased the wal_keep_segments and it works well now.
On 7 Aug 2013, at 12:43 AM, Jerry Sievers wrote:
> "ascot.m...@gmail.com" writes:
>
>> Hi,
>>
>> I just tried another round of tests, without running "sync; echo 3 >
>> /proc/
primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment
000100120005 has already been removed
On 6 Aug 2013, at 12:39 PM, ascot.m...@gmail.com wrote:
> Hi,
>
> I found the problem should be because I tried to clean RAM cache in the slave
&g
Thanks, there was a typo of the line "hot_standby", it works now, thanks again.
On 6 Aug 2013, at 6:52 PM, Haribabu kommi wrote:
>
> On 06 August 2013 16:13 ascot.moss wrote
>> Hi,
>
>> I just setup the replication in the slave again, when trying to use psql, I
>> could not get the psql comman
Hi,
I just setup the replication in the slave again, when trying to use psql, I
could not get the psql command prompt but got "psql: FATAL: the database
system is starting up" from it.
PG: 9.2.4
Below is the log from the the slave:
LOG: database system was shut down in recovery at 2013-08-0
: wal receiver
process streaming D/FB8DA000
sync; echo 3 > /proc/sys/vm/drop_caches
ps -ef | grep receiver
root 8804 30447 0 12:29 pts/200:00:00 grep --color=auto receiver
regards
On 6 Aug 2013, at 10:44 AM, ascot.m...@gmail.com wrote:
> Hi,
>
> I am doing some stre
Hi,
I am doing some stress tests to a pair of PG servers to monitor the
pg_stat_replication, during the test, the pg_stat_replication suddenly became
empty.
PG version: 9.2.4
O/S: Ubuntu: 12.04
Since I need to monitor the replication lag from time to time, if the
pg_stat_replication becomes
Hi,
I am trying to load CSV files into postgresql via pgloader, it returned the
following error, any suggestions to fix it?
I have a line "lc_messages = C" in my pgloader.conf, would this line cause the
problem?
regards
pgloader ERRORpermission denied to set parameter "lc_messages"
p
Hi,
if I change the value of "vacuum_cost_delay", what is the impact of it on
autovacuum side?
regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi John,
On 17 Apr 2013, at 11:30 AM, John R Pierce wrote:
> on AIX, I build mine to run in /opt/$MYGROUP/pgsql/9.2 and I just tar it up
> and distribute it as a tarball to my operations people. I'd previously asked
> them if they wanted it as a system package, and their response was 'why
> bo
Hi,
I have managed to install 9.2.4 to an IBM Power System server ppc64 by
compiling pg 9.2.4 from source as I cannot find the 9.2.4 installer package for
ppc64. Can anyone advise me how to build my own installer package for ppc64
(e.g. tools, steps)? since I have more than one ppc64 server a
Hi,
I have two IBM Power System servers, the architecture is ppc64, the PostgreSQL
on RHEL6 for IBM Power is version 8.4 but I need to install 9.2.4 as I need to
use the PostgreSQL replication features.
I am new to PostgreSQL on ppc64, can any one advise me where to get the proper
9.2.4 insta
32 matches
Mail list logo