>Pallav Kalva wrote
> yes, documentation points to the
> recovery_target_time(timestamp) option
> in this regard, sorry i missed that. but there is one thing which is
> still not clear to me is if we restore the database to some
> time back ,
> what happens to WAL files in the pg_xlog directory ?
Hello all,
I recently tried to upgrade from postgresql8.0beta4 to 8.0.1. When I
tried to start postmaster I got the following error:
FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized with CATALOG_VERSION_NO
200410111, but the server was compiled
>Mark Reidenbach wrote
>The problem I'm having is that you need to
> backup this wal
> file before it's been archived to have a backup which is
> consistent
Not sure I agree. Can you explain some more?
Is it that you have a very low transaction rate and log files take a
long time to fill?
Pleas
I have a need to install multiple versions on my linux box (7.1.2 & 7.4.x on
FC3). Both will be installed from source. I know that they will need separate
install and data directories and use sepearate ports. My question is about the
libraries. I usually put their location in ld.so.conf. Do both
I noticed I was running low on space on my system, so I found this vacuum
command. I ran it and it failed because it ran out of space:
vacuum mytable;
FATAL 2: ZeroFill failed to write
/var/lib/pgsql/data/pg_xlog/xlogtemp.23895: No space left on device
server closed the connection unexpectedly
Hi,
We are using Postgres 8.0 as a developement database and working fine under
Linux.
Can you please let me know whether the Postgres 8.0 version available for
Solaris-sparc
and Solaris -x86 and Solaris-x86 (64 bit).
Thanks and regards,
- Sanjay Rathod
_
Hi, I have a problem installing "plpgsql" in postgreSQL 7.4.6 on linux.
Those Scripts were create succesfull but when i try to create some "store
procedure(function)" no gererate errors, no generate nothing in the pgadmin
III, i don't know what is the problem.
'/usr/lib/postgresql/plpgsql
yes, documentation points to the recovery_target_time(timestamp) option
in this regard, sorry i missed that. but there is one thing which is
still not clear to me is if we restore the database to some time back ,
what happens to WAL files in the pg_xlog directory ? if we still keep
those files
