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
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
39 matches
Mail list logo