On 19 June 2013 09:32, girish R G peetle giri.anami...@gmail.com wrote:
Is there a way to switch the current transaction log file in Postgres 8.0 ?
No, that was an addition to 8.2
Suggest that you send more data until the WAL file switches.
You should upgrade with some urgency.
--
Simon
VACUUMs on some or all of the
relations, so the system needs to issue anti-transactional
wraparound VACUUMs.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
that a vacuum cleanup isn't
applied until the transaction is finished?
SELECT is sufficient
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
, but the actual INSERT ignored.
Which is exactly what Hannu is asking for with LOG ONLY TABLEs.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
?
What is the best way to manage this?
These are transaction log files, created by database writes. They
protect you if you crash and also allow replication/backup.
These will be rotated every checkpoint, which by default is 5 minutes.
So they'll be long gone by now.
--
Simon Riggs
submit a test case that fails on Postgres if
you doubt that.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
with encryption can tank
the server.
An effect related to cacheing of WAL files? Perhaps we need to mark
them as FADV_DONTNEED at some point.
Hard to say without detailed analysis.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training
The blkno is all wrong, so it looks like a clear bug to me.
Blkno has been set to -1.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
'starts', right? (/etc/init.d/postgresql-8.4
start times out; I can't connect to the db to see if tables are correct).
2) Because of #1, I suppose I can't do a pg_dump on the standby db?
Exactly. That's what Hot Standby does in 9.x
--
Simon Riggs http://www.2ndQuadrant.com
is roughly yes.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
??
It Just Works.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Wed, Nov 23, 2011 at 12:39 PM, Karuna Karpe
karuna.ka...@os3infotech.com wrote:
Can any one please explain me how to use PITR?
Yes, the docs contain a great explanation.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
On Mon, Oct 17, 2011 at 2:44 PM, Ray Stell ste...@cns.vt.edu wrote:
On Sun, Oct 16, 2011 at 08:21:31PM +0100, Simon Riggs wrote:
On Fri, Oct 14, 2011 at 3:02 PM, Ray Stell ste...@cns.vt.edu wrote:
The tutorial here excludes an important issue:
http://wiki.postgresql.org/wiki
primary capable of supporting a new hot standby. Can the
config values be changed without an interuption of service? I'm using
a hotstandby config in 9.0.x. Anything different in this regard in 9.1?
Thanks.
There's no reason not to have wal_level = hot_standby on the standby also.
--
Simon
aren't designed for long term co-existence,
just for minimising the window of downtime at cutover. It's not been
weaponised, so its not available for free download.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via
that are present. When the standby tries to
restore the missing WAL file, does it fail or it simply skips the missing
WAL file and goes to the next one.
It fails. The gap must be repaired manually, or you're out of luck.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL
On Fri, Jul 15, 2011 at 5:10 PM, David Ondrejik david.ondre...@noaa.gov wrote:
Since then, the process has continued to run (for about 20 hrs) without any
additional information being returned.
Probably locked behind another long running task that is holding a buffer pin.
--
Simon Riggs
or by removing privileges.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
more logging to help diagnose this. Those log reports
are mostly useless in the form they are in now.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
have a patch into 9.2 under discussion to improve upon this
situation, but don't hold your breath for that.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
in,
but pgstat.tmp file is not ppresent in this directory.Can someone tell us
why this error messgae is logged?
The file is being opened for write.
Permissions? Space? Kernel settings?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training
On Thu, Jun 16, 2011 at 7:44 AM, bakkiya bakk...@gmail.com wrote:
Space,permission are not an issue.
Then presumably you have your stats_temp_directory parameter set to a
path where that is not true.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7
interesting. There's a similar process in the PostgreSQL
Admin Cookbook, though our work was independent.
I guess that's because in 9.0 and below it really is the only way to
make it work correctly.
Will look for your work in future, thanks.
--
Simon Riggs http://www
://www.repmgr.org/
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
the second standby also, so it can take over in the event
of failure.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
in
are fairly common.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
had problems with links in earlier versions, so we learned the hard
way to stay clear of them.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
is not effective. Right now
your words are being copied across the internet...
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
that effective.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
rid of, scattered all across the db. The fastest easiest way would
be:
DELETE FROM pg_description WHERE description = 'My very special
totally useless comment.';
Why would you *not* use the COMMENT command for that?
What is slower or harder about using it?
--
Simon Riggs
/continuous-archiving.html#BACKUP-PITR-RECOVERY
You might also want to look at the recent Postgres book that has a
detailed chapter on Replication:
http://www.2ndquadrant.com/books/postgresql-9-admin-cookbook/
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7
it is in synch
with the primary database (in terms of the last WAL applied)? I guess that
the standby cannot be queried as it would be in permanent recovery mode.
At 8.4, no, you cannot query the standby.
9.0 introduces the Hot Standby feature to allow you to query the standby.
--
Simon
the
standby instance in permanent recovery mode?
It is possible. You just need to write a utility very similar to pg_standby.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin
their values for performance. Any crash or failover
will produce the same effect.
We might change that for switchovers but it would take some effort and
would still be the same if it crashes.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support
tell.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
for the record, playing with pg_clog files like this is an
insanely unsafe thing to do. Notably it will make all aborted
transactions in that range become committed, leading to all sorts of
fun.
This is a desperate measures only action and not one that looks
immediately related to the problem.
--
Simon
implementaiont if exists??
PostgreSQL 9.0 is production ready now and supports Hot Standby, which
is exactly what you want.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
space layout/performance tunning etc.
2ndQuadrant provides all of these services. Be happy to hear from you.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
# force a logfile segment switch after
this
hot_standby = off # allows queries during recovery
max_wal_senders = 3 # max number of walsender processes
wal_keep_segments = 10 # in logfile segments, 16MB each; 0
disables
--
Simon Riggs www
, if that matters.
Have you ever performed a switchover operation? If you've never run an
extended recovery on that server, its less likely to be anything HS
related.
Are you running any special hot standby parameters?
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-admin mailing
copied in on mails so that I can see the issues exist. I do not
promise to respond to every mail I'm copied on, though, but it at least
helps me manage the fire hydrant.
Thanks!
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
, or not.
The manual describes what is happening:
http://developer.postgresql.org/pgdocs/postgres/continuous-archiving.html#BACKUP-BASE-BACKUP
Step 5
Is there anything you think should be added to the manual?
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-admin mailing list (pgsql-admin
, or is auto-vac
sufficient?
If you don't know why you are running it, then you should skip it and
measure the difference.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
is actually very low in normal running.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Mon, 2010-03-15 at 11:27 +0200, Nicos Panayides wrote:
thanks for the suggestion. What kind of space savings should I expected
from turning off full_page_writes?
Substantial, though you should measure it and see, since it is workload
dependent.
--
Simon Riggs www
. You will need additional
non-volatile cache on your disks to ensure that is a safe option, though
that will yield performance advantages also.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription
)
just after you've created the table.
This doesn't work with vacuumdb, only with autovacuum.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Thu, 2009-10-15 at 09:24 -0300, Alvaro Herrera wrote:
Simon Riggs escribió:
On Wed, 2009-10-14 at 13:57 -0300, Alvaro Herrera wrote:
Anj Adu escribió:
I have several daily tables that get dropped every day..Is there a
wildcard that I can use to tell vacuumdb NOT to vacuum
written jobs.
You need to break out your top few tables into separate jobs, e.g.
vacuumdb -t big1
vacuumdb -t big2
...
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
the time B is down: I'm only stopping/restarting PostgreSQL, not the entire
machine.)
Recovery is restartable. Not quite from where it left off, but near
enough that it won't take too long to get back to where it left off.
--
Simon Riggs www.2ndQuadrant.com
--
Sent via pgsql-admin mailing
not crashed and so it must always be
programming error.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
this, including data recovery from damaged databases.
Please let us know if we can be of any help. Apologies for mentioning
commercial matters on list, though this work helps fund further
developments in this area.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
suggestion and recommendation are welcome.
Postgres has sophisticated techniques for backup and recovery, proven in
the field over many years.
Please start here
http://developer.postgresql.org/pgdocs/postgres/backup.html
Integration is possible with 3rd party devices and software.
--
Simon Riggs
that are already in it. There is zero
chance of ever doing that with a WAL-based backup --- transaction ID
inconsistencies would break it, even without considering the contents
of shared catalogs.
Agreed.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
to contact me
off-list.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
archive_timeout?
http://developer.postgresql.org/pgdocs/postgres/runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
On Wed, 2009-03-04 at 15:37 -0500, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
On Wed, 2009-03-04 at 15:59 +0200, Peter Eisentraut wrote:
samana srikanth wrote:
Can we do a point-in-time restore of a single database out of n
databases??.
In principle no. But you could
On Wed, 2009-03-04 at 16:27 -0500, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
On Wed, 2009-03-04 at 15:37 -0500, Tom Lane wrote:
It's not as easy as all that. What will you do with updates to shared
catalogs?
Apply them.
... which leaves your other databases
appear that paragraph is in direct
conflict with paragraph (1) of same article.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
the stats files are changing while being copied.
I'd suggest excluding global/pgstat* from the backup.
Stats are reset at recovery anyway, so you've lost nothing.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql
WAL files that may be
needed for recovery.
You can use
pg_controldata test | grep REDO | cut -d: -f 2
to find out the LSN of the last restartpoint, which can then be
converted into an xlogfilename using pg_xlogfile_name().
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training
there. Simple enough but the time to travel
Over the network becomes an issue - 12 - 13 hours at best.
If we have to do this then we will. I just want to make sure I'm
understanding your advice.
Yes.
Yes, but use rsync, so you don't need to wait for 13 hours.
--
Simon Riggs www
/WAL_ARCHIVE_DIR/0001.history
i wonder if it is fatal or not?
That's normal.
I will not to start the process ot making the base backup and send it
to my warm standby server. My warm standby server is on diferent
location connected via slow connection.
That's OK.
--
Simon Riggs www
+ CPU system.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
the whole
thread, but suggesting deleting things like that makes me go all
twitchy. :-). Do a couple of proper backups and then delete em.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
restore_command is provided as a contrib
module named pg_standby. It should be used as a reference on how to
correctly implement the logic described above. It can also be extended
as needed to support specific configurations or environments.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL
crash recovery you should trust archive recovery, which
means WAL shipping. The differences are all about where you start and
stop WAL replay.
The second is that any form of replication requires testing.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
patch...
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
someone else can volunteer?
I'll look at doing that. We need the SUSE builds also.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
On Tue, 2008-09-23 at 10:05 +0100, Dave Page wrote:
On Tue, Sep 23, 2008 at 9:49 AM, Simon Riggs [EMAIL PROTECTED] wrote:
Oh, I thought you were looking after that build. If it's not being
maintained, we'll need to remove it from the download pages unless
someone else can volunteer
On Tue, 2008-09-23 at 21:05 +0300, Devrim GÜNDÜZ wrote:
Hi,
On Tue, 2008-09-23 at 09:49 +0100, Simon Riggs wrote:
I'll look at doing that. We need the SUSE builds also.
I actually built 8.3.4 on SLES 10.2 on..err..Friday, while building
Fedora/RH RPMs. 8.3.1 spec of SLES is broken IMHO
.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
entries from 23:03 to
23:07. I don't see any reason for a 4 minute wait at that point,
especially since previous files took 5 seconds. Are you showing us the
whole log?
Please re-run this at DEBUG3 so we can see what else is happening.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL
On Fri, 2008-08-15 at 09:44 -0400, Carol Walter wrote:
All the documentation I've read says that for Unix installations
should compile source.
You're right. We should fix that so it also describes using pre-packaged
options also.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL
their
recovery.
The slave does watch the current time to decide when to do recovery
restartpoints, so if you were setting the clock *back* by a large amount
it might be wise to stop and restart the slave postmaster. Forward
should be no problem though.
Yeh, you're good.
--
Simon Riggs
postmasters on this machine?
Obviously, if 2 went down at the same time, I'd have to do some magic to
bring up another machine, but I'm not sure that's a concern.
Yes, that will work.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql
On Thu, 2008-06-26 at 13:01 -0500, Scott Whitney wrote:
A 2nd question: Is it possible to have 2 standby servers with a single
master duplicating to standby1 (at my coloc), and standby2 (at my office)?
Assume no auto-failover.
Yes, that works too.
--
Simon Riggs www
not mentioned there we will update them.
Thanks,
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
of the tar?
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Fri, 2008-05-16 at 13:21 -0400, Mark Steben wrote:
Simon, I think you uncovered the problem but I don't see anyway around
it Short of reloading the db from a pg_dump backup. Any suggestions
would Be appreciated. Thanks,
Re-run the backup? Sounds safest.
--
Simon Riggs www
hardware will it run on?
* What performance is required?
...
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
offers database recovery
services, if you're willing to pay.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
, then either correct
the problem or report the bug.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
not truncate directory
pg_multixact/members: apparent wraparound
Some interesting failures there.
Is this a modified Postgres server? Are you running externally supplied
C language functions? Have you had hardware problems?
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
emails stay
the same. We can also change the manual some more in response to
clarifications.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Thu, 2008-01-31 at 12:09 -0300, Alvaro Herrera wrote:
Simon Riggs wrote:
As far as I am concerned, if any Postgres user loses data then we're all
responsible.
Remember, our license says this software is given without any warranty
whatsoever, implicit or explicit, written or implied
On Thu, 2008-01-31 at 10:02 -0500, Chander Ganesan wrote:
Magnus Hagander wrote:
On Thu, Jan 31, 2008 at 03:34:05PM +0100, Martijn van Oosterhout wrote:
On Thu, Jan 31, 2008 at 01:28:48PM +, Simon Riggs wrote:
That sentence has no place in any discussion about backup because
a product-agnostic backup. Anything
that can backup a file can backup PostgreSQL. There is no need for
special certifications of hologram logos.
You may need to write a few lines of script to do it, but that's not a
problem surely?
So you can use pg_dump or PITR, as you choose.
--
Simon Riggs
of mind too, but it's a long way from being an essential
requirement.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
a standalone backup.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
to archive.
Thank you - I saw that, but I didn't have a clue about how to determine
the WAL filename in which this segment is to be found ...
Look at pg_stop_backup() in the docs.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
---(end of broadcast
On Wed, 2007-10-10 at 11:46 -0500, Scott Whitney wrote:
Is rsync a supported method for a warm standby server? Specifically, I'm
thinking about:
http://www.taygeta.com/ha-postgresql.html
That's dated 2001...
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
On Thu, 2007-10-04 at 20:02 -0600, Benjamin Krajmalnik wrote:
Is there a way to execute an external program from within a stored
procedure?
Write a Function in C
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
---(end of broadcast
the last restartpoint.
Is that what you meant?
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining
second, third and so on runs. Isn't is
wrong that RDBMS tries to cache table data blocks at least PARTIALLY
in the case of insufficient cache buffer?
It does cache partially, but its always the wrong part of the table.
BTQ, Oracle does that too...
--
Simon Riggs
2ndQuadrant http://www
with a log message to say
ereport(DEBUG2,
(errmsg(RM %d not safe to record restart point at %X/%X,
rmid,
checkPoint-redo.xlogid,
checkPoint-redo.xrecoff)));
to help trace such things in future.
--
Simon Riggs
2ndQuadrant
On Tue, 2007-08-28 at 18:49 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
Yeh, we traced a problem with GIN indexes to this cause in early June;
Teodor fixed it quickly in REL8_2_STABLE, but that won't be available
until 8.2.5.
Thanks, that's what I missed finding
commit/abort record.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On Fri, 2007-07-20 at 14:19 -0400, Mark Steben wrote:
We are currently at version 7.4.5.
You should upgrade if you want better performance and scalability.
Or maybe you should just use COPY?
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
---(end
1 - 100 of 210 matches
Mail list logo