nt from the postgres user I created.
Any help will be greatly appreciated.
Dale
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Apr 16, 2013 at 3:04 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Dale Fukami dale.fuk...@gmail.com writes:
I'm having a problem on a standby server (streaming replication) where a
table seems to exist but is not queryable. Essentially a select statement
(and drop/insert/etc) fails
pg_last_xlog_receive_location, etc. I realize it's no small
task but thought maybe there was something I had missed.
In the end, I think this just helps nudge our upgrade along :)
Thanks for all the help!
Dale
but, in this case, replication
continued to run but the standby is essentially unusable as a failover
option since this table is not available. Is there some other way to be
certain that a standby server is consistent with master?
Thanks,
Dale
psql session output
live=# set
Tried the select with the quotes around each of the schema and table and I
get the same result (someschema.tracked_deductibles). I'm pretty
certain they're both lowercase. Would the select from pg_tables show if
they were mixed case by accident?
Dale
On Tue, Apr 16, 2013 at 2:38 PM, John R
searches of the various lists archives yet for a
possible solution.
Dale.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
We currently have a DB (8.3.7) in production that seem to be taking up more
space on the HDD than was anticipated.
After looking into the the data directory a particular file/oid is around 21
GB (the oid has 21 files), this OID can then be found in the pg_class table,
the explanation for the
On 18 June 2010 16:06, Tom Lane t...@sss.pgh.pa.us wrote:
Andy Dale andy.d...@gmail.com writes:
After looking into the the data directory a particular file/oid is around
21
GB (the oid has 21 files), this OID can then be found in the pg_class
table,
the explanation for the size being
Try:
SELECT oid,* from pg_database ;
I suspect the relfilnode you are looking at is another database in the
cluster.
--
Adrian Klaver
adrian.kla...@gmail.com
Maybe I am possibly doing that. I did a du -h --max-depth=1 in the base/
within the data directory. This showed a single
On 18 June 2010 16:37, Tom Lane t...@sss.pgh.pa.us wrote:
Andy Dale andy.d...@gmail.com writes:
On 18 June 2010 16:06, Tom Lane t...@sss.pgh.pa.us wrote:
You should be looking at pg_class.relfilenode, not OID. See
http://www.postgresql.org/docs/8.3/static/storage.html
Ok, but when I
To the best of my knowledge we have not had any DB crashes as yet. I am
also replicating the DB using slony, could this be the cause of these weird
orphans ? (it is neither of the sl_log_ tables)
Also looking at the timestamps of the files, they all seem to have been
created within a very
On 18 June 2010 17:00, Tom Lane t...@sss.pgh.pa.us wrote:
Andy Dale andy.d...@gmail.com writes:
Try:
SELECT oid,* from pg_database ;
I suspect the relfilnode you are looking at is another database in the
cluster.
Maybe I am possibly doing that.
There isn't any maybe involved here
On 18 June 2010 17:27, Tom Lane t...@sss.pgh.pa.us wrote:
Andy Dale andy.d...@gmail.com writes:
OK, I have just run the query, and both are in the same database.
OK. Given the narrow range of timestamps on the files, the most
likely bet here is that you're looking at the leftovers from
Hi,
I would consider telling Hibernate to log the SQL it is generating to a
file. This can be done by setting the logging category org.hibernate.SQL to
debug, and for the parameters used in the prepared statements I think you
must also enable org.hibernate.type on debug (I have not managed to get
Have a look under the following URL:
http://yum.pgsqlrpms.org/rpmchart.php
You should be able to download the latest 8.4 Devel version in rpm format.
Cheers,
Andy
2008/10/8 Grzegorz Jaśkiewicz [EMAIL PROTECTED]
On Wed, Oct 8, 2008 at 12:27 PM, admin [EMAIL PROTECTED] wrote:
Sorry if
Hi Tom,
The trigger trAccountUpdate got called, but why didn't the trigger
trEntityUpdate get called?
Regards,
Dale Harris.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, 22 September 2008 22:22
To: Dale Harris
Cc: pgsql-general@postgresql.org
Subject: Re
row
that appears there, even rows added via a child table. It would mean that
any new table that inherits the parent table, in my case Entity, would
automatically have the global trigger I want enforced. Nice enhancement :)
Regards,
Dale Harris.
-Original Message-
From: Tom Lane [mailto
execute? (Row was
initially added via the Account table.)
Dale.
CREATE TABLE Entity
(
ID bigserial NOT NULL,
Code character varying(20) NOT NULL,
Name character varying(50) NOT NULL,
Modified timestamp(1) with time zone NOT NULL DEFAULT
session_timestamp(),
ModifiedBy bigint
On Aug 20, 3:02 pm, [EMAIL PROTECTED] (Scott Marlowe) wrote:
On Tue, Aug 19, 2008 at 9:51 PM, Dale Harris [EMAIL PROTECTED] wrote:
As per the original message:
UPDATE EntityRelation SET Status = inStatus, Modified =
Session_TimeStamp(), ModifiedBy = UserID() WHERE (RelationID
On Aug 18, 9:23 pm, Lew [EMAIL PROTECTED] wrote:
Dale wrote:
Hi,
I've got some code which postgres 8.3.3 won't accept. Postgres
doesn't like the INTO clause on RETURNING INTO and I've tried
following the documentation.
UPDATE EntityRelation SET Status = inStatus, Modified
) AND (EntityID = inEnityID) AND IsEqual(inRelatedID,
RelatedID) RETURNING Default INTO oldDefault;
Does anyone have any ideas if the INTO clause actually works at all
for an UPDATE statement?
Regards,
Dale.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
the information, but I would have thought it would
be a lot more efficient to return the value during the UPDATE.
Regards,
Dale.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Wednesday, 20 August 2008 1:30
To: Alvaro Herrera
Cc: Bill Moran; Dale
that far as the script fails to compile due to the
INTO clause.
Regards,
Dale.
-Original Message-
From: Klint Gore [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 20 August 2008 12:47
To: Dale Harris
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] can't get UPDATE
Hi,
When ever I try and call the PERFORM statement I get:
ERROR: syntax error at or near PERFORM
even when I try executing something basic: PERFORM (2 + 3);
Any ideas please?
Dale.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
On Aug 15, 2:14 pm, Dale [EMAIL PROTECTED] wrote:
Hi,
When ever I try and call the PERFORM statement I get:
ERROR: syntax error at or near PERFORM
even when I try executing something basic: PERFORM (2 + 3);
Any ideas please?
Dale.
I found my problem. Unfortunately PERFORM can only
value into a
variable to use immediately. Does anyone have a solution?
Dale.
I've found my solution as in the help file under RETURNING INTO. It would
be nice if this was referenced on the INSERT documentation.
Dale
From: [EMAIL PROTECTED]
Sent: Thursday, 14 August 2008 15:32
To: pgsql-general@postgresql.org
Subject: [GENERAL] cannot use result of (insert
Hi Pavel,
Thank you for your reply, but in this case the “INSERT INTO ... RETURNING
field,... INTO STRICT variable,...;” is what works best for me currently.
Regards,
Dale Harris
-Original Message-
From: Pavel Stehule [mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 August
Hi,
I currently have max_connections set to 300, however if i think about it we
will never have that many connections (more like 50 - 100 at most).
Cheers,
Andy
2008/5/20 Scott Marlowe [EMAIL PROTECTED]:
On Tue, May 20, 2008 at 8:14 AM, Andy Dale [EMAIL PROTECTED] wrote:
Hi,
I am
with this setting.
Cheers,
Andy
2008/5/21 Scott Marlowe [EMAIL PROTECTED]:
Then you should set it to 100 or so. It helps to keep the number of
connections down to something reasonable.
On Wed, May 21, 2008 at 12:06 AM, Andy Dale [EMAIL PROTECTED] wrote:
Hi,
I currently have max_connections set
Hi,
I am currently trying to tweak Postgresql 8.1, to improve the overall
performance of the database. I have read over the following page/artical
http://www.powerpostgresql.com/PerfList/, however at the moment (not for
much longer hopefully) my hands aree tied when it comes to altering the
Hi,
You might also want to check out HA-JDBC at http://ha-jdbc.sourceforge.net
Cheers,
Andy
On 02/08/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
i would like to use a statement replication for postgresql
i have found the following solutions:
- pgpool
- pgpool2
- sequoia (jdbc,
heavyweight
than ha-jdbc), and i never quite managed to get it working exactly as i
wanted it to.
Cheers,
Andy
On 02/08/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Am Donnerstag, 2. August 2007 12:04 schrieb Andy Dale:
Hi,
You might also want to check out HA-JDBC at
http://ha
Hi,
I am working with a 3 Postgresql databases, 1 is configured with autovaccum
enabled with the following settings:
vacuum_cost_delay = 200 # 0-1000 milliseconds
vacuum_cost_page_hit = 6# 0-1 credits
#vacuum_cost_page_miss = 10 # 0-1 credits
Hi Chuck,
I am no expert but this should definitely be possible with postgres.
The posgres command in the loop should look like so (not sure about the
password):
psql -U user -d mydatabase -c insert into mytable (aaa,bbb) values
('xxx', 'yyy');
Cheers,
Andy
On 23/07/07, Chuck Payne [EMAIL
In this query:
select n.nspname as table_schema, c.relname as table_name,
a.attname as column_name
from pg_catalog.pg_attribute a
join pg_catalog.pg_class c on ( a.attrelid = c.oid)
join pg_catalog.pg_namespace n on (c.relnamespace = n.oid)
where c.relkind in
Hi,
I wanted to setup a simple generic type trigger. What a mean by generic
is that i don't want to hardcode the
NEW.column or OLD.column calls, i searched for a way to loop over
the NEW/OLD rowtypes but could not figure out how it should be done.
This led me to attempt to do it in a way which
Thanks for the quick response, i think will try it with python or perl.
Cheers,
Andy
On 24/04/07, Richard Huxton [EMAIL PROTECTED] wrote:
Andy Dale wrote:
Hi,
I wanted to setup a simple generic type trigger. What a mean by
generic
is that i don't want to hardcode the
NEW.column
Hi,
I have installed xml2 contrib to my postgreSQL 8.1.4 install. The
functionality it offer when working with xml files is really good, but i
currently experiencing a few issues with the xpath_list function and a
simple test.
I took a simple xml file (the one described in the PostgreSQL book
Hi,
Unfortunately the suggestion by Geogre did not work, but i solved it like
so:
SELECT film_name FROM filminfo
WHERE '1973' = ANY (STRING_TO_ARRAY((xpath_list(description, 'year')),','))
Thanks,
Andy
On 22/03/07, George Weaver [EMAIL PROTECTED] wrote:
Original Message From Andy Dale
Hi,
Have tried putting the JDBC driver in $JBOSS_HOME/server/server
config/lib, that is where the I always put jdbc drivers (The default
Hypersonic driver is also in this directory).
Cheers,
Andy
On 28/02/07, Andrew Madu [EMAIL PROTECTED] wrote:
Hi,
i've just upgraded from posgreSQL 8.1 to
on the performance ?
Cheers,
Andy
On 10/01/07, Scott Marlowe [EMAIL PROTECTED] wrote:
On Wed, 2007-01-10 at 12:37, Andy Dale wrote:
Hi Brad,
If i have to create a separate slony replication set, then i cannot do
it this way (i cannot and do not want to have a master-slave(s)
architecture)
Andy
On 10/01
a counter (value in a separate table) after an
insert/update/delete and then add this trigger to each table i want to
record the stats for. Would this new approach work (i.e. be lossless) ?
Cheers,
Andy
On 11/01/07, Richard Huxton dev@archonet.com wrote:
Andy Dale wrote:
Hi,
I turned
Hi Erik,
Can you elaborate a bit more on what you mean by pg_class, as looking at it
i cannot figure out how to get the last write time from the pg_class table.
Cheers,
Andy
On 08/01/07, Erik Jones [EMAIL PROTECTED] wrote:
Scott Marlowe wrote:
On Mon, 2007-01-08 at 03:26, Andy Dale wrote
Hello,
I need to be able to keep track of the number of transactions (the ones that
are committed) that i am interested in, which in my case is all insert,
update, and deletes performed on tables in the public schema. I have
already tried to select xact_commit from pg_stat_database but
Hi Brad,
If i have to create a separate slony replication set, then i cannot do it
this way (i cannot and do not want to have a master-slave(s) architecture)
Andy
On 10/01/07, Brad Nicholson [EMAIL PROTECTED] wrote:
On Wed, 2007-01-10 at 16:51 +0100, Andy Dale wrote:
If anyone can help
:
On Thu, 2007-01-04 at 11:11, Andy Dale wrote:
Hi,
I need to be able to determine the last time (and date) that a
database was written to. I know it could be possible just to check
the last modified dates in the PGDATA directory, but i need to compare
the last write time of 3 databases
PROTECTED] wrote:
On Mon, Jan 08, 2007 at 09:22:05 +0100,
Andy Dale [EMAIL PROTECTED] wrote:
Hi,
Sorry for the slight delay in my response.
I am using 3 PostgreSQL databases and writing to them using an SQL
proxy.
These databases have a high write volume. On rebooting all 3 servers
for
OS
. So HA-JDBC
(i) just need the last write time of the database on a whole, as this will
hopefully mean it is the most up to date.
Andy
On 08/01/07, Scott Marlowe [EMAIL PROTECTED] wrote:
On Mon, 2007-01-08 at 03:26, Andy Dale wrote:
Ok.
The SQL Proxy i am using (HA-JDBC) has some limitations
Hi,
I need to be able to determine the last time (and date) that a database was
written to. I know it could be possible just to check the last modified
dates in the PGDATA directory, but i need to compare the last write time of
3 databases (connecting via JDBC). Hopefully the last write date
Hi,
I have just read the statement that Postgres does have (with end user
assembly) multi-master replication system. Is this just PGCluster or
something else ? if it is not PGCluster, then how can this be achieved ?
Cheers,
Andy
On 24/12/06, Shoaib Mir [EMAIL PROTECTED] wrote:
I guess the
as well.
Andy
On 26/12/06, Shoaib Mir [EMAIL PROTECTED] wrote:
pgpool-II might help you there too I guess...
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/26/06, Andy Dale [EMAIL PROTECTED] wrote:
Hi,
I have just read the statement that Postgres does have (with end
Uni-Cluster
(http://www.continuent.com/index.php?option=com_contenttask=viewid=213Itemid=170
), haven't tried yet but it might help you there...
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/26/06, Andy Dale [EMAIL PROTECTED] wrote:
The issue i had with pgpool (1 or 2
in
combination.
For going on a vertical solution you can try OpenSSI and see if that can
work for you, haven't tried that myself but will like to hear about
PostgreSQL configuration with OpenSSI
---
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)
On 12/26/06, Andy Dale [EMAIL
Hi,I am currently trying to debug an issue we are experiencing and i have turned the server logging onto debug level 5 and filtering out the LOG messages, i still need some advice on how to interpret them. I an extract from the log is:
2006-08-03 09:37:21.643 CEST LOG: statement: PREPARE unnamed
I have tried messing with the logging settings in postgres.conf but it always displays $1, i have set every level to debug 5 and logging all statements, but i still have had no success.Andy
On 8/3/06, Thomas F. O'Connell [EMAIL PROTECTED] wrote:
On Aug 3, 2006, at 8:33 AM, Andy Dale wrote: I am
McNaught [EMAIL PROTECTED] wrote:
Andy Dale [EMAIL PROTECTED] writes: The current problem we seem to have is that the data is persisted ok (or at least it seems to be in there with pgadmin), but cannot be
read back out of the database all the time (in fact for about 90% of the time), the current
Hi,We currently have an JBoss web application that persists a byte array it recieves (Using the EJB persistence API), and then tries to read it from the Database again from further parsing. The application works really well with the default Hypersonic datasource, but it will not work correctly
Devrim GUNDUZ wrote:
rpmbuild --rebuild --target i686 ...src.rpm
will work.
src rpm link below
ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/binary/v8.0.2/linux/srpms/fedora/fedora-core-3/postgresql-8.0.2-1PGDG.src.rpm
---(end of broadcast)---
();
You may need create another trigger for table user_data before update
for reverse validation.
Bruno and Yudie,
Thanks for the replies. I will read up on triggers and give that a try.
Thanks,
Dale
---(end of broadcast)---
TIP 2: you can get
validate_actions_insert();
Yugi,
I made a few minor modifications as shown above and the trigger
function works great. I think I'll also use triggers to keep a history
of record changes for auditing.
Thanks,
Dale
---(end of broadcast)---
TIP 9
actions(
action varchar(32),
user varchar(32) -- somehow make sure user = user_data.name where
user_data.write_access = 't'
);
Thanks,
Dale
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
choices_category tables?
Thanks,
Dale
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
and in the
description of CREATE TABLE but could not find naming restriction info.
Could someone point me in the right direction?
Thanks,
Dale
---(end of broadcast)---
TIP 8: explain analyze is your friend
. Is checking text length considered a good idea? If so,
what would be a reasonable limit? I was thinking about 10 *
average_field_char_length (if avg value is 16 char, set limit to 160
char). Thanks in advance for your opinions.
Thanks,
Dale
---(end of broadcast
functions return record sets??
Thanks in Advance,
Dale.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
/common-sense sort of step, but now I'm running out of time to
spend on it
Has anyone here done anything similar??
--
Dale Walker [EMAIL PROTECTED]
Independent Computer Retailers (ICR) Pty Ltd
http://www.icr.com.au/
---(end of broadcast)---
TIP 4
Tom Lane wrote:
Dale Walker [EMAIL PROTECTED] writes:
I use the 'hash' type as queries regarding usage will always be of the
form select .. where username='xxx';
Use a btree anyway. Postgres' btree implementation is much better than
its hash index implementation.
OK, I'll give
24947, but the relpages count is only 1
(after a vacuum analyze, and with block size of 8k). Is the relpages counts under 7.1
no longer valid of the physical page storage??? and what would the correct way be to
calculate this under 7.1 beta 1
Thanks in Advance,
Dale.
That is exactly what I was looking for. Thanks a lot.
Dale.
"Joel Burton" [EMAIL PROTECTED] 11/30/00 01:29PM
\d+ tablename should show you the table schema with comments.
If you're looking for the actual data, it's in pg_description. The
objoid field matches the oid field in pg
Just a quick q.
Does anyone know what effects FreeBSD's 'softupdates' would have
on the /usr/local/pgsql/data filesystem.
Would this help performance, or would it be a shot in the foot??
--
Dale Walker [EMAIL PROTECTED]
Independent Computer
Just received the email on Replication server.
Based on the threads this last week, the sooner it's out there the
better..
Fantastic, yah yah yah!!!
--
Dale Walker [EMAIL PROTECTED]
Independent Computer Retailers (ICR) http
.
---
--
Dale Walker [EMAIL PROTECTED]
Independent Computer Retailers (ICR) http://www.icr.com.au
ICRnet http
asn't?
'-l' uses the login profile for the su'd user... this is similar to a
'simuated login', without it , it was only referencing variables from
your roo profile ... (ie. no PGDATA,etc..)
--
Dale Walker [EMAIL PROTECTED]
Independent Computer Reta
to postgres
(just
migrating from mysql).
What I'm wondering:
1. Am I missing something basic and fundamental here??
2. Am I looking at the right doco.. I recall on the list a
few
weeks
back there was a coment about the wrong doco being used...
Any help is appreciated..
--
Dale
it
enabled)
got it.
and guess what the sample function worked!
Thanks for that..
--
Dale Walker [EMAIL PROTECTED]
Independent Computer Retailers (ICR) http://www.icr.com.au
ICRnet http
, the main table
will have _one_ extra field as a serial sequence (this is why I used the
fieldnames variable, otherwise I have about 20 fields), I thought this
was my problem at first, but when I simplified the data right down, it
still fails.
Any thoughts??
Thanks in Advance.
--
Dale Walker
??
--
Dale Walker [EMAIL PROTECTED]
RT 22825 1
danderso=# select * from test;
time
2000-06-28 00:00:00-05
(1 row)
danderso=#
Thanks,
Dale.
Tom Lane [EMAIL PROTECTED] 06/26/00 05:41PM
"Dale Anderson" [EMAIL PROTECTED] writes:
I noticed that the DateTime fields and the to_timestamp fu
The BitBucket on unix is /DEV/NULL, or the place where things will disappear.
Herbert Liechti [EMAIL PROTECTED] 06/27/00 09:35AM
Thomas Lockhart wrote:
Yeah, it just vanished. Not my fault. The bitbucket ate it.
And what is a bitbucket? My dictioniary knows nothing
about this word. Just
function or system table that has this
information.
Thanks in advance,
Dale.
Is there any way to use table names longer than 32 characters
Dale.
82 matches
Mail list logo
