Point-in-time recovery coming in 7.5. You want instructions?
---
Jason Tesser wrote:
> how
>
>
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> Sent: Thu 7/29/2004 7:56 PM
> To: Jason Tesse
how
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Thu 7/29/2004 7:56 PM
To: Jason Tesser
Cc: [EMAIL PROTECTED]
Subject:Re: [GENERAL] Wal logs
Jason Tesser wrote:
> This question may seem trivial but how do I rebuild a database with the
> wal lo
Hi,
I am running postgresql 7.3.4 with rendezvous enabled on MacOSX
10.3.4.
I tried changing the rendezvous_name parameter in the postgresq.conf
file
to 'RendezvousAtMacJerry' and SIGHUP'ed the server.
However the rendezvous name did not change, it is still the rendezvous
name for my computer.
Jason Tesser wrote:
> This question may seem trivial but how do I rebuild a database with the
> wal logs?
You can't, but with 7.5 you can archive those logs and use them and a
recent backup for point-in-time recovery.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL
Steve wrote:
Someone please please help me :-(
Hi Steve,
How much leverage over the design of the application do you have?
Depending on the data that's being accessed, it may be worth looking
into materialised views for some of the data. Very application
dependent on course:
http://www.varl
"Chris Gamache" <[EMAIL PROTECTED]> wrote:
> When I reload and attempt to access the database I find this
> in the logs:
>
> ERROR: cache lookup failed for function 75769893
You should be OK as long as you have the dump file. If you haven't modifed any of the
tsearch2
pg_ts_* tables, try and
This question may seem trivial but how do I rebuild a database with the
wal logs?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
http://developer.postgresql.org
Bruce Momjian wrote:
David Parker wrote:
Is there a spec/posting somewhere that more or less reflects how
tablespaces are supposed to work in 7.5? I've found a lot of info on it
by searching the archives, but I haven't found the posting that
describes the basic func
On Friday 23 Jul 2004 11:41 am, Steve wrote:
> Currently, the postgresql installation is on a single disk and so all
> the tables have their data read from a single disk. Searching on
> different tables by multiple users at the same time results in very slow
> searches, as it's mainly dependant on
"Kevin Macdonald" <[EMAIL PROTECTED]> writes:
> QUERY 2: select sobjid from p1_nrn_road where v = 1
>
> The plan is "Seq Scan on p1_nrn_road (cost=0.00..22158.54 rows=2 width=8)"
Incidentally, you should send the whole plan. In general you should send all
the information you have, not just the
Steve <[EMAIL PROTECTED]> wrote:
>
> Someone please please help me :-(
[snip]
Relax, Steve. The people helping-out on PostgreSQL mailing lists are
in 24 timezones, have real jobs (for which they actually get paid), are
all volunteers (for which they don't get paid), may be going to school,
t
David Parker wrote:
> Is there a spec/posting somewhere that more or less reflects how
> tablespaces are supposed to work in 7.5? I've found a lot of info on it
> by searching the archives, but I haven't found the posting that
> describes the basic functionality.
Have you looked at the development
Steve <[EMAIL PROTECTED]> wrote:
> Someone please please help me :-(
>
> Steve
>
> Steve wrote:
> > Hi,
> >
> > I've been running postgres on my server for over a year now and the
> > tables have become huge. I have 3 tables that have data over 10GB each
> > and these tables are read very
I have 2 questions.
1. What is the best way to back up a production box running Postgres
nightly?
2. I thought the best way was to create a script that would use pg_dump
to
create a dump every night and then use restore if I need to. I did this
but
I am having a problem. Apparently there were
Marcus Wegner <[EMAIL PROTECTED]> writes:
> Is it possible to keep data safe with linux and psql after crash?
>
> The short description of the scenario is:
> -> writing data with psql (using transactions), store process completed
> -> user hits the reset button or kernel crashes (whatever left the
I have 2 questions.
1. What is the best way to back up a production box running Postgres
nightly?
2. I thought the best way was to create a script that would use
pg_dump
to
create a dump every night and then use restore if I need to. I did
this
but
I am having a problem. Apparently th
There should be a config.log file in the directory where you ran
configure: output in that file around the error is the first place to
look.
- DAP
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Wynett
Sent: Friday, July 23, 2004 5:37 PM
To: '[E
In article <[EMAIL PROTECTED]>,
"B. van Ouwerkerk" <[EMAIL PROTECTED]> writes:
> I've been reading this discussion and I asked myself whether you guys
> remove/replace unwanted chars from strings you get from the web or
> not..
The problem is not limited to strings you get from the web. Those
st
Hi:
I'm installing postgresql 7.4.3 on Solaris and during ./configure I get the
following error:
checking types of arguments for accept()... configure: error: could not
determine argument types
Any ideas?
Jon Wynett
Senior Java Developer
Research Systems, Inc.
303-413-3985
[EMAIL PROTECTED]
-
Hi,
I've asked this question a couple of times before on this forum but no
one seems to be nice enough to point me to the right direction or help
me out with any information, if possible. Please help me out with this
because this is a very serious issue for me and I need to learn more
about thi
I expected Postgresql to use an indexed access method, but in certain cases
it is using a sequential scan. Details are below:
Table:
P1_NRN_ROAD (
sobjidint8 primary key,
vint8 not null,
ordint2 not null)
* The table contains 1.1 million rows.
* Column 'v' exhibits very high sele
Where I can find some documents about PostgreSQL storage system ? I think
that ERL-M87-06.pdf is quite old and need some details. Perheps there is
some comparison between postgres and postgresql strorage system.
Thanks for any information.
Kris
---(end of broadcast)---
Someone please please help me :-(
Steve
Steve wrote:
Hi,
I've been running postgres on my server for over a year now and the
tables have become huge. I have 3 tables that have data over 10GB each
and these tables are read very very frequently. In fact, heavy searches
on these tables are expe
Is it possible to keep data safe with linux and psql after crash?
The short description of the scenario is:
-> writing data with psql (using transactions), store process completed
-> user hits the reset button or kernel crashes (whatever left the filesystem
unsynced)
-> filesystem is xfs or reise
24 matches
Mail list logo