I've noticed that PG automatically creates indexes when you create a
primary key. But when you create a foreign key on a child table, it
does not create an index on the referencing columns of the child
table.
Does PG *not* need an index to perform joins between parent and child
tables quickly? Or
On Nov 25, 2007 8:24 AM, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Why is it not allowed to call pg_start_backup when WAL archiving is off?
> Wouldn't this be useful as a discrete file system backup without PITR
> capability?
Because a file system level backup is no good unless the database is
> I have installed Postgres 8.2.5 on windows xp machine using the windows
> installer. I am trying to enable syslogs on Postgres so that all Postgress
> logs should be forwarded Syslog server. I have installed Syslog server
> WinSyslog on the same machine.
>
> I have modified 'log_destination' para