pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReplication, HA ...?
4+ messages / 4 participants
[nested] [flat]
* Replication, HA ...?
@ 2008-06-16 07:46 Andreas Kraftl <andreas.kraftl@kraftl.at>
0 siblings, 2 replies; 4+ messages in thread
From: Andreas Kraftl @ 2008-06-16 07:46 UTC (permalink / raw)
To: pgsql-admin
Hello,
I have a webserver with postgresql. I would have a backup from this
database. It should also be possible to query this backup solution.
So I think slony would be a good choice. Am I right?
Thanks for answers
Andreas
--
Kraftl EDV - Dienstleistungen
Schulungen, Linux, Linuxlösungen, Webprogrammierung
Autofabrikstraße 16/6, 1230 Wien, Österreich
http://www.kraftl.at/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Replication, HA ...?
@ 2008-06-16 08:55 CZUCZY Gergely <phoemix@harmless.hu>
parent: Andreas Kraftl <andreas.kraftl@kraftl.at>
1 sibling, 1 reply; 4+ messages in thread
From: CZUCZY Gergely @ 2008-06-16 08:55 UTC (permalink / raw)
To: Andreas Kraftl <andreas.kraftl@kraftl.at>; +Cc: pgsql-admin
Check out cybercluster at http://www.postgresql.at/
It's free, however the support can cost a bit. But the software itself is free,
and it's built on postgresql8.2.
On Mon, 16 Jun 2008 09:46:57 +0200
Andreas Kraftl <andreas.kraftl@kraftl.at> wrote:
> Hello,
>
> I have a webserver with postgresql. I would have a backup from this
> database. It should also be possible to query this backup solution.
> So I think slony would be a good choice. Am I right?
>
> Thanks for answers
> Andreas
--
Üdvölettel,
Czuczy Gergely
Harmless Digital Bt
mailto: gergely.czuczy@harmless.hu
Tel: +36-30-9702963
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Replication, HA ...?
@ 2008-06-16 11:02 Vishal Arora <aroravishal22@hotmail.com>
parent: CZUCZY Gergely <phoemix@harmless.hu>
0 siblings, 0 replies; 4+ messages in thread
From: Vishal Arora @ 2008-06-16 11:02 UTC (permalink / raw)
To: CZUCZY Gergely <phoemix@harmless.hu>; Andreas Kraftl <andreas.kraftl@kraftl.at>; +Cc: pgsql-admin
YOu can also check out PgPool II http://pgpool.projects.postgresql.org/
you can get parallel querying and stand by solutions using pgpool II. it also offers HA & LB solutions.
> Date: Mon, 16 Jun 2008 10:55:23 +0200> From: phoemix@harmless.hu> To: andreas.kraftl@kraftl.at> CC: pgsql-admin@postgresql.org> Subject: Re: [ADMIN] Replication, HA ...?> > Check out cybercluster at http://www.postgresql.at/; It's free, however the support can cost a bit. But the software itself is free,> and it's built on postgresql8.2.> > On Mon, 16 Jun 2008 09:46:57 +0200> Andreas Kraftl <andreas.kraftl@kraftl.at> wrote:> > > Hello, > > > > I have a webserver with postgresql. I would have a backup from this> > database. It should also be possible to query this backup solution.> > So I think slony would be a good choice. Am I right?> > > > Thanks for answers> > Andreas> > > -- > Üdvölettel,> > Czuczy Gergely> Harmless Digital Bt> mailto: gergely.czuczy@harmless.hu> Tel: +36-30-9702963
_________________________________________________________________
Timely update on all current affairs, sports, events and all thats in News here on MSN videos.
http://video.msn.com/?mkt=en-in=
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Replication, HA ...?
@ 2008-06-16 12:21 Marcin Kasperski <Marcin.Kasperski@softax.com.pl>
parent: Andreas Kraftl <andreas.kraftl@kraftl.at>
1 sibling, 0 replies; 4+ messages in thread
From: Marcin Kasperski @ 2008-06-16 12:21 UTC (permalink / raw)
To: pgsql-admin
> I have a webserver with postgresql. I would have a backup from this
> database. It should also be possible to query this backup solution.
> So I think slony would be a good choice. Am I right?
Slony will replicate the data from selected tables for you, and the
replicated database will be available for queries. So it will work for
you unless you face performance limits, or have some problem with
asynchronous updates, or find Slony setup to be too difficult.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-06-16 12:21 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-16 07:46 Replication, HA ...? Andreas Kraftl <andreas.kraftl@kraftl.at>
2008-06-16 08:55 ` CZUCZY Gergely <phoemix@harmless.hu>
2008-06-16 11:02 ` Vishal Arora <aroravishal22@hotmail.com>
2008-06-16 12:21 ` Marcin Kasperski <Marcin.Kasperski@softax.com.pl>
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