Your message dated Thu, 22 Sep 2005 00:31:52 +0200
with message-id <[EMAIL PROTECTED]>
and subject line postgresql: It would be nice if there were some backup
utilities
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 3 Jul 2000 16:08:41 +0000
>From [EMAIL PROTECTED] Mon Jul 03 11:08:41 2000
Return-path: <[EMAIL PROTECTED]>
Received: from pb20.wroclaw.cvx.ppp.tpnet.pl (tenet.pl) [213.76.88.20] (qmailr)
by master.debian.org with smtp (Exim 3.12 2 (Debian))
id 1398ly-0005OB-00; Mon, 03 Jul 2000 11:08:39 -0500
Received: (qmail 869 invoked by uid 1001); 29 Jun 2000 19:22:10 -0000
Date: 29 Jun 2000 19:22:10 -0000
Message-ID: <[EMAIL PROTECTED]>
From: Grzegorz Stelmaszek <[EMAIL PROTECTED]>
Subject: postgresql: It would be nice if there were some backup utilities
To: [EMAIL PROTECTED]
X-Mailer: bug 3.3.2
Delivered-To: [EMAIL PROTECTED]
Package: postgresql
Version: 7.0-release-1
Severity: wishlist
Every db engine has some backup utilities - some are more advanced the other is
simple. From an administrative purposes backup is essencial for the db to work
fine. It would be nice if postgres support some better backup utilities than
either pg_dump or file backup. It would be nice if there is possible some
differential or transcation log backups which would be much faster. Also that
would be cool if there is a possiblity to backup/restore db from psql agent
throught f.e. BACKUP/RESTORE commands. It would help very much in
administration of postgresql based databases.
regards,
greg
-- System Information
Debian Release: 2.2
Kernel Version: Linux debian 2.2.13 #1 SMP Fri Apr 14 16:45:45 CEST 2000 i686
unknown
Versions of the packages postgresql depends on:
ii debianutils 1.13.3 Miscellaneous utilities specific to Debian.
ii libc6 2.1.3-10 GNU C Library: Shared libraries and Timezone
ii libncurses5 5.0-6 Shared libraries for terminal handling
ii libpgsql2 7.0-release-1 Shared library libpq.so.2 for PostgreSQL
ii libreadline4 4.1-1 GNU readline and history libraries, run-time
ii postgresql-cli 7.0-release-1 Front-end programs for PostgreSQL
ii procps 2.0.6-7 The /proc file system utilities.
--- Begin /etc/init.d/postgresql (modified conffile)
#! /bin/sh
startup () {
/usr/lib/postgresql/bin/postgresql-startup > /dev/null 2> /dev/null
}
POSTMASTER=/usr/lib/postgresql/bin/postmaster
case "$1" in
start)
startup
;;
stop)
echo Stopping PostgreSQL postmaster
start-stop-daemon --stop --verbose --exec ${POSTMASTER} || exit 0
;;
restart)
echo Restarting PostgreSQL postmaster
start-stop-daemon --stop --oknodo --verbose --exec ${POSTMASTER}
sleep 3
startup
;;
force-reload)
echo Reload not supported by PostgreSQL - restarting postmaster
start-stop-daemon --stop --oknodo --verbose --exec ${POSTMASTER}
sleep 3
startup
;;
reload)
echo PostgreSQL does not support a reload option
exit 2
;;
*)
echo "Usage: /etc/init.d/postgresql {start|stop|restart}"
exit 1
;;
esac
exit 0
--- End /etc/init.d/postgresql
--- Begin /etc/postgresql/postmaster.init (modified conffile)
POSTGRES_HOME=`grep '^postgres:' /etc/passwd | awk -F: '{print $6}' | head -1`
if [ -z "$POSTGRES_HOME" ]
then
POSTGRES_HOME=/var/lib/postgres
fi
PGBACKENDCOUNT=64
PGBUFFERS=256
PGDEBUG=2
PGECHO=yes
PGFSYNC=no
PGDATESTYLE=EURO
PGSORTMEM=4096
PGSTATS=yes
PGALLOWTCPIP=yes
--- End /etc/postgresql/postmaster.init
--- Begin /etc/postgresql/pg_hba.conf (modified conffile)
host all 127.0.0.1 255.255.255.255 password
host all 192.168.0.0 255.255.0.0 password
local all trust
host all 127.0.0.1 255.255.255.255 trust
--- End /etc/postgresql/pg_hba.conf
---------------------------------------
Received: (at 66663-done) by bugs.debian.org; 21 Sep 2005 22:32:25 +0000
>From [EMAIL PROTECTED] Wed Sep 21 15:32:25 2005
Return-path: <[EMAIL PROTECTED]>
Received: from box79162.elkhouse.de [213.9.79.162]
by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
id 1EID8b-0003Nu-00; Wed, 21 Sep 2005 15:32:25 -0700
Received: from localhost.localdomain (unknown [195.227.105.180])
(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
(Client CN "Martin Pitt (workstation)", Issuer "piware CA" (verified
OK))
by box79162.elkhouse.de (Postfix) with ESMTP id 0EAF819637F
for <[EMAIL PROTECTED]>; Thu, 22 Sep 2005 00:31:53 +0200 (CEST)
Received: by localhost.localdomain (Postfix, from userid 1000)
id 2D1C93413D; Thu, 22 Sep 2005 00:31:52 +0200 (CEST)
Date: Thu, 22 Sep 2005 00:31:52 +0200
From: Martin Pitt <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: postgresql: It would be nice if there were some backup utilities
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="CdrF4e02JqNVZeln"
Content-Disposition: inline
User-Agent: Mutt/1.5.9i
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
--CdrF4e02JqNVZeln
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Package: postgresql-8.0
Version: 8.0.3-1
Hi Grzegorz!
> Every db engine has some backup utilities - some are more advanced
> the other is simple. From an administrative purposes backup is
> essencial for the db to work fine. It would be nice if postgres
> support some better backup utilities than either pg_dump or file
> backup. It would be nice if there is possible some differential or
> transcation log backups which would be much faster. Also that would
> be cool if there is a possiblity to backup/restore db from psql
> agent throught f.e. BACKUP/RESTORE commands. It would help very much
> in administration of postgresql based databases.
8.0 has some fairly flexible "Point in time recovery" backup mechanism
that is described at
http://www.postgresql.org/docs/8.0/interactive/backup-online.html
This is much more powerful than the old pg_dump approach (which still
works, of course). So I guess we can finally close this ancient bug
report. :-)
Thanks and have a nice day,
Martin
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org
--CdrF4e02JqNVZeln
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFDMd9YDecnbV4Fd/IRAiuSAKDg49Qb5INbnu4Pq1pSfizLb1xfYACdEH92
OtDOfCfu0J7RZ+d9558hiCo=
=u4pO
-----END PGP SIGNATURE-----
--CdrF4e02JqNVZeln--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
