pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org
Subject: PITR backup to Novell Netware file server
Date: Tue, 07 Aug 2007 06:29:35 -0500
Message-ID: <46B8114E.EE98.0025.0@wicourts.gov> (raw)

We have a database in each Wisconsin county which is part of the official
court record for the circuit courts in that county.  We are required to keep
a backup in each county, such that we could recover a lost or corrupted
database with what is in the county (as well as keeping at least four
separate sources, each regularly confirmed as usable, at our central site).
Currently, the only two boxes available besides the database server (in most
counties) are a "utility server" (a Windows desktop class machine used to
push workstation images and other support tasks) and a Novell Netware file
server.
 
We had to get something going quickly when we started rolling PostgreSQL out
to the counties as a replacement of a commercial database product; the quick
and (way too) dirty approach was to create a samba share on the utility
server for the target of the archive_command and our base backups.  We rsync
from there back to the central site using the samba share, too.  We
frequently lose the mount points or they become unresponsive.  We also
frequently have corrupted files when they rsync across the WAN, so we want
to move away from all use of samba.
 
The Netware server supports ssh, scp, and an rsync daemon.  I don't see how
the ssh implementation is helpful, though, since it just gets you to the
Netware console -- you can't cat to a disk file through it, for example.
(At least not as far as we have been able to see.)  It appears that the scp
and rsync techniques both require the initial copy of the file to be saved
on the database server itself, which we were hoping to avoid for performance
reasons.
 
We could create ncp mounts on the database servers; but, frankly, we haven't
had much better luck in keeping those connected than we have with samba.
Has anyone else been through this and found a robust and reliable way to
do PITR backups from a PostgreSQL database on one machine to a Netware file
server on another?
 
Apparently we will be moving to a Linux-based implementation of Netware at
some unspecified future date, at which point we will apparently be able to
deal directly with the Linux layer.  At that point, there are obvious, clean
solutions; but we've got to have something reasonable until such date, which
is most likely a few years off.
 
-Kevin
 





view thread (8+ messages)  latest in thread

Message-ID: <46B8114E.EE98.0025.0@wicourts.gov>
Permalink:  ../46B8114E.EE98.0025.0@wicourts.gov/
Also on:    postgresql.org/message-id/46B8114E.EE98.0025.0@wicourts.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov
  Subject: Re: PITR backup to Novell Netware file server
  In-Reply-To: <46B8114E.EE98.0025.0@wicourts.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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