date:20090827

Re: [GENERAL] [Skytools-users] WAL Shipping + checkpoint

2009-08-27 Thread Sébastien Lardière


On 27/08/2009 00:18, Mark Kirkwood wrote:

Sébastien Lardière wrote:

On 26/08/2009 04:46, Mark Kirkwood wrote:

Sébastien Lardière wrote:

Hi All,

I've a cluster ( Pg 8.3.7 ) with WAL Shipping, and a few hours ago, 
the master had to restart.


I use walmgr from Skytools, which works very well.

I have already restart the master without any problem, but today, 
the slave doesn't work like I want. The field Time of latest 
checkpoint from the pg_controldata on the slave keep the same 
values, but WAL File are processed correctly.


I try to restart the slave, but, after processed again all the WAL 
between Time of latest checkpoint and, it does nothing else, 
latest checkpoint stay at the same value.


I don't know if it's important ( i think so ), and I can't fix it.

It is normal for it to lag behind somewhat on the slave (depending 
on what your checkpoint timeout etc settings are).


However, I've noticed what you are seeing as well - particularly 
when there are no actual data changes coming through in the logs - 
the slave checkpoint time does not change even tho there have been 
checkpoints on the master (I may have a look in the code to see what 
the story really is...if I have time).




Yes, but the delay between the last checkpoint on the master and the 
slave is very high, now ( 100 000 sec ), because the last checkpoint 
on the slave was yesterday ( as far as pg_controldata is right )


Here a graph from our munin plugin : 
http://seb.ouvaton.org/tmp/bdd-pg_walmgr-week.png


The blue line represent an average between two WAL processed on the 
slave, and the green line, the delai between last checkpoint on the 
master and the slave.


Maybe it's not some good indicator, but the green line let me think 
there is problem.



Do you have archive_timeout set? If so, then what *could* be happening 
is this:


There are actually no real data changes being made on your master 
for some reason. So every time archive_timeout is reached a log full 
of no changes is shipped to your slave and applied - and no checkpoint 
times are changed for reasons I mentioned above.





thanks, but we have not set archive_timeout, and we have a lot of real 
data changes.


That's why i don't understand why checkpoint never happen on the slave.

--
Sébastien Lardière



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Viable alternatives to SQL?

2009-08-27 Thread Kelly Jones

Many sites let you search databases of information, but the search
queries are very limited.

I'm creating a site that'll allow arbitrary SQL queries to my data (I
realize I'll need to handle injection attacks).

Are there other viable ways to query data? I read a little on
Business System 12 (BS12), Tutorial D, and even something called
T-SQL (I think), but they all seem theoretical and not fully
implemented.

I want a query language that non-techies can use easily, but also
supports arbitrarily complex queries. Does such a language exist?

-- 
We're just a Bunch Of Regular Guys, a collective group that's trying
to understand and assimilate technology. We feel that resistance to
new ideas and technology is unwise and ultimately futile.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Viable alternatives to SQL?

2009-08-27 Thread Martin Gainty

Hibernate is a ORM technology which configures bean classes which will
construct DB statements based on the method(create,replace,update,delete) from
the bean class attributes(columns)

to quote
Hibernate allows you to express queries in its own portable SQL
extension (HQL), as well as in native SQL, or with an object-oriented
Criteria and Example API.

Hibernate currently supports the following databases
Microsoft SQL Server 2005/2000OracleMicrosoft AccessFirebirdPostgreSQLDB2
UDBMySQLSQLite
https://www.hibernate.org/

Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez
l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est
interdite. Ce message sert à l'information seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.

Date: Thu, 27 Aug 2009 06:43:51 -0700
Subject: [GENERAL] Viable alternatives to SQL?
From: kelly.terry.jo...@gmail.com
To: pgsql-general@postgresql.org

Many sites let you search databases of information, but the search
queries are very limited.

I'm creating a site that'll allow arbitrary SQL queries to my data (I
realize I'll need to handle injection attacks).

Are there other viable ways to query data? I read a little on
Business System 12 (BS12), Tutorial D, and even something called
T-SQL (I think), but they all seem theoretical and not fully
implemented.

I want a query language that non-techies can use easily, but also
supports arbitrarily complex queries. Does such a language exist?

--
We're just a Bunch Of Regular Guys, a collective group that's trying
to understand and assimilate technology. We feel that resistance to
new ideas and technology is unwise and ultimately futile.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

_
Windows Live: Keep your friends up to date with what you do online.
http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_online:082009

47 matches

Mail list logo