[GENERAL] [No subject]
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] (no subject)
---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] (no subject)
---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] No subject
Hi, I'm looking for a way to monitor all the queries that are executed by the server and to be able, by using these queries, to reproduce the data in all databases. The idea is to periodicaly (e.g. every two minutes) store the newly executed queries in a sort of wal segment file. I first tried to figure this out by monitoring the data in the wal file that is currently being updated (in the directory .../pg_xlogs). I hoped that it would be blank (filled with zeroes) from the last wal info inserted up to the end of the file. That was not the case. The wal files are recycled and the new wal info is written over the old one. Another possible solution would be to configure the server to 'cycle' through the wal files every X seconds and not when the file is full (default 16MB) but i don't know if such a configuration parameter is available in the server functionality. Finally, I also thought about placing a trigger in every table's update but this is far too complicated and cannot be applied to already functional database applications. Any help appreciated Tsakiridhs Oresths P.S. It is very important that wal-like log files that are generated, in case of execution, will reproduce the database exactly the way it was. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] No subject
Tsakiridis Orestis wrote: Hi, I'm looking for a way to monitor all the queries that are executed by the server and to be able, by using these queries, to reproduce the data in all databases. Beware - query shipping runs into problems with DELETE FROM my_table WHERE ts now() The idea is to periodicaly (e.g. every two minutes) store the newly executed queries in a sort of wal segment file. I first tried to figure this out by monitoring the data in the wal file that is currently being updated (in the directory .../pg_xlogs). I hoped that it would be blank (filled with zeroes) from the last wal info inserted up to the end of the file. That was not the case. The wal files are recycled and the new wal info is written over the old one. If the current PITR isn't good enough for you: http://www.postgresql.org/docs/8.1/static/backup.html Check that the changes in 8.2 beta aren't helpful http://www.postgresql.org/developer/beta Finally, I also thought about placing a trigger in every table's update but this is far too complicated and cannot be applied to already functional database applications. Have you looked at slony? http://gborg.postgresql.org/project/slony1/projdisplay.php The word you want to search on for all this is replication. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL] (no subject)
Hi List;
I've created a plperlu (perl untrusted) function with the ability to use
dbi. I can use the code listing below to return data if I specify the
query as follows:
select * from sybase_get2() as (f1 varchar(100), f2 varchar(100));
However, I have to specify the column names as f1 and f2.
I want to turn this into a generic solution where I can eventually pass in
the SQL. For now I just want to be able to specify any column names I want
in the as part of the above query.
Any Ideas?
Thanks in advance for your help...
### Code Listing Start ###
CREATE OR REPLACE FUNCTION sybase_get2()
RETURNS SETOF record
AS $$
use DBI;
my $dbh = DBI-connect(dbi:Sybase:server=CXS100, 'pguser1', 'pg70093' );
if (!$dbh) {
return;
}
my $qry = $dbh-prepare(select parent_id, Parent_key from
csx1db.dbo.parentkeys);
$qry-execute();
while ( @data = $qry-fetchrow_array() ) {
return_next ({f1=$data[0], f2=$data[1]});
}
return ;
$$ LANGUAGE plperlu
### Code Listing End ###
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] (no subject)
LLC wrote: Hi List; I've created a plperlu (perl untrusted) function with the ability to use dbi. I can use the code listing below to return data if I specify the query as follows: select * from sybase_get2() as (f1 varchar(100), f2 varchar(100)); However, I have to specify the column names as f1 and f2. I want to turn this into a generic solution where I can eventually pass in the SQL. For now I just want to be able to specify any column names I want in the as part of the above query. Any Ideas? Use a type to define the output columns, then you can call the function like this: select * from sybase_get2() not need to us AS See the examples on this page on how to use a type with a plperl function: http://www.commandprompt.com/community/pgdocs81/plperl-database -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] (no subject)
subscribe ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] (no subject)
digest-status LISTNAME ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] (no subject)
set pgsql-general digest ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] (no subject)
remove ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] (no subject)
set nomail ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] (no subject)
have any installation files that combine both postgreSQL and PHP together without the need to configure one by one?
[GENERAL] (no subject)
test
Re: [GENERAL] (no subject)
I'm Your Handiman -Online- wrote: test kewl i'm in..sorry all for the test...:( anywayjust installed postgresSQL 7.0 and everything took fine is this normal? [postgres@localhost postgres]$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data DEBUG: Data Base System is starting up at Mon Jun 12 09:15:35 2000 DEBUG: Data Base System was shut down at Mon Jun 12 09:12:36 2000 DEBUG: Data Base System is in production state at Mon Jun 12 09:15:35 2000 starting/shutting down ? just curious.. iguess now all I need is a good GUIsorry i'm used to using microsoft's access:) obvious newbie statment what can I say...anyway i'm just glad to be headed in the right direction and glad there is a program to convert ( even if alpha stage ) from MDB to postgres..(mdbtools) latre lee-
Re: [GENERAL] (no subject)
On Mon, 12 Jun 2000, I'm Your Handiman -Online- wrote: # test # # kewl i'm in..sorry all for the test...:( # anywayjust installed postgresSQL 7.0 and everything took fine It's OK to just post your question, the test is kinda redundant if you're going to ask a question immediately after, don't you think? # is this normal? # [postgres@localhost postgres]$ /usr/local/pgsql/bin/postmaster -D # /usr/local/pgsql/data # DEBUG: Data Base System is starting up at Mon Jun 12 09:15:35 2000 # DEBUG: Data Base System was shut down at Mon Jun 12 09:12:36 2000 # DEBUG: Data Base System is in production state at Mon Jun 12 09:15:35 # 2000 # # starting/shutting down ? I don't see anything that would strike me as strange in there, assuming, of course, that is the time you started it, and the time you shut it down. -- SA, beyond.com My girlfriend asked me which one I like better. pub 1024/3CAE01D5 1994/11/03 Dustin Sallings [EMAIL PROTECTED] |Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE L___ I hope the answer won't upset her.
[GENERAL] (no subject)
Hallo, it was really helpfull but unfortunatly in this time I don't have time for your interesting group, so I invite you to delete my address from your list. Thanks Zamuner Lisa
[GENERAL] (no subject)
hello ,all: It's known that some database system such as Oracle,Sysbase can support the Two-Phase Commit that postgreSQL cann't. I want to make the postgreSQL cooperate with other database under a transaction manager so that we can deal with distributed transactions. Now I met some questions.I wish someone can help me. First, I have some trouble with log. I cann't find out the log's structure. I find the system writes two bits into block when a transaction commits.Maybe they the log's records.Is it right? Second ,I want to know the position of source codes about the postgres dealing with the input from the frontend such as psql. I'm eager to your helps.Thanks. If you are interested in the transaction processing,please send mail to me([EMAIL PROTECTED]). Guo Ge
