unavailable. After restoration from backup,
we haven't seen the errors again.
We're running 8.0.13 on FC3. Is there any reason not to suspect the
hardware at this point?
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http
On Apr 23, 5:36 am, [EMAIL PROTECTED] (Simon Riggs) wrote:
On Wed, 2007-04-18 at 18:11 -0500, Thomas F. O'Connell wrote:
Wanting a nice test of restartable recovery and pg_standby in a
warm
standby server scenario I'm testing, today I pulled the plug on the
box where I was using Simon's
patching pg_standby.c if no
one beats me to it.
--
Thomas F. O'Connell
optimizing modern web applications
: for search engines, for usability, and for performance :
http://o.ptimized.com/
615-260-0005
, please let me know.
--
Thomas F. O'Connell
Database Architecture and Programming
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)
---(end of broadcast
On May 22, 2006, at 8:16 PM, Alvaro Herrera wrote:
Thomas F. O'Connell wrote:
When I kill these off individually using kill and then shut down the
postmaster with pg_ctl immediate mode, I will occasionally find a
backend process that cannot be killed, even with a KILL (-9) signal
or
VACUUM FULL + REINDEX.
--
Thomas F. O'Connell
Database Architecture and Programming
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)
---(end of broadcast
the number of relations
in this cluster? Is a vacuumdb/reindexdb cycle necessary to reclaim
disk space?
--
Thomas F. O'Connell
Database Architecture and Programming
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469
On Apr 19, 2006, at 6:42 PM, Tom Lane wrote:
Thomas F. O'Connell [EMAIL PROTECTED] writes:
Any tips on turning ERROR: invalid page header in block 34 of
relation into a pg_filedump command that would yield something
useful
or interesting? If so, I'll post the results of all three
On Apr 18, 2006, at 2:15 PM, Tom Lane wrote:
Thomas F. O'Connell [EMAIL PROTECTED] writes:
I would've expected the RAID to protect postgres from the possibility
of data corruption, but I guess not.
Ooops :-(. It might be interesting to get pg_filedump dumps of the
corrupted pages, just to see
a little nervous about the prospects for analysis and recovery
here. Any thoughts?
Is there a risk that if we took postgres offline in this state that
it would not come back up?
--
Thomas F. O'Connell
Database Architecture and Programming
Sitening, LLC
http://www.sitening.com/
3004 B
On Apr 18, 2006, at 12:30 PM, Thomas F. O'Connell wrote:
So there are currently three separate relations exhibiting invalid
page errors.
This box is a Debian 3.1 box running a custom Linux 2.6.10 #6 SMP
kernel. Postgres 8.1.3 was compiled from source. pgpool 3.0.1, also
built from
On Apr 18, 2006, at 2:15 PM, Tom Lane wrote:
Thomas F. O'Connell [EMAIL PROTECTED] writes:
I would've expected the RAID to protect postgres from the possibility
of data corruption, but I guess not.
Ooops :-(. It might be interesting to get pg_filedump dumps of the
corrupted pages, just
On Apr 18, 2006, at 2:57 PM, Tom Lane wrote:
Thomas F. O'Connell [EMAIL PROTECTED] writes:
In the meantime, should I leave the database online while I attempt
to recover? It's still unclear to me whether postgres will restart
with invalid page headers. I certainly can't run pg_dumpall
database is not actually available until something
triggers it to recover, at which point any writing done to it causes
it to cease to be a replicant of the base database.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B
?
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)
---(end of broadcast)---
TIP 3: Have
know that nothing will access the recovery database with
write activity, is there a way to toggle the continuity so that I
could allow recovery to complete on a nightly basis, pg_dump the
recovered database (a read-only action), and then resume recovering?
--
Thomas F. O'Connell
Database
On Mar 4, 2006, at 3:56 AM, Simon Riggs wrote:
On Fri, 2006-03-03 at 12:03 -0600, Thomas F. O'Connell wrote:
On Mar 3, 2006, at 11:54 AM, Simon Riggs wrote:
On Thu, 2006-03-02 at 16:38 -0600, Thomas F. O'Connell wrote:
Ideally, I'd be able to take a base backup of a production system,
copy
On Mar 3, 2006, at 11:54 AM, Simon Riggs wrote:
On Thu, 2006-03-02 at 16:38 -0600, Thomas F. O'Connell wrote:
Ideally, I'd be able to take a base backup of a production system,
copy it to a remote system, which is also the repository for segment
files generated by archive_command
in the short term.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)
---(end of broadcast
as I expect it might be able
to, would there ever be a reason to redo it from scratch (i.e., is
one base backup sufficient ad infinitum)?
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
On Dec 12, 2005, at 12:49 AM, Helbling Julien wrote: Postgres 8.0.2 for Windows is install on a Microsoft Windows Server 2003 system. The installation was made with all the default values. We made a backup of one of our database with the following instruction : pg_dump –i –h serverName –p
-
structures.html#PLPGSQL-STATEMENTS-RETURNING
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)
---(end of broadcast
On Nov 9, 2005, at 12:24 AM, hubert depesz lubaczewski wrote:On 11/8/05, Andrew Watters [EMAIL PROTECTED] wrote: I am trying to find details about open connections. I can see that thereare open connections through Tools | Server Status in pgAdmin III. Howcan I find what the current and/or last SQL
On Nov 8, 2005, at 3:07 AM, Martin Schievink wrote: We’re having problems restoring a database, we dumped and tried to restore on the same databaseserver., and used the command: pg_dump -Ft -b {dbname} {filename} to dump the database and pg_restore -d {dbname} {filename} to restore the
On Fri, 2005-10-14 at 15:49, Thomas F. O'Connell wrote:
The culprit that ended up leading to my original post was an NFS
script that cleans out /tmp. It was running as the last thing in a
given boot level, so it blew away the socket file in /tmp.
I'm sure you already know this, but wildly
seems like something about that deserves mention
somewhere in the postgres documentation since the default for
unix_socket_directory is /tmp.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Open Source Solutions. Optimized Web Development.
http://www.sitening.com/
110
was seeing.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Open Source Solutions. Optimized Web Development.
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)
On Oct 13, 2005, at 9:40 PM, Thomas F. O'Connell
that could happen in terms of order of
operations or pathing during the boot process that I am overlooking?
Also, is there any way to get more status out of a postmaster if one
cannot connect to it? I am able to run pg_ctl status and
pg_controldata, both of which return normally.
--
Thomas F
On Oct 13, 2005, at 9:35 PM, Tom Lane wrote:
Thomas F. O'Connell [EMAIL PROTECTED] writes:
When I restart, everything seems to come up fine with the exception
that postmaster starts in a state such that it doesn't seem to be
accepting connections (either over UNIX or TCP/IP). As best I can
On Sep 19, 2005, at 8:31 AM, Gandeed Phanibhushan Rao-A18356 wrote: HI, I have a 128MB RAM based Linux (Redhat 9.0) desktop. I have installed Postgres 8.0.3 server in my system, for my application usage. A bit novice, so not much aware of the configuration of tuning the database. My
.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)
---(end of broadcast)---
TIP
Could you use Slony-I's recently added log shipping feature?
http://slony.info/
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Jul 11
In the source tarballs, it's in the main postgres directory. I don't
know where it is in RPMs or other packages. I typically build postgres
from source.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i
http://www.sitening.com/
110
to that, then there is no convenient
way to kill it.
You can correlate processes to queries using the pg_stat_activity view.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
For size information, see contrib/dbsize in the source tree.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Apr 21, 2005, at 10:25 AM
For an explanation of the purpose and behavior of initlocation, look
here:
http://www.postgresql.org/docs/7.4/static/app-initlocation.html
You can call it with an explicit path (e.g.,
/usr/lib/postgresql/bin/initlocation), or you can add it to your path.
-tfo
--
Thomas F. O'Connell
Co-Founder
Have you considered trying pg_autovacuum, which is in contrib? It
actually sets and monitors thresholds to try to determine dynamically
when tables need vacuuming.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite
:
Note that ABORT will not be issued if the backend is 7.4 or later
and the session is not in a transaction block.
I'm just curious why I'm still seeing the ABORTs if these sessions are
not in a transaction block.
I'm running postgres 7.4.6 and pgpool 2.5.1.
-tfo
--
Thomas F. O'Connell
Co
post more information about your system, including
platform, postgres version, and salient features of your
postgresql.conf file.
The more information you're able to provide, the more help people on
this list will be able to give you.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information
I think you need to provide more information to get any help with your
setup.
For one thing, why are you restarting? Are you restarting the server?
Postgres? In general, there should be no need to restart either.
Next, what do you mean by broken bad after a full vacuum?
-tfo
--
Thomas F
, needs to be a
system
restart.
If we do not do that restart, then things are 'broken bad', as the
system
becomes incredibly slow. Not broken after the vacuum, it is a gradual
decline in performance.
Hope that makes more sense.
Many thanks
-Original Message-
From: Thomas F. O'Connell
Well, there's always the dbsize module in contrib to check actual size
on disk. I was thinking more in terms of approximate numbers of tables
and rows in those tables.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North
F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 3, 2005, at 3:56 PM, Ken Reid wrote:
I am new to postgres and was wondering if table partitioning
is supported in Postgres. And if so
-authentication.html
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 4, 2005, at 8:45 AM, David Wagoner wrote:
I've been reading the docs and FAQs for a method to setup
). Then restore the
original pg_hba.conf file.
I'm curious, though, too, to know whether anyone has anything more
sophisticated.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
So these two statements seem to be somewhat contradictory.
What's the point of -C if not to create the database named in -d?
And why does -C -d template1 work but not -C -d mypgsql?
-tfo
[EMAIL PROTECTED] (Tom Lane) wrote in message news:[EMAIL PROTECTED]...
Whatever database you name in -d
A while back, there was a thread on this list called pg_restore
problem with 7.3.1. It outlined a scenario very similar to one I'm
having problems with. Granted, they're not serious problems (in the
sense that there's an acceptable workaround), but they suggest that
either pg_restore is not
is there any way in postgres (7.1.3) to get postgres to source the
pg_hba.conf file without restarting the database completely?
will any new backend use a modified pg_hba.conf if it is modified while
postgres is running?
-tfo
---(end of
In 7.1.X and earlier, pg_hba.conf is reread on every connection request.
7.2.X will requires a sighup to the postmaster to reload pg_hba.conf.
why the change?
-tfo
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please
If I modify function A (drop re_create), then I have to re_create
function B though no change to function B.
Is there any way (sql stmt) let me re_load function B's defination
without using drop and create??
i have not figured out a way to do anything like this. an additional
frustration
50 matches
Mail list logo