pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPG HA solution using DBRD
3+ messages / 2 participants
[nested] [flat]
* PG HA solution using DBRD
@ 2010-11-09 22:12 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 0 replies; 3+ messages in thread
From: Isabella Ghiurea @ 2010-11-09 22:12 UTC (permalink / raw)
To: pgsql-admin
Hi All,
I 'm testing a HA solution for a PG version 9.01 database configured
using DBRD for pg_xlog directory and user data /table space
partitions.( block disk changes are copied from master to slave )
the archive mode option is off for both master and slaver node, when I
power off master without a clean PG shutdown the slave database server
will not start. Bellow is the errror, what are my option to increase the
checkpoint frequency ?
archive_mode is off for both server
database system was interrupted; last known up at 2010-11-09 08:27:02 PST
2010-11-09 13:20:03 PST [8505]: [2-1] LOG: could not open file
"pg_xlog/00000001000000BC00000006" (log file 188, segment 6): No such
file or directory
2010-11-09 13:20:03 PST [8505]: [3-1] LOG: invalid primary checkpoint
record
2010-11-09 13:20:03 PST [8505]: [4-1] LOG: could not open file
"pg_xlog/00000001000000BC00000006" (log file 188, segment 6): No such
file or directory
2010-11-09 13:20:03 PST [8505]: [5-1] LOG: invalid secondary checkpoint
record
2010-11-09 13:20:03 PST [8505]: [6-1] PANIC: could not locate a valid
checkpoint record
2010-11-09 13:20:03 PST [8499]: [2-1] LOG: startup process (PID 8505)
was terminated by signal 6: Aborted
2010-11-09 13:20:03 PST [8499]: [3-1] LOG: aborting startup due to
startup process failure
postgres@proc5-15:errorlog$
Thank you
Isabella
--
-----------------------------------------------------------
Isabella A. Ghiurea
Isabella.Ghiurea@nrc-cnrc.gc.ca
Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html
National Research Council of Canada, Herzberg Institute of Astrophysics
5071 West Saanich Road, Victoria BC V9E 2E7, Canada
Phone: 250 363-3446 fax: 250 363-0045
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PG HA solution using DBRD
@ 2010-11-10 19:52 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 1 reply; 3+ messages in thread
From: Isabella Ghiurea @ 2010-11-10 19:52 UTC (permalink / raw)
To: tsoupl@gmail.com <tsoupl@gmail.com>; pgsql-admin
Thanks for reply.
DBRD cfg we have :primary/primary both of the servers can be used for
writes/active while only one will be active always and other one is
passive ( PG is offline)
the user data directories and pg_xlog is using DBRD, the PG software
directory and $PG_DATA is local on each server.
Isabella
tsoupl@gmail.com wrote:
> Hi,
>
> What king of configuration do you have on DRBD? is it Primary/primary
> or Primary secondary?
>
>
>
> On Nov 10, 2010 12:12am, Isabella Ghiurea
> <isabella.ghiurea@nrc-cnrc.gc.ca> wrote:
> > Hi All,
> >
> > I 'm testing a HA solution for a PG version 9.01 database configured
> using DBRD for pg_xlog directory and user data /table space
> partitions.( block disk changes are copied from master to slave )
> >
> > the archive mode option is off for both master and slaver node,
> when I power off master without a clean PG shutdown the slave
> database server will not start. Bellow is the errror, what are my
> option to increase the checkpoint frequency ?
> >
> > archive_mode is off for both server
> >
> >
> >
> > database system was interrupted; last known up at 2010-11-09
> 08:27:02 PST
> >
> > 2010-11-09 13:20:03 PST [8505]: [2-1] LOG: could not open file
> "pg_xlog/00000001000000BC00000006" (log file 188, segment 6): No such
> file or directory
> >
> > 2010-11-09 13:20:03 PST [8505]: [3-1] LOG: invalid primary
> checkpoint record
> >
> > 2010-11-09 13:20:03 PST [8505]: [4-1] LOG: could not open file
> "pg_xlog/00000001000000BC00000006" (log file 188, segment 6): No such
> file or directory
> >
> > 2010-11-09 13:20:03 PST [8505]: [5-1] LOG: invalid secondary
> checkpoint record
> >
> > 2010-11-09 13:20:03 PST [8505]: [6-1] PANIC: could not locate a
> valid checkpoint record
> >
> > 2010-11-09 13:20:03 PST [8499]: [2-1] LOG: startup process (PID
> 8505) was terminated by signal 6: Aborted
> >
> > 2010-11-09 13:20:03 PST [8499]: [3-1] LOG: aborting startup due to
> startup process failure
> >
> > postgres@proc5-15:errorlog$
> >
> > Thank you
> >
> > Isabella
> >
> >
> >
> > --
> >
> > -----------------------------------------------------------
> >
> > Isabella A. Ghiurea
> >
> > Isabella.Ghiurea@nrc-cnrc.gc.ca
> >
> > Canadian Astronomy Data Centre
> |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National
> Research Council of Canada, Herzberg Institute of Astrophysics 5071
> West Saanich Road, Victoria BC V9E 2E7, Canada
> >
> > Phone: 250 363-3446 fax: 250 363-0045
> >
> >
> >
> >
> >
> > --
> >
> > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> >
> > To make changes to your subscription:
> >
> > http://www.postgresql.org/mailpref/pgsql-admin
> >
--
-----------------------------------------------------------
Isabella A. Ghiurea
Isabella.Ghiurea@nrc-cnrc.gc.ca
Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html
National Research Council of Canada, Herzberg Institute of Astrophysics
5071 West Saanich Road, Victoria BC V9E 2E7, Canada
Phone: 250 363-3446 fax: 250 363-0045
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PG HA solution using DBRD
@ 2010-11-11 08:04 tsoupl@gmail.com
parent: Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 0 replies; 3+ messages in thread
From: tsoupl@gmail.com @ 2010-11-11 08:04 UTC (permalink / raw)
To: Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>; tsoupl@gmail.com <tsoupl@gmail.com>; +Cc: pgsql-admin
Actually, if you are using DRBD as shared disk HA solution (am I correct or
you are using postgresql replication, like streaming and hot standby?),
then all the PG_DATA directory has to be on DRBD.
So, if you power off your 1st node and start your second (pointing the same
DRBD PG_DATA directory) it will continue from were the 1st node stopped (if
fsync was enabled, if not you may loose the last entries performed on
memory but not committed on disk). For this to happen you have to change
the data path of the second nodes postgresql script, found under
/etc/init.d/ to point to DRBD's $PG_DATA directory.
Hope I was helpful.
On Nov 10, 2010 9:52pm, Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
wrote:
> Thanks for reply.
> DBRD cfg we have :primary/primary both of the servers can be used for
> writes/active while only one will be active always and other one is
> passive ( PG is offline)
> the user data directories and pg_xlog is using DBRD, the PG software
> directory and $PG_DATA is local on each server.
> Isabella
> tsoupl@gmail.com wrote:
> Hi,
> What king of configuration do you have on DRBD? is it Primary/primary or
> Primary secondary?
> On Nov 10, 2010 12:12am, Isabella Ghiurea
> isabella.ghiurea@nrc-cnrc.gc.ca> wrote:
> > Hi All,
> >
> > I 'm testing a HA solution for a PG version 9.01 database configured
> using DBRD for pg_xlog directory and user data /table space partitions.(
> block disk changes are copied from master to slave )
> >
> > the archive mode option is off for both master and slaver node, when I
> power off master without a clean PG shutdown the slave database server
> will not start. Bellow is the errror, what are my option to increase the
> checkpoint frequency ?
> >
> > archive_mode is off for both server
> >
> >
> >
> > database system was interrupted; last known up at 2010-11-09 08:27:02
> PST
> >
> > 2010-11-09 13:20:03 PST [8505]: [2-1] LOG: could not open
> file "pg_xlog/00000001000000BC00000006" (log file 188, segment 6): No
> such file or directory
> >
> > 2010-11-09 13:20:03 PST [8505]: [3-1] LOG: invalid primary checkpoint
> record
> >
> > 2010-11-09 13:20:03 PST [8505]: [4-1] LOG: could not open
> file "pg_xlog/00000001000000BC00000006" (log file 188, segment 6): No
> such file or directory
> >
> > 2010-11-09 13:20:03 PST [8505]: [5-1] LOG: invalid secondary checkpoint
> record
> >
> > 2010-11-09 13:20:03 PST [8505]: [6-1] PANIC: could not locate a valid
> checkpoint record
> >
> > 2010-11-09 13:20:03 PST [8499]: [2-1] LOG: startup process (PID 8505)
> was terminated by signal 6: Aborted
> >
> > 2010-11-09 13:20:03 PST [8499]: [3-1] LOG: aborting startup due to
> startup process failure
> >
> > postgres@proc5-15:errorlog$ >
> > Thank you
> >
> > Isabella
> >
> > >
> > --
> >
> > -----------------------------------------------------------
> >
> > Isabella A. Ghiurea
> >
> > Isabella.Ghiurea@nrc-cnrc.gc.ca
> >
> > Canadian Astronomy Data Centre |
> http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National
> Research Council of Canada, Herzberg Institute of Astrophysics 5071 West
> Saanich Road, Victoria BC V9E 2E7, Canada
> >
> > Phone: 250 363-3446 fax: 250 363-0045
> >
> >
> >
> >
> >
> > --
> >
> > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> >
> > To make changes to your subscription:
> >
> > http://www.postgresql.org/mailpref/pgsql-admin
> >
> --
> -----------------------------------------------------------
> Isabella A. Ghiurea
> Isabella.Ghiurea@nrc-cnrc.gc.ca
> Canadian Astronomy Data Centre |
> http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National
> Research Council of Canada, Herzberg Institute of Astrophysics 5071 West
> Saanich Road, Victoria BC V9E 2E7, Canada
> Phone: 250 363-3446 fax: 250 363-0045
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-11-11 08:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-11-09 22:12 PG HA solution using DBRD Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-11-10 19:52 Re: PG HA solution using DBRD Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-11-11 08:04 ` tsoupl@gmail.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox