"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> wrote:
>> You don't really have any choice about the matter --- Postgres will
>> not use a single fixed filename because that would be guaranteed to
>> lose log entries across a rotation.
> Unless he is using syslog?
Tru
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 10 Jan 2008 19:08:57 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Andy Shellam" <[EMAIL PROTECTED]> writes:
> > What I want PostgreSQL to do is put a log file "postgresql.log" in
> > "/var/log/pgsql" - I have an application that handles log
>
"Andy Shellam" <[EMAIL PROTECTED]> writes:
> What I want PostgreSQL to do is put a log file "postgresql.log" in
> "/var/log/pgsql" - I have an application that handles log rotations, so
> would prefer to do it with that, rather than have PostgreSQL do the
> rotation.
You don't really have any choi
On Thursday 10 January 2008 12:27:37 David Wall wrote:
> I'm trying to get WAL file copying working across two systems. It seems
> pretty straightforward to handle this in the "archive_command" of the
> primary, in which I am able to copy the files easily to a staging area
> for the backup system.
Hi,
I'm just trying out the RC1 release of 8.3, and I'm seeing something strange
with the logging configuration.
What I want PostgreSQL to do is put a log file "postgresql.log" in
"/var/log/pgsql" - I have an application that handles log rotations, so
would prefer to do it with that, rather than h
I'm trying to get WAL file copying working across two systems. It seems
pretty straightforward to handle this in the "archive_command" of the
primary, in which I am able to copy the files easily to a staging area
for the backup system.
On the backup system, I have the recovery.conf pointing t
Hello,
I have noticed that there are different sets of rpms for :rhel-as-4 and
rhel-es-4 ( just addressing the 32 bit stuff).
Is there enough of a difference between the rpms or their dependencies
of the Red Hat operating system flavors to merit separate installation
packages? If so, if a client a
-- Forwarded message --
From: Rich <[EMAIL PROTECTED]>
Date: Jan 10, 2008 1:32 PM
Subject: Re: [ADMIN] physical memory
To: Antonio Corardi <[EMAIL PROTECTED]>
There is probably no limit except the limitations of your hardware at
this time. As far as it automatically incorporating
Hi Team,
We are upgrading the pgsql from 7.4.2 to 8.2.5 on Solaris 9 Spark
machine, I had downloaded the sources also. I had gone through the
instalation documents too. I could not find the procedure to rollback
the new version, if the new version does not support our application.
Queries :-
Richard Ray wrote:
> On Wed, 9 Jan 2008, Bruce Momjian wrote:
>
> > Richard Ray wrote:
> >> I've inherited an application that creates a temp schema and stores
> >> a table for each user there.
> >> The data is temporary and does not need to be backed up.
> >> I run pg_dumpall each night.
> >> I c
Hi all,
I'm new here and my doubt is very basic. I'm wondering how to set
the max amount of space(physical, not RAM) to be used by postgreSQL.
Moreover, Is such amount limited to the hard disk in wich postgreSQL is
installed or it scales automatically to the others HD available? How
can I
On Jan 10, 2008 1:38 AM, nalini <[EMAIL PROTECTED]> wrote:
> Dear All
>
> I have a application running at various locations with backend as postgres
> Slony is configured at all locations for replication at local site anda
> central server where each site has its own database instance.
>
> Now we w
On Thursday 10 January 2008 06:12:43 am Alvaro Herrera wrote:
> pg_get_serial_sequence
But it only works with a serial data type.
Create a sequence "mySequence"
Create a field "myField smallint NOT NULL DEFAULT
nextval('mysequence'::regclass)"
So given the name of the table and the name of t
On Thursday 10 January 2008 00:38:38 nalini wrote:
> Dear All
>
> I have a application running at various locations with backend as postgres
> Slony is configured at all locations for replication at local site anda
> central server where each site has its own database instance.
>
> Now we wish to m
johnf wrote:
> I have to go to the well and ask you guys how in the he_l I can determine the
> sequence name if I only have the schema name (normally 'public'), the table
> name, and the field name (normally the PK).
pg_get_serial_sequence()
--
Alvaro Herreraht
On Wed, 9 Jan 2008, Bruce Momjian wrote:
Richard Ray wrote:
I've inherited an application that creates a temp schema and stores
a table for each user there.
The data is temporary and does not need to be backed up.
I run pg_dumpall each night.
I can't just delete the tables because users may be
Hi all,
The earlier email was written as a result of an oversight on my part. The cause
of the problem lay in the adopted audit function code which I edited. I have
now rectified the code and all is well. I would like to apologize to the
mailing list for not rechecking my work, bandwidth and tim
Hi all,
I am writing a row trigger called after insert, update and delete operations on
a table, lets call this table 'togo', the table definition contains a not null
field having a default clause. On running the trigger (performing an insert on
'togo') I get an error which indicates that the in
18 matches
Mail list logo
