Linux version 2.6.5-7.252-bigsmp ([EMAIL PROTECTED]) (gcc version 3.3.3 (SuSE
Linux)) #1 SMP Tue Feb 14 11:11:04 UTC 2006
PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 (SuSE
Linux)
Database 212GB on RAID 5.
4 x Intel(R) XEON(TM) MP CPU 2.00GHz
total
>>> On Tue, Jun 19, 2007 at 8:07 AM, in message <[EMAIL PROTECTED]>,
Chander Ganesan <[EMAIL PROTECTED]> wrote:
> Kevin Grittner wrote:
>>
>> weekly maintenance process which builds a new version of a table based on
>> records retention rules. It
>>> On Tue, Jun 19, 2007 at 11:16 AM, in message <[EMAIL PROTECTED]>,
Tom Arthurs <[EMAIL PROTECTED]> wrote:
>
> Looks like you are expecting the archive command to run when you shut
> down the data base. It won't. It only runs when the xlog gets full and
> the system needs to recycle to a new
Thanks, all. Just an FYI to wrap up the thread.
>>> On Mon, Jun 18, 2007 at 3:25 PM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> writes:
>> I'm suspicious that either the contro
>>> On Thu, Jun 28, 2007 at 2:55 PM, in message
<[EMAIL PROTECTED]>, "George Wilk"
<[EMAIL PROTECTED]> wrote:
>
> FATAL: could not restore file "0001003A" from archive:
> return code 34048
>
> LOG: startup process (PID 13994) exited with exit code 1
>
> LOG: aborting startup
>>> On Fri, Jun 29, 2007 at 9:52 AM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Simon Riggs" <[EMAIL PROTECTED]> writes:
>> Just ignore 0001. Recovery will work fine even if absent. Don't
>> ignore all history files though, just that one. Hmmm, come to think of
>>
>>> On Fri, Jun 29, 2007 at 11:47 AM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
>
> History files are only created when you do a PITR recovery that stops
> short of the end of WAL (ie, you gave it an explicit stopping point
> criterion). So basically they never appear e
>>> On Fri, Jun 29, 2007 at 12:29 PM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Kevin Grittner" <[EMAIL PROTECTED]> writes:
>> Tom Lane <[EMAIL PROTECTED]> wrote:
>>> Offhand I would recommend the same s
>>> On Fri, Jul 6, 2007 at 12:48 PM, in message
<[EMAIL PROTECTED]>, Mary Anderson
<[EMAIL PROTECTED]> wrote:
>
> I have been asked if it is possible to asynchronously replicate a
> postgresql database to ms-sql. My answer is yes, provided postgresql
> ORM features aren't used in the desig
>>> On Fri, Jul 27, 2007 at 9:49 AM, in message
<[EMAIL PROTECTED]>, "George Wilk"
<[EMAIL PROTECTED]> wrote:
> Is there a reliable way of verifying version of the database by looking at
> the PGDATA directory?
Could you use the first couple lines of output from pg_controldata?
-Kevin
--
We have a database in each Wisconsin county which is part of the official
court record for the circuit courts in that county. We are required to keep
a backup in each county, such that we could recover a lost or corrupted
database with what is in the county (as well as keeping at least four
separa
> >>> Decibel! <[EMAIL PROTECTED]> 08/07/07 1:28 PM >>>
> On Tue, Aug 07, 2007 at 06:29:35AM -0500, Kevin Grittner wrote:
>> We have a database in each Wisconsin county which is part of the official
>> court record for the circuit courts in that count
> >>> Decibel! <[EMAIL PROTECTED]> 08/07/07 4:51 PM >>>
> On Tue, Aug 07, 2007 at 02:12:29PM -0500, Kevin Grittner wrote:
> > > Copying a 16MB file that's already in memory isn't exactly an intensive
> > > operation...
> >
> &
>>> On Tue, Aug 7, 2007 at 10:31 PM, in message
<[EMAIL PROTECTED]>, Andrew Kroeger
<[EMAIL PROTECTED]> wrote:
> Kevin Grittner wrote:
>> The Netware server supports ssh, scp, and an rsync daemon. I don't see how
>> the ssh implementation is helpf
>>> On Thu, Aug 9, 2007 at 4:37 PM, in message
<[EMAIL PROTECTED]>, "Tena Sakai"
<[EMAIL PROTECTED]> wrote:
> I have, by default, on a linux machine, a file called
> serverlog in the data directory, whose entries often
> prove to be very useful. What would be even more useful
> would be a timest
>>> On Mon, Aug 13, 2007 at 12:24 AM, in message
<[EMAIL PROTECTED]>,
"Khan, Mahmood Ahram" <[EMAIL PROTECTED]> wrote:
> To enable the auditing I need to create this function which I am unable
> to & the error below.
Add a line like this after you include the PostgreSQL .h files:
PG_MODULE_MAG
>>> On Mon, Aug 13, 2007 at 12:50 PM, in message <[EMAIL PROTECTED]>,
olivier boissard <[EMAIL PROTECTED]> wrote:
> I tried to use the except command in postgresql 8.1
> I don't understand as it works
> When I read doc , I understand that it was like a difference betwwen two
> queries
That isn't
>>> On Mon, Aug 13, 2007 at 1:13 PM, in message
<[EMAIL PROTECTED]>, Steve Holdoway
<[EMAIL PROTECTED]> wrote:
> On Mon, 13 Aug 2007 13:07:43 -0500
> "Kevin Grittner" <[EMAIL PROTECTED]> wrote:
>> This gets me all the eye color codes that don
>>> On Mon, Aug 13, 2007 at 4:30 PM, in message <[EMAIL PROTECTED]>,
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> So it's like a filter on the first query
Exactly; I think that sums it up better than anything I said.
By the way, it does strike me as an odd omission that there is no set
ope
>>> On Tue, Aug 14, 2007 at 6:29 AM, in message
<[EMAIL PROTECTED]>,
"Kuriakose, Cinu Cheriyamoozhiyil" <[EMAIL PROTECTED]> wrote:
> Can anyone please tell me how to download the PostgreSQL-7.1 source code
> through CVS, i use the following set of commands to get the source code
> of postgreSQL.
>>> On Tue, Aug 14, 2007 at 8:48 AM, in message
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
wrote:
> I was studying a solution which foresees the 'case when' construct...
> now I can use it in addition to array_to_string . In fact my solution
> failed too if , but if there are some more
> values I
>>> On Fri, Aug 17, 2007 at 4:50 AM, in message
<[EMAIL PROTECTED]>, Peter Elmers <[EMAIL PROTECTED]>
wrote:
> I want to know whether there exist the possibility to create a user
> who has the permission to create users with preset limited permissions.
>
> In detail:
> I do not want that the a
>>> On Tue, Aug 21, 2007 at 9:50 AM, in message <[EMAIL PROTECTED]>,
smiley2211 <[EMAIL PROTECTED]> wrote:
> Do I have to DROP \ recreate and load the target database (this is what I
> currently do)? is there a way to just do an IN PLACE load like in other
> RDBMS environments???
>
> pg_dump p
>>> On Tue, Aug 21, 2007 at 7:23 PM, in message <[EMAIL PROTECTED]>,
David Wall <[EMAIL PROTECTED]> wrote:
> I'm using cygwin on WinXP
>
> gunzip -c backup81.gz | pg_restore -v -O -d mydb
>
> This returned an error: pg_restore: [archiver] did not find magic
> string in file header
Out of cu
>>> On Tue, Aug 21, 2007 at 7:28 PM, in message
<[EMAIL PROTECTED]>, "Tena Sakai"
<[EMAIL PROTECTED]> wrote:
>
> On my linux machine, gnu tar is the tar. Does
> anybody have a suggestion as to where I can go
> to get a tar that is not gnu?
Have you considered using cpio instead?
http://www.
I'm looking for advice on how to best switch from warm standby processing to
"stand-in" production use in our (rather unusual) environment.
THE ENVIRONMENT
We have 72 counties spread around the state, each with their own database,
which contains the official data for that county's court system.
Thanks for the reply, Scott.
>>> On Wed, Aug 22, 2007 at 5:04 PM, in message
<[EMAIL PROTECTED]>, "Scott Marlowe"
<[EMAIL PROTECTED]> wrote:
> On 8/22/07, Kevin Grittner <[EMAIL PROTECTED]> wrote:
>
>> How do we create the PostgreSQL instance o
>>> On Wed, Aug 29, 2007 at 1:53 AM, in message
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
wrote:
> I've to perform a where condition which includes the output from a
> multiselectio pop-up: ie user can choose one or more item from a pop-up
> munu, let's say (item1,item3,item10), then I want to
>>> On Wed, Aug 29, 2007 at 9:48 AM, in message
<[EMAIL PROTECTED]>, Robert Treat
<[EMAIL PROTECTED]> wrote:
> Looking at last checkpoint location in pg_control, I see:
> Latest checkpoint location: 1C/8001E848
>
> How does one translate that into an xlog file name?
Unless you've got
>>> On Fri, Aug 31, 2007 at 8:51 AM, in message
<[EMAIL PROTECTED]>, "Jayaram Bhat"
<[EMAIL PROTECTED]> wrote:
> can it possiable to uses Postgresql in windows. From where i will verions
> for that
That was rather off-topic for the thread -- you should have started a new
one.
Anyway, if I u
I ran into an issue with restarting a box after power was cycled with 72
instances of PostgreSQL running. The problem appeared to be that the old
pid files, which PostgreSQL never got a chance to clean up, were causing
problems when the instances were started or stopped, due to reuse of the
pids b
>>> On Tue, Sep 4, 2007 at 11:59 AM, in message
<[EMAIL PROTECTED]>, "Tena Sakai"
<[EMAIL PROTECTED]> wrote:
> In my configuration file both lines
> #listen_addresses = 'localhost'
> and
> #port = 5432
> are commented out.
>
> What does this mean? Is postgress listening on port
> 5432?
Yes
>>> On Tue, Sep 4, 2007 at 1:18 PM, in message
<[EMAIL PROTECTED]>, "Tena Sakai"
<[EMAIL PROTECTED]> wrote:
> '*' is a bit too wide for my taste. I wonder
> if it is possible to specify something like
> network mask (or range)?
This is not the IP list you will listen *to*, but the IP list you
>>> On Wed, Sep 19, 2007 at 12:49 PM, in message
<[EMAIL PROTECTED]>, "Tena Sakai"
<[EMAIL PROTECTED]> wrote:
> A few days ago, I edited a line in pg_hba.conf file
> and issued the command
> pg_ctl -D /usr/local/pgsql/data restart
A reload would have done the trick.
> Since then (or very clo
>>> On Wed, Sep 19, 2007 at 1:45 PM, in message
<[EMAIL PROTECTED]>, "Tena Sakai"
<[EMAIL PROTECTED]> wrote:
>
> The reason why I used restart (instead of reload) is I
> read in the manual that after I edit pg_hba.conf (section
> after "# Put your actual configuration here" line), I
> needed to
>>> On Wed, Sep 19, 2007 at 7:43 AM, in message
<[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> wrote:
>
> I have to create a schedule in the Postgres to insert
> some data in the table. But before creating this schedule, i create
> schedule that create the table in the Database specified.
Please respond to the list as well as any individuals. This helps make
the archive message thread useful for others who may have a similar
problem, and it may draw advice from others who can help.
>>> On Thu, Sep 20, 2007 at 11:01 PM, in message
<[EMAIL PROTECTED]>, "Yogesh Arora"
<[EMAIL PROTEC
>>> On Mon, Oct 15, 2007 at 12:34 PM, in message
<[EMAIL PROTECTED]>, "Jonah H.
Harris" <[EMAIL PROTECTED]> wrote:
>
> There used to be a pg_terminate_backend, but it was #ifdef'd out due
> to corruption concerns. Basically, all it did was:
>
> kill -TERM pid
>
> I'm not sure whether anyone ha
>>> On Thu, Oct 18, 2007 at 1:01 AM, in message
<[EMAIL PROTECTED]>, yogesh
<[EMAIL PROTECTED]> wrote:
> What is the Command to drop the Not Null Constraint from a Column
http://www.postgresql.org/docs/8.2/interactive/sql-altertable.html
---(end of broadcast)
>>> On Fri, Oct 19, 2007 at 1:40 AM, in message
<[EMAIL PROTECTED]>, "Mikko Partio"
<[EMAIL PROTECTED]> wrote:
>
> To make use of the backup, you will need to keep around all the WAL segment
> files generated during and after the file system backup. To aid you in doing
> this, the pg_stop_backup
>>> On Tue, Oct 30, 2007 at 7:57 AM, in message
<[EMAIL PROTECTED]>,
"Nandakumar Tantry" <[EMAIL PROTECTED]> wrote:
> Does any-ne know how to install PostgreSQL with
> Administrator account? If not how will I do it?
That is a very bad idea from a security standpoint, which is why
>>> On Tue, Oct 30, 2007 at 11:28 PM, in message
<[EMAIL PROTECTED]>,
"Nandakumar Tantry" <[EMAIL PROTECTED]> wrote:
> I have attached my Installation problem in Image File and log file.
This (from the log file) looks odd:
> fixing permissions on existing directory C:/Program Files/PostgreSQ
>>> On Wed, Nov 14, 2007 at 3:16 PM, in message
<[EMAIL PROTECTED]>, "Scott Marlowe"
<[EMAIL PROTECTED]> wrote:
> On Nov 14, 2007 2:26 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
>> INFO: vacuuming "public.allele"
>> INFO: "allele": found 2518282 removable, 1257262 nonremovable row versions
>
>>> On Wed, Nov 14, 2007 at 4:08 PM, in message
<[EMAIL PROTECTED]>, "Cristiano
Marques" <[EMAIL PROTECTED]> wrote:
> I have necessity of integrate a data base
> Sybase and data base Postgresql. The propose is migration data of
> approximate 7000 tables.
>
> I like make cluster of two bases.
>
>>> On Fri, Dec 14, 2007 at 10:30 AM, in message
<[EMAIL PROTECTED]>, Glyn Astill
<[EMAIL PROTECTED]> wrote:
> We need to encrypt an individual column in a table. I've noticed that
> pgcrypto can do this.
>
> However we have one problem, our software runs through a closed
> source "connectivity
>>> On Tue, Dec 18, 2007 at 12:55 PM, in message <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> wrote:
> "David F. Skoll" <[EMAIL PROTECTED]> writes:
>> My question is this: If the master database is fairly busy, gets
>> VACUUMed once a day, etc. can we expect the warm standby server
>> to wor
>>> On Tue, Jan 15, 2008 at 3:33 AM, in message <[EMAIL PROTECTED]>,
Thomas Markus <[EMAIL PROTECTED]> wrote:
> update tablename set datecol=null
> ~ 2.3 mio rows
>
> After 6 hours, this was still not finished. selects and inserts are ok.
> System is a dual xeon, 8gb ram, debian 64bit, pg 8.
>>> On Wed, Jan 30, 2008 at 3:53 AM, in message
<[EMAIL PROTECTED]>, Honza Novak
<[EMAIL PROTECTED]> wrote:
> The problem is that it looks
> like, that once the open connection takes some memory, it never gives
> that memory back, which ends up with our server swapping large amounts
> of mem
>>> On Tue, Mar 4, 2008 at 5:07 PM, in message
<[EMAIL PROTECTED]>, "Daniel Punton"
<[EMAIL PROTECTED]> wrote:
> Our redhat server was restarted and postgres is showing different databases
> on different ports?
> Could someone explain how this might happen
> and where this information comes from
>>> On Wed, Mar 5, 2008 at 9:32 AM, in message
<[EMAIL PROTECTED]>, "sathiya psql"
<[EMAIL PROTECTED]> wrote:
> any documents or URL to do the optimizations of the postgres
http://www.postgresql.org/docs/8.3/interactive/performance-tips.html
http://www.postgresql.org/docs/8.3/interactive
>>> On Thu, Mar 6, 2008 at 10:20 AM, in message
<[EMAIL PROTECTED]>, "Marc Fromm"
<[EMAIL PROTECTED]> wrote:
> And both are the same thing?
According to the documentation, postmaster is a deprecated alias for the
postgres executable.
http://www.postgresql.org/docs/8.2/interactive/app-postma
>>> On Thu, Apr 17, 2008 at 3:21 PM, in message <[EMAIL PROTECTED]>,
David Jorjoliani <[EMAIL PROTECTED]> wrote:
> I have daily cron jobs for database update, which where working fine on
> Fedore Core 6. No I move it on Ubuntu Server 7.10 and postgres gives error:
>
> "unexpected EOF on client
>>> <[EMAIL PROTECTED]> wrote:
> listen_addresses = 'localhost,marlon,loaner-mikec'
> # what IP address(es) to listen on;
> # comma-separated list of addresses;
> # defaults to 'localhost', '*' = all
> # (change requires restart)
You probably want this set to '*'.
It is n
>>> Carol Walter <[EMAIL PROTECTED]> wrote:
> On May 23, 2008, at 2:39 PM, Joshua D. Drake wrote:
>>
>> pg_ctl -D /path/to/data/dir -m fast stop
>>
> Does this do an orderly, safe stop? Also do I then bring it back up
> with the usual command?
"Three different shutdown methods can be selected
>>> On Mon, Jun 2, 2008 at 1:52 PM, in message
<[EMAIL PROTECTED]>,
"Hyatt,
Gordon" <[EMAIL PROTECTED]> wrote:
> does anyone know if there are any internal
> UUID generation functions in pg? I took a quick look at the 8.2
docs
> and didn't find anything related.
Any chance of going to 8.3?
h
Has anyone dealt with the issue of using tsearch2 with statute cites
yet? Do you have a sample dictionary or any tips? We need to confirm
with the users, but I think desired behavior is that a statute cite of
'813.12(1)(am)' should be found on any leading portions -- that is,
any of the following
>>> On Thu, Jun 5, 2008 at 5:18 PM, in message
<[EMAIL PROTECTED]>, "Scott
Marlowe"
<[EMAIL PROTECTED]> wrote:
> On Thu, Jun 5, 2008 at 9:19 AM, Alvaro Herrera
> <[EMAIL PROTECTED]> wrote:
>> Marcin Kasperski wrote:
>>>
>>> As in the title - is it possible to convert WAL for another
architecture?
>>> "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> Andreas Philipp <[EMAIL PROTECTED]>
wrote:
>> We are wondering about the advisability to distribute the databases
between
>> the two server machines, both machines acting as active production
systems
>> for one application each, and as warm standb
>>> On Fri, Jun 13, 2008 at 11:06 AM, in message
<[EMAIL PROTECTED]>, "Rafael
Domiciano" <[EMAIL PROTECTED]> wrote:
> So, there is no manner to define that the user can't do create or
drop
> objects, but can create temp tables?
What we normally do is something like this.
create user dbowner pa
>>> On Thu, Jun 19, 2008 at 6:31 PM, in message
<[EMAIL PROTECTED]>,
"Bhella
Paramjeet-PFCW67" <[EMAIL PROTECTED]> wrote:
> we need to monitor the standby database to
> check that it is up, it is getting synced every 10 minutes, and that
it
> is not out of sync with primary database. What would
>>> "kartik" <[EMAIL PROTECTED]> wrote:
> can anyone please tell me how to configure it .. and I have few
windows
> clients that needs to be connected to the database server.. can
anyone
> please tell me something about how to configure the server and the
client
The PostgreSQL documentation is
>>> Naomi Walker <[EMAIL PROTECTED]> wrote:
> Is there some way with a SQL state to interrogate a text field, and
> replace characters.
>
> For example, we would like all "|"'s to be changed to something else,
on
> a regular basis...
It sounds like you might want to look at the regexp_replace
>>> Karen Stone <[EMAIL PROTECTED]> wrote:
>>> Is there some way with a SQL state to interrogate a text field, and
>>> replace characters.
>>>
>>> For example, we would like all "|"'s to be changed to something
else,
>>> on
>>> a regular basis...
>>
>> It sounds like you might want to look at
>>> Dev <[EMAIL PROTECTED]> wrote:
> I have a single Postgres server which will be hosting
multiple
> databases belonging to different users. What would be the
recommendation to
> limit the size of each of the databases?
Have you considered running a different cluster for each user?
E
>>> Dev <[EMAIL PROTECTED]> wrote:
> --- On Thu, 7/3/08, Kevin Grittner <[EMAIL PROTECTED]>
wrote:
>> Have you considered running a different cluster for each user?
> Doesn't it get difficult to manage so many instances of servers ?
We haven't found
>>> Carol Walter <[EMAIL PROTECTED]> wrote:
> I'm trying to drop a database and I'm getting an error that says that
> the database is being accessed by other users. Is there a way I can
> find out who these users are or if there really is a user accessing
it?
select * from pg_stat_activity
>>> Bricklen Anderson <[EMAIL PROTECTED]> wrote:
>> Is there a command to disconnect this user?
>
> select pg_cancel_backend();
I thought that just canceled the currently active statement (if any).
Don't you need to use pg_ctl kill (or the OS kill command) to actually
close the connection?
>>> "Michael Nacos" <[EMAIL PROTECTED]> wrote:
> what if you actually want to look at the data? I have been
> thinking about row checksums, would you say this would be a
reasonable way
> of verifying two databases are equivalent?
Our home-grown replication technique does synchronization checks
d
>>> "Campbell, Lance" <[EMAIL PROTECTED]> wrote:
> PostgreSQL: 8.2
> I am about to change my backup and failover procedure from dumping a
full
> file SQL dump of our data every so many minutes
You're currently running pg_dump every so many minutes?
> to using WAL files.
Be sure you have rea
>>> "Campbell, Lance" <[EMAIL PROTECTED]> wrote:
> I have read this documentation.
> I wanted to check if there was some type of timestamp
My previous email omitted the URL I meant to paste:
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html#RECOVERY-CONFIG-SETTINGS
>>> "Campbell, Lance" <[EMAIL PROTECTED]> wrote:
> What happens if you take an SQL snapshot of a database while
> creating WAL archives then later restore from that SQL snapshot and
> apply those WAL files?
What do you mean by "an SQL snapshot of a database"? WAL files only
come into play for
>>> "Scott Whitney" <[EMAIL PROTECTED]> wrote:
> I just want to stop connections to this
> one particular database.
>
> Is there a simple, preferred method for doing so?
It sounds like pg_hba.conf might be your ticket:
http://www.postgresql.org/docs/8.2/interactive/auth-pg-hba-conf.html
-
>>> "Gibson Chimhamhiwa" <[EMAIL PROTECTED]> wrote:
> I have a simple table below and I want to be able to traverse it
using SQL.
> Can somebody please advise me how I can do this in postgreSQL.
>
> CREATE TABLE grouping
SELECT * FROM grouping;
If that isn't what you're looking for, we need
>>> Kesavan <[EMAIL PROTECTED]> wrote:
> In specific, can Postgres handle 1000 concurrent queries?
It can.
> We are using normal Pentium Quad core processor, 3GHZ system with 2GB
> RAM as Database Server.
With four processors, depending on your drive array configuration, you
are likely to
>>> Shashwat_Nigam <[EMAIL PROTECTED]> wrote:
> Now what I want is to set privilege that whenever the user log in as
Us
> he can only see database Y, none other than that. The user Us could
have all
> rights for database Y but can't go for any other database (X or Z).
The first thing you ne
>>> dkeeney <[EMAIL PROTECTED]> wrote:
> Is there a way to non-reversibly shed privilige within a PostgreSQL
> session?
> I would like the role
> change to persist through the life of the session, without the
option
> of restoring the superuser role.
We could use this in certain circumstance
I started with this issue on the pgsql-jdbc list, but was assured that this
could not be a bug in the JDBC driver -- it is either a bug in the
configuration or runtime environment or it is a server-side bug. This list
seemed like the logical next step.
We have seen this behavior in 8.0.3 with
t set to
"unlimited" were pipe size and open files. Is there any chance that the
error/rollback path in the code is leaking open files on the server? Is there
anything I should run during the test to watch for potential resource
exhaustion?
-Kevin
>>> Tom Lane <[E
gt;> Tom Lane <[EMAIL PROTECTED]> 09/12/05 5:39 PM >>>
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> org.postgresql.util.PSQLException: ERROR: canceling query due to user request
The only possible trigger of that message is a SIGINT sent to the backend.
Now the
will allow the problem to show.
I welcome all suggestions on what to try or what to monitor.
-Kevin
>>> Tom Lane <[EMAIL PROTECTED]> 09/13/05 11:31 AM >>>
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> One more thought -- I keep coming back to the fac
it
comes fast enough after the Statement.cancel, it receives the error
which is the subject of this thread.
-Kevin
>>> Tom Lane <[EMAIL PROTECTED]> 09/13/05 1:18 PM >>>
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> I'm having a really hard time
One more thought on the topic -- in the particular case where we hit
this, the Statement did not have any requests active on its connection.
If the driver can determine this, it could return from the cancel method
without doing anything.
-Kevin
>>> Oliver Jowett <[EMAIL PROTECTED]> 09/13/05 6
The previous report was from the same databases -- I'm a consultant
tasked with evaluating the various open source options and making
one of them work with our existing framework. Jeff developed a new
app (which is in beta testing) which is our first use of PostgreSQL
with real production load for
In my previous post I failed to mention that after we stopped the
applications and found that autovacuum remained idle for several
minutes, we restarted postgres before cleaning up the bloat on
the problem table.
Also, the log shows that autovacuum stopped kicking in after
4:43 p.m. on Friday. I
We will use gdb and strace the next time we see this.
I've tried to be specific about which vacuum is running in all cases. If
the posts have been confusing on that issue, I apologize. I'll try to be
clear on this in future posts.
To summarize past events, the case involving the constraint in
>>> "Jim C. Nasby" <[EMAIL PROTECTED]> 10/03/05 4:48 PM >>>
On Mon, Oct 03, 2005 at 04:37:17PM -0500, Kevin Grittner wrote:
> We will use gdb and strace the next time we see this.
>
> I've tried to be specific about which vacuum is running in all c
issue a few minutes ago.
-Kevin
>>> "Kevin Grittner" <[EMAIL PROTECTED]> 10/03/05 5:27 PM >>>
My goal is to avoid vacuum full in production. My understanding is
that it is never necessary if vacuums are done aggressively enough,
but I felt that while we were in
Hello Faeiz,
When setting up our SuSE server, I found this page, and figured that I
should probably comply with the recommendations I found there, even
though we were setting things up "by hand" rather than through an RPM:
http://www.novell.com/coolsolutions/feature/11256.html
We started with th
Since you mentioned multiple backups per day, I thought you
might want to look at the the Point In Time Recovery option, as
well as the pg_dump approach.
http://www.postgresql.org/docs/8.0/interactive/backup.html
>>> Ferindo Middleton Jr <[EMAIL PROTECTED]> >>>
Are there tools available to auto
A programmer ran a query to fix some data against two "identical"
databases -- one on Linux and one on Windows. They are both 8.1.0,
running on dual hyperthreaded Xeons, with data on RAID5. The Linux
update went fine. The Windows attempt give this:
dtr=> UPDATE
dtr-> "DbTranRepository"
dtr
om/webapp/wcs/stores/servlet/ProductDisplay?productId=8741193&langId=-1
-Kevin
>>> Scott Marlowe <[EMAIL PROTECTED]> >>>
On Mon, 2005-11-14 at 17:20, Kevin Grittner wrote:
> running on dual hyperthreaded Xeons, with data on RAID5.
> ERROR: could not read block 6
It appears that the log file is not being written -- I'll start a
separate thread on that issue.
I reran the query. Same error, same relation, different block.
dtr=> UPDATE
dtr-> "DbTranRepository"
dtr-> SET "userId" = UPPER("userId")
dtr-> WHERE (
dtr(> ("userId" <> UPPER("userId")) AND
Could my issue be the same problem as this thread?:
http://archives.postgresql.org/pgsql-bugs/2005-11/msg00114.php
The references to "Invalid Argument" caught my eye. That thread
did start from a very different point, though.
-Kevin
>>> "Kevin Grittner" <[E
I am looking for advice on how best to configure logging from PostgreSQL
when it is run as a Windows service. Under Linux we allow it to log to
'stderr' and we use the pg_ctl -l switch to direct that to a file. This
doesn't seem to be supported under Windows, so I'm looking for "best
practices" a
The table has about 23.3 million rows, of which about 200,000 will
be affected by this update. Run time is about an hour. During the
first run, the table was the target of about 45,000 inserts. This rerun
was done as the only task. A third run (also by itself) gave this:
ERROR: could not read
w)
I'm becoming more convinced that this happens as the UPDATE
runs into rows inserted by itself.
To respond to a concern expressed earllier -- all of our database
servers, including these two, use ECC memory.
-Kevin
>>> "Kevin Grittner" <[EMAIL PROTECTED]> >>&
I got the error log working on Windows (with redirect_stderr). I had
to stop and restart postgres to do so. I ran the query (for the fourth
time), and it completed successfully.
I'm not inclined to believe that changing the redirect_stderr setting
would change this behavior, so I guess that eit
I will patch, build, and run similar updates to try to hit the problem.
Hopefully I can have something to post later today.
-Kevin
>>> Qingqing Zhou <[EMAIL PROTECTED]> >>>
On Tue, 15 Nov 2005, Kevin Grittner wrote:
>
> Is there anything that anyone wants me to
Is there anything you would like me to include in my build for my
test runs, or any steps you would like me to take during the tests?
-Kevin
>>> Tom Lane <[EMAIL PROTECTED]> >>>
As I said before, we
really really need to find out what the Windows-level error code is
--- "Invalid argument" isn'
arg 7)
How should I proceed?
-Kevin
>>> Tom Lane <[EMAIL PROTECTED]> >>>
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> Is there anything you would like me to include in my build for my
> test runs, or any steps you would like me to take during
1 - 100 of 832 matches
Mail list logo
