fferent 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
or the state of our standbys on an ongoing basis aside
from checking 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
On Tue, Apr 16, 2013 at 3:04 PM, Tom Lane wrote:
> Dale Fukami 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 but \d an
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, A
fe 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
---
I have not done any 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
On 18 June 2010 17:27, Tom Lane wrote:
> Andy Dale 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 a
> &q
On 18 June 2010 17:00, Tom Lane wrote:
> Andy Dale 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
> 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 16:37, Tom Lane wrote:
> Andy Dale writes:
> > On 18 June 2010 16:06, Tom Lane 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 have d
>
>
>
> 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
On 18 June 2010 16:06, Tom Lane wrote:
> Andy Dale 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 tha
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
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:
>
>> Sor
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
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
Subjec
he Entity table 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) wi
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
cript and the WHERE clause selects an
unique record. Therefore only 1 value should ever be returned. The point
is that I don't even get that far as the script fails to compile due to the
INTO clause.
Regards,
Dale.
-Original Message-
From: Klint Gore [mailto:[EMAIL
e 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;
tamp(), "ModifiedBy" = UserID() WHERE ("RelationID" =
inRelationID) 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 statem
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.
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.
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 su
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
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 re
RNING value into a
variable to use immediately. Does anyone have a solution?
Dale.
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 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]>
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
kerne
more 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
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
> - sequo
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
#vacuu
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 -d mydatabase -c ""insert into mytable (aaa,bbb) values
('xxx', 'yyy');"
Cheers,
Andy
On 23/07/07, Chuck Payne <[EMAIL P
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 ('r',
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'
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. or OLD. 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 i think is
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
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 b
Hi,
Have tried putting the JDBC driver in $JBOSS_HOME/server//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 8.2.3. I pla
crements 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 wrote:
Andy Dale wrote:
> Hi,
>
> I
erious effect 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 ma
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
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 xact_co
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,
. 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
01/07, Bruno Wolff III <[EMAIL 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 dat
wrote:
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 w
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 is
nux HA 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 D
her as well Uni-Cluster
(http://www.continuent.com/index.php?option=com_content&task=view&id=213&Itemid=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:
>
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
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
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 w
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 AS SEL
uglas 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 f
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 whe
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)---
TI
R UPDATE ON actions
FOR EACH ROW EXECUTE PROCEDURE 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
---(
FOR EACH ROW EXECUTE PROCEDURE validate_actions_insert();
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 b
ess bool DEFAULT 'f'
);
CREATE TABLE 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
to have many
choices_category tables?
Thanks,
Dale
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
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
ly wrong. 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
Mike,
Perhaps you could just insert the url into the record and then
use a string function to return "url"+"id" when needed. This would
eliminate the extra insert and save space in the row.
Dale
> -Original Message-
> From: [EMAIL PROTECTED
r can functions return record sets??
Thanks in Advance,
Dale.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
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 i
story
(to_char(timestamp(h.time_stamp),'-MM')) ]
2. what is the best way to access the data from the history table for a
known period..
eg. knowing period='2001-04' is there a better function to use than
'to_char' a
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+ should show you the table schema with comments.
If you're looking for the actual data, it's in pg_description. The
objoid
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)
ed to in on of
the responses, but it didn't click.
Therefore, there would be little practical benefit??
I'll try a long series of insert/select/updates and compare.
--
Dale Walker [EMAIL PROTECTED]
Independent Computer Retailers (ICR)
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]
Indep
2>&1] to send any unwanted output
to /dev/null
>
> Why is everyone else's script working without the -l and mine wasn't?
>
'-l' uses the login profile for the su'd user... this is similar to a
'simuated login', without it , it was only referenci
u sec.
---
--
Dale Walker [EMAIL PROTECTED]
Independent Computer Retailers (ICR) http://www.icr.com.au
ICRnet
want it in all future databases,
> I believe if you add it to template1, all later dbs have it
> enabled)
got it.
and guess what the sample function worked!
Thanks for that..
--
Dale Walker [EMAIL PROTECTED]
I
ning PostgreSQL 7.0.2 on FreeBSD-4.1. I'm new 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 do
7;select :fieldnames
from logtmp'
When I actually use this in the production environment, 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
'CCYY-MM-DD'.
most queries will be of the form:
select from where username='xxx' and date<'CCYY-MM-DD'
and date>'CCYY-MM-DD'
so I was thinking
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
'));
INSERT 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:
d a C 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.
84 matches
Mail list logo
