This mean that method isn't supported by postgres on my platform?
Must i give some extra options at build time?
(i use postgresql 8.0.2 sources)
The test "syncbench" that i run on this server with the "open(O_DSYNC)"
method, give me results without problems.
Thanks and best regards.
Scott Ma
Hello,
is here
anybody who have pgAdmin II for windows? I'm working with postgres 7.2 and
pgAdmin III is only for 7.3+. Could
you send me a link where to download it.
Thanks
Tomas
Kratochvil
hi
I have to setup some backup policies for our postgres server.
I had a few queries regarding corruption of database.
what are the steps to be followed in postgres regarding logical corruption, instance failures, block corruption, log corruption?
I am using postgres 7.3.9
I was checking out WAL
Database recovery from write ahead logs is only supported in PostgreSQL
8.0.0 and later.
---
hi
I have to setup some backup policies for our postgres server.
I had a few queries regarding corruption of database.
what are the ste
thanks for the info.
what is the utility of WAL logging in postgres 7.3
thanks,
kailashOn 6/17/05, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:Database recovery from write ahead logs is only supported in PostgreSQL
8.0.0 and later.-
Francesco Dalla Ca' wrote:
> This mean that method isn't supported by postgres on my platform?
> Must i give some extra options at build time?
> (i use postgresql 8.0.2 sources)
>
> The test "syncbench" that i run on this server with the "open(O_DSYNC)"
> method, give me results without problems.
Kailash Vyas <[EMAIL PROTECTED]> writes:
> what is the utility of WAL logging in postgres 7.3
Crash protection.
regards, tom lane
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www
thanks tom for you prompt response.
can you give me more info into crash protection.
for example in case of database crash what would be the steps involved in recovering it through WAL.
thanks,
kailash
On 6/17/05, Tom Lane <[EMAIL PROTECTED]> wrote:
Kailash Vyas <[EMAIL PROTECTED]> writes:> what is
On 6/17/05, Kailash Vyas <[EMAIL PROTECTED]> wrote:
> for example in case of database crash what would be the steps involved in
> recovering it through WAL.
just restart the database.
postgresql with recover itself using wal files.
depesz
---(end of broadcast)---
On Fri, Jun 17, 2005 at 14:09:53 +0100,
Kailash Vyas <[EMAIL PROTECTED]> wrote:
> thanks for the info.
> what is the utility of WAL logging in postgres 7.3
It allows the postres to recover if the server crashes.
---(end of broadcast)---
TIP 7: do
I am running Postgres 7.4.5 and I have recently run into a
problem. My database was running fine for days and then today in the middle of
the day it seems that the startup subprocess kicked in and started recovering.
I am not sure from what, and I am not sure how it started, but nothing w
Probably some kind of a hardware issue
(you lost a path to the array for e.g.), or someone may have issued a kill -9
to postmaster?
Open another terminal and check the system
log (/var/log/messages) if you are not redirecting logs anywhere.
Can you paste the console messages on the
Do you want me to stop the recovery to get
the console messages? After issuing the start command I did not capture the
logs because I did not notice a problem right away. Now I cannot see them
anymore.
Is there anything I can do?
The database is 99GB with almost all the
data in on
On Thu, 2005-06-16 at 08:25 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > I'm suspicious of a more subtle intermittent error.
>
> Yeah, I am too, but so far none of the reporters have been cooperative
> about providing more information :-(
>
> > We have no
> > information a
It seems that I have made things
significantly worse. I am in the process of restoring from last night’s backup.
Then I should be able to get the data that I missed today back in.
Thanks for the help,
Andrew
From: Anjan Dave
[mailto:[EMAIL PROTECTED]
Sent: Friday, Jun
Without any actual messages, not sure what
to say in regards to whether it is still recovering, or finished recovering
successfully (from the logs).
There are a few ways to check if the
postmaster is up. A simple check is to try a psql and see if you’re
up.
Thanks,
Anjan
hi,
i’m working
with an postgresql-installation on Solaris ("PostgreSQL 7.4.7 on
sparc-sun-solaris2.9, compiled by GCC 2.95.3") and I have the following
problem:
I’m using
tables like this:
CREATE TABLE
session.preferences
(
id serial NOT
NUL
hi,
i'm working with an postgresql-installation on Solaris ("PostgreSQL
7.4.7 on sparc-sun-solaris2.9, compiled by GCC 2.95.3") and I have the
following problem:
I'm using tables like this:
CREATE TABLE session.preferences
(
id serial NOT NULL,
name varchar
hi There,
When I was fine tuning my already running
application, all of the sudden, I couldn't perform any save/edit operation on my
database, with the error such as:
ERROR: could not extend relation
4273000/17231/926549: No space left on device SQL = update call set personal=1
where row
Hello,
I have one server postgresql in my home computer, and now I have the
necessity of access it of my work, the question is. How I liberate the
access remote of postgresql with password?
--
Thanks,
Marcos José Setim
Usando o M2 do Opera: http://
I want to create the postgresql service user unattended (in a batch
process). How can I do that? Especially I couldn't create the right to logon
as service.
What is the correct procedure to create a service user for postgresql and to
start the service in a batch (unattended) mode?
Thanks
Stefan
I'm trying to add a
sequence function to an already existing field. All the 4000 records for this
table currently have a value already in this field, but I'd like new ones to
just get the next value by default as opposed to users being forced to type
something. What I'd like to do is to relo
Hi,
where could I
download pgAdmin II for Win32?
Thanx
Tomas
Kratochvil
23 matches
Mail list logo
