> 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 r
On Wed, Feb 11, 2009 at 3:05 PM, Devrim GÜNDÜZ 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 RHEL5
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,
http://ftp9.us.postgresql.org/pub/mirrors/postgresql/binary/v8
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 rel
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 resort)
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 = c
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 "pu
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
enterpris
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, w
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 /b
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 (
> prueb
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
-- 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
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
t.
> Getting PITR working effectively is tricky, no matter how many questions
> you ask of knowledgeable people. You're going to want to have first-
> hand 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 si
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 si
19 matches
Mail list logo
