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
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 [EMAIL PROTECTED] 09/12/05 5:39 PM
Kevin Grittner [EMAIL PROTECTED] writes
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 backend will SIGINT itself if a statement timeout expires, so one
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 fact that when we turn
on logging in the JDBC driver on the client side
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 coming up with theories about the cause
or things to check.
Have you tried strace'ing the backend
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:00
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
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.
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
[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 cases. If
the posts have been confusing on that issue, I apologize. I'll
the 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 beta test mode, it was worthwhile for
me
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 the
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 automate
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- SET
/servlet/ProductDisplay?productId=8741193langId=-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 649847 of relation 1663/16385/16483:
Invalid argument
If you were
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
dtr(
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 [EMAIL PROTECTED]
It appears that the log
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
.
To respond to a concern expressed earllier -- all of our database
servers, including these two, use ECC memory.
-Kevin
Kevin Grittner [EMAIL PROTECTED]
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
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
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 do at this point, to try
to pin down
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't telling
)
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 the tests?
You might want to insert some debugging elog's into mdread
Ran with this change. Didn't take long to hit it.
Let me know if there's anything else I can do.
[2005-11-16 11:59:29.015 ] 4904 dtr dtr 165.219.88.22(60649) LOG:
read failed on relation 1663/16385/1494810: -1 bytes, 1450
[2005-11-16 11:59:29.015 ] 4904 dtr dtr 165.219.88.22(60649) ERROR:
Our DBAs reviewed the Microsoft documentation you referenced,
modified the registry, and rebooted the OS. We've been beating
up on the database without seeing the error so far. We'll keep at
it for a while.
-Kevin
Qingqing Zhou [EMAIL PROTECTED]
On Wed, 16 Nov 2005, Kevin Grittner wrote
1) We run a couple Java applications on the same box to provide
middle tier access. When the box is heavily loaded, I think I've
seen about 80% PostgreSQL, 20% Java load.
2) I checked that no antivirus software was running, and had the
techs pare down the services running on that box to the
Tom Lane [EMAIL PROTECTED]
Kevin Grittner [EMAIL PROTECTED] writes:
None of this seems material, however. It's pretty clear that the
problem was exhaustion of the Windows page pool.
...
If we don't want to tell Windows users to make highly technical
changes to the Windows registry in order
There weren't a large number of connections -- it seemed to be
that the one big update query, by itself, would do this. It seemed
to get through a lot of rows before failing. This table is normally
insert only -- so it would likely be getting most or all of the space
for inserting the updated
A couple clarifications:
There were only a few network sockets open.
I'm told that the eventlog was reviewed for any events which
mgiht be related to the failures before it was cleared. They
found none, so that makes it fairly certain there was no 2020
event.
-Kevin
Kevin Grittner [EMAIL
The Consolidated Court Automation Programs (CCAP) of the Wisconsin Court
System has migrated to PostgreSQL for all of its Circuit Court web
operations. Eight production databases have been converted, six of them
around 180 GB each, holding statewide information replicated real-time
from 72 county
On Tue, Mar 14, 2006 at 2:08 am, in message
[EMAIL PROTECTED], Simon Riggs
[EMAIL PROTECTED] wrote:
On Mon, 2006- 03- 13 at 13:27 - 0600, Kevin Grittner wrote:
Even more important is the fast response we have had when posting
problems to the lists. We have normally had a fix within 24 hours
If you can't easily use the PostgreSQL extension to SQL, but need to
have string literal behavior conform to the ANSI and ISO standards, I
have submitted a patch for the 8.2 TODO item to support this. Since we
needed it in production mode now, the patch I submitted was relative to
the 8.1 stable
On Sat, Mar 25, 2006 at 8:40 pm, in message
[EMAIL PROTECTED],
Tom Lane [EMAIL PROTECTED] wrote:
Jerry Sievers [EMAIL PROTECTED] writes:
At any rate; I'm wondering what possible causes might be
responsible
for pg_stat_activity's underlying functions to lose track of the
valid
process list?
On Mon, Apr 3, 2006 at 11:52 am, in message
[EMAIL PROTECTED],
Tom Lane [EMAIL PROTECTED] wrote:
Kevin Grittner [EMAIL PROTECTED] writes:
Is there any way to tweak this in favor of more accurate
information,
even if has a performance cost? We're finding that during normal
operations we're
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 is built under a temporary name; then the
previous
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 logfile.
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 controller
didn't persist dirty pages in the June 14th failure
That's
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 due to startup
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 design of the
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
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 county. We are required to keep
a backup in each county
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...
That's true for the WAL files. The base backups are another story. We will
normally
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 helpful, though, since it just gets you to the
Netware console
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 timestamp along
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_MAGIC;
I was
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 how I
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.
Did you
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 admin user
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 proddb |
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 curiosity,
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?
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 on the stand-in box?
(1) Restore the latest base backup
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 send this
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 gotten fancy
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. Lines in
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 will
listen
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 restart, not
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. But, the
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 PROTECTED]
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 has completed the
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
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 function
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
PostgreSQL
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
in 31511 pages
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.
Is
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 kit that
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 work correctly after
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.1.4
You
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 memory.
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 (what conf
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
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-postmaster.html
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 connection
[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 not the
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?
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
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?
(source database
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 standby servers for
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 password
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 be the
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 function:
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 the regexp_replace
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?
Each
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 it to be so. xargs is your friend, fed by find or
cat
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 where
Bricklen Anderson [EMAIL PROTECTED] wrote:
Is there a command to disconnect this user?
select pg_cancel_backend(procpid of connection);
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
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
during
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 read (and
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
-Kevin
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 backup
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
-Kevin
--
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 more
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 get
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 need to
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 circumstances. How
c k [EMAIL PROTECTED] wrote:
Does PG uses multiple processors/cores if available by default on
various
OSes?
A separate process is created to handle each connection. You don't
get much benefit from multiple processors if only one connection at a
time is running a query, but in a normal
Napolean Periathambi [EMAIL PROTECTED] wrote:
Is there any ways to include wildcard in pg_hba.conf file to accept
all
postgres clients on the network rather than specifying specific IP
addresses
on this file?
# CIDR-ADDRESS specifies the set of hosts the record matches.
# It is made up
1 - 100 of 775 matches
Mail list logo