Where: What is the best way to get a copy of the 8.4 beta? I've
searched around, but couldn't find a reliable direction on this
subject.
http://yum.pgsqlrpms.org/news-8.4devel-ready-for-testing.php
Note these are development RPMs.
When: Is there any official word on when 8.4 will be
On Wed, Feb 11, 2009 at 3:05 PM, Devrim GÜNDÜZ dev...@gunduz.org wrote:
Hi,
I downloaded RHEL5 rpm files for the latest 8.1.16 release and could not
find the MD5 file for them.
http://ftp9.us.postgresql.org/pub/mirrors/postgresql/binary/v8.1.16/linux/rpms/redhat/rhel-5-i386/
8.1.15
Hello,
I downloaded RHEL5 rpm files for the latest 8.1.16 release and could not
find the MD5 file for them.
http://ftp9.us.postgresql.org/pub/mirrors/postgresql/binary/v8.1.16/linux/rpms/redhat/rhel-5-i386/
8.1.15 RHEL5 roms had them,
Hello all,
I have been doing PITR backups for a while to a backup server via NFS. It's
working great.
I have to shutdown the backup server for hardware/OS upgrade. I expect this
upgrade will last a week.
How do I turn off PITR in the mean time? I commented archive_command and
issued a pg_ctl
Hello all,
I inherited a 8.1.x database of size 200GB. This database hasn't been
maintained much (autovac is enabled though).
I been trying to VACUUM this db for the past few days for a couple of
hours/day. The server runs 24x7 so continuous maintenance is not possible
(this is the last
Hello,
I'd like to get the path configured for archive_command in a shell script
I've used a file with following content as an example (postgresql.conf),
# archive_command = cp %p /backup/%r
# archive_command = cp %p /backup/%r
# archive_command = cp %p /backup/%r
#archive_command =
Hello,
I've created a table in public schema,
CREATE TABLE public.foo (fooid SERIAL);
When I try to create a table in database nowhere that references public.foo
table,
CREATE DATABASE nowhere;
\c nowhere;
CREATE TABLE bar (bar integer REFERENCES public.foo(fooid));
I get, ERROR: relation
Hello,
I'm not a DBA nor an architect. I learn from the wise and by making
mistakes.
I'm in the process of developing a web application and need some advice from
you all,
Requirements:
==
* Application runs 24/7
* Application must support either PostgreSQL or another commercial
Hello,
Thanks for advice/suggestions on PITR so far.
We have finally decided to do weekly PITR base backups. Just have one
nagging question.
== week 1==-
* pg_start_backup()
* tar -cvzf basebackup_week1.tar.gz pgdata/
* pg_stop_backup()
cp WAL1 week1/wal/
..
cp WAL2 week1/wal/
==*==
Week 1,
Hello,
Just to be sure of our backups we plan to do a base + full backups (yes, we
are overly paranoid)
(1) pg_start_backup(`date`)
(2) perform hot rsync first (while the database is running)
$ rsync -avr pgdata /backup/`date`/
(3) stop pg
(4) perform cold rsync
$ rsync -avr --delete pgdata
On Wed, May 14, 2008 at 4:35 PM, Martin Marques [EMAIL PROTECTED]
wrote:
Please, can someone explain how is it posible for ALTER TABLE to add a
primary key column to a table without some intruction that would make it a
real PK (NOT NULL and UNIQUE).
prueba= CREATE TABLE nopk (
prueba(
On Thu, Apr 10, 2008 at 1:26 PM, Marcelo de Moraes Serpa
[EMAIL PROTECTED] wrote:
I can´t connect to my postgresql8.1 server running on Debian. The pgadmin
client says it can't connect. I already edited the pg_hba.conf and
postgresql.conf (listen_addresses = '*' and port) but the problem
Hello,
Is it possible to limit cpu/memory resources to queries on postgres
something akin to limits.conf on Linux?
We have a couple of databases (pg 8.2.7) serving 500K - 1M records. For
various reasons, users are allowed to run queries against the database via a
web based query interface. These
On Thu, Mar 27, 2008 at 11:05 PM, ajcity [EMAIL PROTECTED] wrote:
Hi all,
I am trying to backup a large table with about 6 million rows. I want to
export the data from the table and be able to import it into another table
on a different database server (from pgsql 8.1 to 8.2). I need to
-- Forwarded message --
From: Joey K. [EMAIL PROTECTED]
Date: Wed, Mar 26, 2008 at 9:42 AM
Subject: Re: [GENERAL] Survey: renaming/removing script binaries (createdb,
createuser...)
To: Zdeněk Kotala [EMAIL PROTECTED]
Please let us know your meaning,
thanks
On Mon, Mar 17, 2008 at 6:58 AM, hogcia [EMAIL PROTECTED] wrote:
Hi,
I have to find a Postgres database process pid (or other
identification) for a given client process pid. Or client processes
for a database process. How are they connected? I was suggested maybe
netstat could give me the
experience going through the process.
Absolutely. We will run tests to ensure the process works. Sharing
experience implementing PITR in an environment like ours might help avoid
some initial pitfalls.
Joey K
Greetings,
We have several web applications with Pg 8.2.x running on isolated servers
(~25). The database size on each machines (du -h pgdata) is ~2 GB. We have
been using nightly filesystem backup (stop pg, tar backup to ftp, start pg)
and it worked well.
We would like to move to PITR backups
Greetings,
We have several web applications with Pg 8.2.x running on isolated servers
(~25). The database size on each machines (du -h pgdata) is ~2 GB. We have
been using nightly filesystem backup (stop pg, tar backup to ftp, start pg)
and it worked well.
We would like to move to PITR backups
19 matches
Mail list logo