Hi,
Have you defined an archive_command ?
What is your value for checkpoint_segments, checkpoint_timeout &
checkpoint_completion_target ?
Thomas
Le 26/08/2013 05:10, Ed Tarento a écrit :
Hi admins
I'm a newbie, I hope this is the right group and admit I have little
postgres experience. I'm
On 19 June 2013 09:32, girish R G peetle 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 Ri
ssuing 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 (pgsq
to use UPDATE or INSERT to ensure 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 maili
t the actions are binary logged, 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
these files? Will it create more with big inserts?
>
> 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 def
ively, please 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 sub
network bandwidth is
good, perhaps running WALSender at full speed 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://ww
2) was terminated
> by signal 6: Aborted
> 2012-04-06 02:37:28 CST [@] LOG: terminating any other active server
> processes
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 D
d the forums and the docs several times, so I apologize if I
missed the answer/tutorial on this somewhere.
Thanks,
Eric Simon
n 2 and 4 requested
> checkpoints per hour, but on the hot standby I'm seeing between 200 and 300
> requested checkpoints per hour.
We don't do a restartpoint on the standby unless we see a checkpoint
record, so that result should be impossible.
So I'm guessing you'
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
e standby database never '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 doe
2011/12/7 Silvio Brandani :
> I have a system with archive log shipping to a standby server read only with
> replication streaming.
> is possible to use the truncate in the primary or it will affect the log
> shipping architecture and will corrupt the standby server??
It Just Works.
On Wed, Nov 23, 2011 at 12:39 PM, Karuna Karpe
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
--
Sent via pgsq
On Mon, Oct 17, 2011 at 2:44 PM, Ray Stell 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 wrote:
>>
>> > The tutorial here excludes an important issue:
>> > http://wiki.postgresql.org
y 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
ed 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 pgsq
after 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.co
On Fri, Jul 15, 2011 at 5:10 PM, David Ondrejik 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
moving 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
ore 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 ma
re optimization since I am using pdo which uses prepared statements
> all the time and is unable to use all the partial indexes.
>
> The problem is I have 90 GB of indexes in the database and partial indexes
> could help me to save some of this space on my server, in addition to
> improve
On Thu, Jun 16, 2011 at 7:44 AM, bakkiya 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 Support, Train
_stat_tmp directory 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
ing your database unrecoverable.
Stuart,
That looks 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 futur
formance.
You can list 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 m
ird, possibly new, system."
You need repmgr: http://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
bles with 1 billion+ rows 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
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 ma
uffers and all disk caches as
well to make 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
ds 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://www.postgresql.or
e..
> Thanks in Advance.
The CHECKPOINT command will do this for you.
--
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
nt to get
> 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 usi
.org/docs/9.0/static/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 Deve
that only works if something broke, can only really be
tested by deliberately breaking something. Break it, but on a test
system.
--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pg
On Thu, Apr 14, 2011 at 1:06 PM, Alanoly Andrews wrote:
> Thanks, Simon, for your quick response. I'll try it out with your pg_standby
> utility. And...if I may ask you one more question on the subject, once the
> standby is up and running, is there a way to determine whether
> 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 l
cause the absence of a failure in
a test is not conclusive proof that it won't fail at some point in the
future while in production.
The short answer is "don't do it".
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Train
On Tue, Apr 12, 2011 at 9:28 AM, Simon Luijk wrote:
> I have two test systems with Postgresql in Hot-standby configuration. The
> intention
> is to fail-over to the slave every so often. When ever we switch servers
> (fail-over)
> and start inserting data, the primary ids have a g
?
http://archives.postgresql.org/pgsql-bugs/2001-12/msg00082.php
With a Hot-standby set-up like this, that regularly switches, can I not rely
on
the sequence always incrementing by 1?
Thank you
Simon
tgresql/9.0/data/trigger'
> standby_mode = 'on'
> primary_conninfo = 'host=10.5.17.40 port=5432 user=postgres'
>
> thanks for any input.
That all looks normal to me, as far as I can 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
So I have turned archive_mode off on the slave. At first I thought this solved
it but
the logs are still building up. Could anyone shed some light on why the logs
are building
up in pg_xlog?
Thank you
Simon
On Wednesday, 23 March 2011 at 22:16, Simon Luijk wrote:
> I have a master slave se
ecord, 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 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
I don't know why postgres is prompting for a password. But you could try
putting the following in your crontab:
su postgres -c 'pg_dump ...'
Simon
2011/3/24 Jaroslav Záruba
> Hello
>
> I have pg_dump command in cron that accesses PostgreSQL under user postgres
postgresql.conf so when the slave needs to come online as
the new
primary it start shipping its logs. Is this setting effecting recovery mode too?
Thanks in advance
Simon
>
> DO you have some suggestion for our 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
replication/table
> 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@pos
quot;%f"'
># command to use to archive a logfile segment
> archive_timeout = 3600 # force a logfile segment switch after
> this
> hot_standby = off # allows queries during recovery
> max_wal_senders = 3 # max number of walsender processes
> wa
of
> a hot standby installation, 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
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.or
ing, but apart from those
the load 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
for performance reasons, 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
ng a bug, 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 mai
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
an integrated and
fully-supported option with Postgres. 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-admi
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
do "INSERT INTO pg_autovacuum" (or ALTER TABLE/SET in 8.4)
> 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 c
ndexdb, clusterdb or any custom 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 subs
y during
> 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.
PARED or ROLLBACK PREPARED on a session *after* issuing a PREPARE
TRANSACTION then it should give an ERROR. If the session continues to
exist then the server has not crashed and so it must always be
programming error.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Suppo
of experience with helping people out with
problems like 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.2nd
orage
>
> Any 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
ithout
> breaking the other databases 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.2n
On Wed, 2009-03-04 at 16:27 -0500, Tom Lane wrote:
> Simon Riggs 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.
>
> ... wh
On Wed, 2009-03-04 at 15:37 -0500, Tom Lane wrote:
> Simon Riggs 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??.
a/pgsql/wals/alerts_oamp %f %p %r >>
> /home/postgresql/log/alerts_oamp/recovery.log'
You've set archive_timeout?
http://developer.postgresql.org/pgdocs/postgres/runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Trainin
code hooks required to do this, if people want 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
e. And it would 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 subscript
not
> fail.
Seems like 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
--
S
nia, and lay it down 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
in future don't delete 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
RECOVERYHISTORY" which points to the
> following missing file "/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 stan
basically useless.
They are still better than nothing at all. I haven't read 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, Serv
o be at least twice as
fast on a 2+ 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
.3 docs have the wording
"A working example of a waiting 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 environmen
So if you trust 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, Serv
t; it.
Please test the Hot Standby 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
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/R
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 dow
, 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?
I'll look at doing that. We need the SUSE builds also.
--
Simon Riggs www.2ndQuadrant.com
Postgr
ckup product.
--
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
> I found this on the forums. Could it be the source of the problem I'm
> experiencing?
The way you are using this looks correct.
The startup process would not/should not fail in this way and there
should be additional messages between the log entries from 23:03 to
23:07. I don't
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
unt
> it might be wise to stop and restart the slave postmaster. Forward
> should be no problem though.
Yeh, you're good.
--
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 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
do this by installing 3 separate 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
PostgreS
ng 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
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
here a backup_label file as part 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
about would be:
* What workloads are you running?
* What 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-admi
oblem?
> HELP!!!
It is possible to recover some data in most situations, but it can take
anywhere from a day or two. My company offers database recovery
services, if you're willing to pay.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
PostgreSQL UK 2008 Conference: http://www
Hi Everyone;
I use the Postgresql830, I look at the tomcat log,I found there are
many "Broken pipe" ,before I used the Postgresql824, I didn't find this
issue,
please help
Regards
-Simon
...
> <2008-02-25 07:15:56 CST >LOG: could 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 p
when and why this happened, 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
cted the manual, but old 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 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
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
>
and new data would be inaccessible.
As far as I am concerned, if any Postgres user loses data then we're all
responsible.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
The design of the PITR system allows 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
1 - 100 of 249 matches
Mail list logo
