least one wal archive available in
the archive or the pg_xlog dir, the restore errors out and exits. So the
base backup is really not complete without at least one wal archive
following it. Is this by design?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC
ATA base backup
and then any archived wal files that come after 51?
The background on this is that I'm trying to script up a one script restore
solution and my testing has me running into the occassional surprise.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Fr
files that come after 51 if none happen before the
next base backup?
Thanks for all the help guys!
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
-
postmaster eventually recycle them
after the restore was complete?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP
Sounds like slony is what you're looking for:
http://slony.info/
On Sat, 25 Jun 2005, hellz waren wrote:
Could you someone tell me if there's any open source
project that enables real time replication of data
back up.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost
On Thu, 23 Jun 2005, Jeff Frost wrote:
I guess I forgot to ask one other question. If the archived wal files are
streamed in one by one, would it still be safe to leave the pg_xlog directory
intact in the base backup? What would happen with the out of date log files?
Would they just stay in
se of disk space concerns, but because rsync
occassionally reports that these files disappear out from under the running
rsync process, and so I was thinking I'd rather just exclude them if they are
not required as I want my pitrbasebackup script to return 0 if rsync is
successful.
--
one other thing...it will always look in the pg_xlog directory
for that current xlog which is required and will not look for it in the
archive dir. It would be nice if it would also look in the archive dir for
this one, no?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consul
| tail -1`/backup_label
if [ -f $OLDESTFILE ]; then
/usr/bin/find $PITRDESTDIR -type f -not -newer $OLDESTFILE \
-exec rm -f \{\} \;
fi
Your mileage may vary, but it appears to work for me.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consul
ta/pg_xlog/0001000B" (log file 0,
segment 11): No such file or directory
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)
ot attempt to retrieve that first WAL
via the restore command. All the ones after that it was happy to do it for,
but if that one did not exist, it told me to get lost. That was on 8.0.3. I
did not test any other versions.
Putting it in the pg_xlog dir made everything go smoothly though.
--
did not even try to get it out of the
archive.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Thu, 30 Jun 2005, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
I'll have to retest that particular scenario and verify that something
else was not causing the problem when I have a chance now that I have
a fully functional and scripted out base backup and recover soluti
On Wed, 6 Jul 2005, Bruce Momjian wrote:
We basically run the command you give us via system(), so it is hard for
us to know exactly why it failed.
Understandable..but it would at least be nice to know that it failed. It does
not appear to log anything at this point.
--
Jeff Frost, Owner
22:14:06 db1 postgres[26299]: [4-2] directory
Jul 5 22:14:06 db1 postgres[26299]: [5-1] LOG: invalid checkpoint record
Jul 5 22:14:06 db1 postgres[26299]: [6-1] PANIC: could not locate required
checkpoint record
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http
about.
Using PITR in this way has the added benefit of allowing you to restore the DB
to some point in the past if need be.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
On Sat, 30 Ju
here:
http://www.postgresql.org/docs/8.0/interactive/backup-online.html
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP
to the secondary server and archiving
the WAL files to a shared storage medium for replay.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of bro
Yoway,
What are you upgrading from/to? Can you share your dump and restore command
line as well?
On Fri, 5 Aug 2005, Buorn, Yoway wrote:
I'm upgrading Gforge and the first sql file I tried to load gave me the
following error:
--
Jeff Frost, Owner <[EMAIL PROTECTED
backup.dump
pg_restore is looking for one of the other output formats (tar or custom).
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)-
earched the web, but found what appeared to be
non-free solutions.
Thanks,
Dave
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC ht
forget to increase your free space map settings
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 3: Have you ch
e client, you probably need to make some changes to the
pg_hba.conf and the postgresql.conf as the default security settings are quite
restrictive. You can find the documentation on this here:
http://www.postgresql.org/docs/7.4/interactive/client-authentication.html
--
Jeff Frost, Owner
ectory in the user's profile).
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 4: Have you search
Since we're on the vacuum kick these days, what's the best way to tell if my
autovacuum settings are working well? I'm sure I can query some info out of
the pg_stats tables, no?
Also, if using autovacuum, should I still do a vacuum full on a regular
basis?
--
Je
eye on
"du $PGDATA" or pg_class.relpages entries.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 5: don
idea what it is/does. I'm new to postgresql
(obviously). Thanks for your time. -John
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)-
what if my database has ~200GB and more (I know this is a future :D)?
From my point of view it won't be good idea to copy entire database to backup
array. I would like to here opinions about this case - what do you propose?
Maybe some of you already do something like this?
--
Jeff Frost,
Before I reinvent the wheel, has someone already written a logwatch filter for
slony logs? I googled for logwatch slony to no avail.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-64
there are 3
files that have not been archived, sometimes there are 4, and sometimes there
are more.So, my question is, when is archive_command invoked?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 F
chive" | tail -1
(My pg_xlog is on a different disk set from the PGDATA dir.)
It appears to work fine for me. Don't forget to make a base backup before you
begin the WAL archiving, or you won't be able to restore anything.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Fr
000DF
0001001300E0
0001001300E1
0001001300E2
0001001300E3
0001001300E4
0001001300E5
0001001300E6
Given that list, does that mean that 0001001300DF is the in use
WAL file?
--
Jeff Frost, Owner <[EMAIL PROTECTED
there
is only one timeline, but I'd love to generalize the script so we can put it
in contrib, but first I'd like to make sure it actually works properly. :-)
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650
ignal the postmaster (using pg_ctl reload or kill -HUP) to make it re-read
the file.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end o
Is it at all possible to manually replay archived WAL files after restoring
from a pg_dump dumpfile?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of bro
red from a nightly pg_dump which we have kept doing, but that means we
lost about 20 hrs of data. :-(
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcas
nder maximum stress, from experience.)
I absolutely agree..unfortunately, it's only been 3 months since the last
test. :-(
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
tching roles between the biweekly base
backups.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 1: if posting/read
-1 flag when you put ls to a pipe.
-Jeff
FILE=$( ls -t1p $PGXLOG | grep -v / | head -1 )
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)-
ually running after the box gets into multi user mode?
If not, I'd look at paths and permissions. Does anything show up in the logs
to indicate why it might have failed? Is the script atttempting to start it
as the incorrect user perhaps?
--
Jeff Frost, Owner <[EMAIL PROT
{PARTIAL}/${FILE}.partial
find ${PARTIAL} -name *.partial | grep -v ${FILE} | xargs -i rm -fr {}
}
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broa
e they could be transferred (code
24) at main.c(791)
PITR base backup rsync command failed!
Would it be ok to just exclude the pg_internal.init file since it disappeared
during the base backup?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com
2005 at 11:25:25 -0700,
Jeff Frost <[EMAIL PROTECTED]> wrote:
Is it at all possible to manually replay archived WAL files after restoring
from a pg_dump dumpfile?
You probably want to look at:
http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html
That is from the soon to
t:
24 Partial transfer due to vanished source files
So I can just consider an exit code of 0 or 24 as both being success.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---
ot:
/etc/init.d/postgresql-8.0 start
What did I do wrong, and even more important, what should I do?
TIA
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---
history
Can you post the output?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
also run 8.1.0 on the same server? Then, I could copy the
data and support two databases until things looked good. Then, I'd shutdown
8.0.3.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 6
own a problem of this nature.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
m curious as to why initdb is kicking off when you su to the postgres user
though. Is this how the solaris pkg is set up?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
On Sat, 19 Nov
opt/sfw/lib
On Sat, 19 Nov 2005, olive Mckenzie wrote:
Hello Jeff Frost,
I have installed installed libreadline.so.4. When I do a search for it I
find it in /opt/sfw/lib.
initdb kicks off even if i try the command from root.
Olive
Jeff Frost <[EMAIL PROTECTED]> wrote:
Olive,
Y
init file I should insert it into.
Olive
Jeff Frost <[EMAIL PROTECTED]> wrote:
Olive,
You need to locate the libreadline.so.4 shared library on your system. I'm
guessing it's not in any of the standard locations and then add that path to
your LD_LIBRARY_PATH. You might
Honestly, I have no idea, but I think you would be better served by posting
this to a Solaris x86 mailing list. The charter of this list is really
postgresql administration based and not solaris x86 based.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC
What is the exact command you are running (copy/paste)? As simply issuing "su
postgres" should not run initdb on login.
I typed
# su postgres
$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
Well, that's quite different than what you mentioned before. You should do it
like this:
Chase: Search multiple travel sites in one click.
http://farechase.yahoo.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Jeff Frost, Owner <[EMAIL PROTECTED
antly failing with an authentication failure
psql -U vinodsr vinodsr < C:\MU\BP_BUSINESS_PARTNER_PARTY.dat
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(en
Use the .pgpass file.
On Thu, 1 Dec 2005, Theo Galanakis wrote:
database.bak prompts me for a password. How can I run the psql command
without being prompted for a password. The password prompt and < command
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, L
quest would be
welcome..maybe advocacy or the general list?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 9:
distributed with v8.1
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Run the following query:
show data_directory;
On Fri, 16 Dec 2005, Ken Hill wrote:
database, but I can find the directory where the database are kept. How
do I find where the postgresql database directory is from a command
line?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
/postmaster -p 5432 -D /var/lib/pgsql/data
Which means the data directory is /var/lib/pgsql/data.
database, but I can find the directory where the database are kept. How
do I find where the postgresql database directory is from a command
line?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Bortolucci wrote:
Hi,
What are the correct steps to move an database and from an server running
postgreslq 7.4.2 to another running 8.0.3?
--
Richard Bortolucci
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908
Greg, I'm not sure what you're looking for in the way of suggestions. Do
you just want to be able to start this postgres server up and remove some
data? Easiest way I see to accomplish that given the information you
provided is to move pg_xlog to the sda disk and symlink it to the data dir.
In
Greg,
Does pg_ctl stop -m immediate stop the postmaster for you?
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PRO
Seems like you're going to have to kill -9.
On Mon, 2 Jan 2006, Gregory S. Williamson wrote:
I tried
su - postgres -c '/apps/pgsql-7.4/bin/pg_ctl stop -D /data/postgres/gex_runtime
-m immediate'
on one of the two hozed servers and that's (I think) what got this:
---(
unefs.
Jim, excellent thought! And on Linux at least you can change it with the
filesystem still mounted:
tune2fs -m 0 /dev/sdb1
would probably do the trick.
You might want to set it back after you're done though. :-) Default appears
to be 5 on my machine.
--
Jeff Frost, Owner
at in the help files and documentaion
provided with the package. I really need this to work
and any help/tip/example is greatly appreciated.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 6
BASEDIR=c:\postgres
Getting this error
Failed to create process for initdb: Logon Failure:
Unknown user name or bad password.
is there something wrong I'm doing?
Regards,
Sean
--- Jeff Frost <[EMAIL PROTECTED]> wrote:
Sean,
See the documentation here:
http://pginstaller.proj
ctl: too many command-line arguments (first is "Files\PostgreSQL\8.0\data")
Try "pg_ctl --help" for more information.
Please explain me what i need to do...
-Sandhya
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.co
evious case.
But the same i did throug command line and worked file.Through application
it is not doing.
Please help me.I need it very urgently.
- Original Message -----
From: "Jeff Frost" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgre
atabase i am getting the
following error.
Please help me what i need to do
Insert into sampletbl values(lo_import('c:\\sample.txt'),'sample.txt');
ERROR: function lo_import ("unknown") does not exist
HINT: No function matches the given name and argument types. Y
or the
user you are trying to access the file as does not have the rights to read it.
Again, check your permissions as I mentioned to you earlier.
On Wed, 18 Jan 2006, Jeff Frost wrote:
This is what works for me from the command line on Linux with PG 8.0.3:
INSERT into images VALUES ( lo_im
Is it reasonable to mount the PGDATA filesystem with data=writeback on ext3 as
long as the PGXLOG filesystem is mounted data=ordered and fsync=on? Or is
this only acceptable if you have battery backed controllers?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC
built
via REINDEX:
select schemaname,relname,indexrelname,idx_tup_read,idx_tup_fetch from
pg_stat_user_indexes where idx_tup_read != idx_tup_fetch;
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 6
or a heap fetch to
any particular index is impractical and likely misleading anyway.)
So how might I find indexes which are bloated and might need reindexing? I
know this behavior less likely in 8.x, but the docs still indicate it is
possible to have index bloat in recent versions of postgres.
it got
this way. Has anyone done chmods on /tmp? It should be 1777/drwxrwxrwt, so a
chmod 1777 /tmp should fix it
for you.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---
suitably short when the
secondary is needed. Also a good idea to do test recovers on occassion to
make sure you don't have any corrupt WAL files. If you use rsync, then you
can make the base backup pretty quickly depending on how much of your DB
changes.
--
Jeff Frost, Owner
for client authentication? It
sounds like you have a root.crt in your PGDATA directory, but your clients are
not setup to provide a certificate upon connection and thus the server is
denying access.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostc
.e.
we'll be going to a continuous recovery methodology). Hopefully we'll get
some interest from more folks soon and get some good ideas flowing.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FA
die "Could not cp $FULLPATH to $PITRDESTDIR/$FILENAME"
fi
/usr/bin/gzip -f "$PITRDESTDIR/$FILENAME"
#
# Make sure it worked, otherwise roll back
#
if [ $? -ne 0 ]; then
/bin/rm -f "$PITRDESTDIR/$FILENAME"
die "Could not /usr/bin/gzip $PITRDESTDIR/$FILE
.1.3 compiled from source.
PGDATA is in /usr/local/pgsql/data which is a local RAID10 array, and /pg_xlog
is mounted on a local RAID1.
Things that touch the /mnt/pgbackup directory are the pitr base backup scripts
which run twice monthly and the archive_command script.
--
Jeff Fros
duce: put a long
sleep in the archive-command script.
Thanks Tom. I'll try and reproduce on one of the other PG servers I have
available when I have a chance and get back to you if it looks like a possible
bug.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC
On Mon, 15 May 2006, Simon Riggs wrote:
On Mon, 2006-05-15 at 09:28 -0700, Jeff Frost wrote:
I've run into a problem with a PITR setup at a client. The problem is that
whenever the CIFS NAS device that we're mounting at /mnt/pgbackup has
problems
What kind of problems?
10016009A"
May 15 02:07:07 db3 crond(pam_unix)[14632]: session closed for user postgres
May 15 02:07:33 db3 postgres[14702]: [1-1] LOG: autovacuum: processing database
"postgres"
May 15 02:08:48 db3 postgres[14724]: [1-1] LOG: autovacuum: processing
uld hit 32k transactions around 10-11 minutes...does that fit in
with our timing from above? (Tom, I'm not sure which timing you're
using.)
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FA
. Maybe this is just a
linux kernel thing? Or maybe something else is blocking because it tries to
stat all the filesystems and /mnt/pgbackup blocks? I can't imagine postgres
doing that though.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsu
ce, but I'm just getting started.
Currently I'm using pgbench to generate WAL rollover, do you guys have any
other handy testing tools for this sort of job or is this the best tool?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingll
On Wed, 17 May 2006, Jeff Frost wrote:
On Wed, 17 May 2006, Tom Lane wrote:
Did you try generating a test case using a long sleep() as a replacement
for the archive_command script? If there is a PG bug here it shouldn't
be that hard to expose it in a simple test case. I'm up to
On Thu, 18 May 2006, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
I seem to get alot of these:
May 17 21:34:04 discord postgres[20573]: [5-1] WARNING: could not rename file
"pg_xlog/archive_status/00010001.ready" to
May 17 21:34:04 discord postg
On Wed, 17 May 2006, Jeff Frost wrote:
And in the window where I started postgres via pg_ctl, I had this:
cat: pg_xlog/0001000E: No such file or directory
cat: pg_xlog/0001000E: No such file or directory
Hrmmm...my pgbench died with an integer out of range
the test so I can capture the
logging to syslog for you guys as well as the stdout on the pg_ctl console.
More later.
Unfortunately, I'm not really sure this is related to the problems we saw
before. (i.e. the system doesn't get unusually slow or anything, nor do the
connection
On Fri, 19 May 2006, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
Do you think the postmaster on 5432 is trying to archive the other
postmaster's WAL files somehow?
Not as long as they aren't in the same data directory ;-). What Simon
was wondering about was whe
ou want me to test a patch since I've already got this test
case setup.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)
restarted?
I looked through /var/log/messages* and there wasn't a restart prior to the
problem in the logs. They go back to April 16. The postmaster was restarted
on May 15th (this Monday), but that was after the reported problem.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Fr
n attempting to reproduce the problem?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 5: don't forget to in
ilure to see if that could be it.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 1: if posting/reading thro
with the same archive_command script and a CIFS mount just to see what
happens. Perhaps the real root of the problem is elsewhere, it just seems
strange since the archive_command is the only postgres related process that
accesses the CIFS share. More later.
--
Jeff Frost, Owner <[EMAIL
On Sun, 21 May 2006, Jeff Frost wrote:
So the chances of the original problem being archiver related are
receding...
This is possible, but I guess I should try and reproduce the actual problem
with the same archive_command script and a CIFS mount just to see what
happens. Perhaps the real
uggestions or inspirations, I'm all ears!
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 3: Have you c
On Fri, 19 May 2006, Simon Riggs wrote:
On Thu, 2006-05-18 at 10:08 -0700, Jeff Frost wrote:
May 18 08:00:18 discord postgres[20228]: [129-1] LOG: archived transaction log file
"0001007F"
May 18 08:00:41 discord postgres[20573]: [254-1] LOG: archived transactio
tom format with
default compression.
I need to get a reasonable dump so I can upgrade this ancient system. Should
I upgrade to the most recent 7.3.x version before doing the dump to have the
most reasonable chance of success?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consul
1 - 100 of 226 matches
Mail list logo
