[GENERAL] synchronisation with news.fr.postgresql.org?
Hi. What happened to the synchronization of news servers between news.postgresql.org and news.fr.postgresql.org. the latter is there, but the groups are empty. this is very sad since that server was very quick for us living in Europe. is it only a temporary problem or is it removed for some reason? /stig ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] what happened with the news servers?
Hi. i am looking at the news (NNTP) servers news.postgresql.org and news.fr.postgresql.org, they both seem pretty empty. what happened? stig ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] opening a channel between two postgreSQL-servers?
Michael Fuhr wrote: On Sat, Nov 04, 2006 at 10:12:00PM +0100, stig erikson wrote: a handy thing in mysql is FEDERATED tables that allows one to open a channel from one MySQL-server to another MySQL-server. it helps a lot when writing stored procedures that transfer data to other servers. you can do the transfer without any extarnal temporary files or external applications that read from one server and insert into another server. Does PG have anything similar? Not in the stock installation but you can establish a connection between one PostgreSQL server and another with contrib/dblink, or with just about any other data source using David Fetter's dbi-link. http://pgfoundry.org/projects/dbi-link/ PostgreSQL has several server-side languages such as PL/Perl, PL/Python, PL/Tcl, PL/Ruby, PL/php, PL/Java, PL/R, etc. In general a server-side function written in one of those languages can do anything a standalone application could do, such as connecting to another database, even a different DBMS (you could connect from PostgreSQL to MySQL, Oracle, SQL Server, etc.). thank you Michel and Ben. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] opening a channel between two postgreSQL-servers?
Hi. a handy thing in mysql is FEDERATED tables that allows one to open a channel from one MySQL-server to another MySQL-server. it helps a lot when writing stored procedures that transfer data to other servers. you can do the transfer without any extarnal temporary files or external applications that read from one server and insert into another server. Does PG have anything similar? if yes, which chapter in the docs for 8.1 will tell me more? no wars please. i just want to know if such a possibility exists in PG. /stig ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] CUBE, ROLLUP, GROUPING SETS?
Hi. Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in future PostgreSQL versions? I could not find any info on the TODO-page. /stig ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL] off topic - web shop
Hi. We are looking to open a small web shop. I looked around to see if there are any open source web shops. Can anyone recommend any web shop system (free or non-free)? thanks stig ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] sequence rollback?
hello.
is it possible to rollback sequences in postgresql 8.1.1?
(tested om FC4 with official rpms).
it seems like a sequence is always moving forward and cannot be rolled
back. is this correct?
if it is correct, where in the docs do i find information about this
behavior?
/stig
testcase:
bash-2.05b$ createdb testseq
CREATE DATABASE
bash-2.05b$ psql -d testseq
Welcome to psql 8.1.1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
testseq=# create sequence test_seq increment 1 minvalue 1;
CREATE SEQUENCE
testseq=# create table test0 ( id int8 NOT NULL DEFAULT
nextval('test_seq'), text varchar(20) );
CREATE TABLE
testseq=# begin;
BEGIN
testseq=# insert into test0 (text) values('hello');
INSERT 0 1
testseq=# select * from test0;
id | text
+---
1 | hello
(1 row)
testseq=# rollback;
ROLLBACK
testseq=# begin;
BEGIN
testseq=# insert into test0 (text) values('hello');
INSERT 0 1
testseq=# select * from test0;
id | text
+---
2 | hello
(1 row)
testseq=# rollback;
ROLLBACK
---(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] synchronization of news.postgresql.org and news.fr.postgresql.org
hi, information to the news masters. it seems like messages from news.fr.postgresql.org are not reaching news.postgresql.org. (the other way around seems to work though). end of message ---(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] postgresql rpms (8.1.1) for redhat 8.0
hi. i have compiled postgresql 8.1.1 rpms for redhat 8.0 based on the official srpms for redhat 9. i just installed the rpms and it looks like they are working well. if somebody is interested i have put the compiled files here: ftp://82.182.149.199/pub/postgresql/unofficial/ feel free to grab them but do read the README file. /stig ---(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] using more then one CPU for queries
from what i understand PostgreSQL only uses one CPU for any one query. i do understand that on systems where there are many more connections and simultaneous transactions (relatively small transactions) then the number of processors, the queries would most likely run on a single processor even if more processors were available. on systems with many long running queries (possibly analytical) the same would apply. but on systems with relatively few queries compared to the number of processors or on systems that have many small queries running and a few large it could help run the large queries on more then one processor. i would like to ask if there are some plans or if there has been any discussions about allowing any one query to run on more then one processor? tia. stig ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] news.postgresql.org slow
Marc G. Fournier wrote: On Sat, 3 Dec 2005, stig erikson wrote: Hi. this might not be the correct place to ask but i see not better place. i use the news server news.postgresql.org. every now and then i go offline and i usually do a offline synchronization before (download every message, head + body). the news.postgresql.org server seems to have some speed limit that only allows the receiver (my news reader) to fetch ~2 messages per second. this is painfully slow. would it be possible for the server holder to change this limit (if such a limit is in place) to allow, say, twice as many bodies to be transmitted per second? it is not a bandwidth problem at my end (but could of course be something else at my end), i don't see this problem with other news servers though. There are no limits imposed on the news server, but you might want to try news.fr.postgresql.org, which might be a closer server for you ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings thank you. that made a difference, the french server is twice as fast for me. ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] news.postgresql.org slow
Hi. this might not be the correct place to ask but i see not better place. i use the news server news.postgresql.org. every now and then i go offline and i usually do a offline synchronization before (download every message, head + body). the news.postgresql.org server seems to have some speed limit that only allows the receiver (my news reader) to fetch ~2 messages per second. this is painfully slow. would it be possible for the server holder to change this limit (if such a limit is in place) to allow, say, twice as many bodies to be transmitted per second? it is not a bandwidth problem at my end (but could of course be something else at my end), i don't see this problem with other news servers though. thanks stig ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] 8.1.0 for RH8 here
Hi. I just compiled the RH9 sources on my RH8 system, seems to work just fine. The packages are available via the link below. Anyone who likes, may fetch the rpms. Do read the README file before using the packages and keep in mind, they are not official. I can only verify that they work on my small development system, nothing else. link: ftp://82.182.149.199/pub/postgresql/unofficial/810_rh8_srpms_compiled_for_rh8/ stig ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] psql: FATAL: database "template1" is not currently accepting
stig erikson wrote: when i try to do: psql -l psql: FATAL: database "template1" is not currently accepting connections but if i first connect to some other database, ie: psql -d database \l then it shows all the databases. how can i resolve the issu with template1? the problem might have been coused by a client that hang and was closed with kill -9. the database has been restarted and there are no active connections hanging around. /stig my main concern is with pg_dumpall. pg_dumpall: could not connect to database "template1": FATAL: database "template1" is not currently accepting connections postgresql 7.4.8 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] psql: FATAL: database "template1" is not currently accepting connections
when i try to do: psql -l psql: FATAL: database "template1" is not currently accepting connections but if i first connect to some other database, ie: psql -d database \l then it shows all the databases. how can i resolve the issu with template1? the problem might have been coused by a client that hang and was closed with kill -9. the database has been restarted and there are no active connections hanging around. /stig ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] encoding problems and float
hi.
is there any encoding that does allow decimal placeholders in float8 to be
either , or .?
that is, it should allow both of the folling to denote for example EUR 12345 and
44 cents:
insert into table(my_float8_column) VALUES('12345.44');
insert into table(my_float8_column) VALUES('12345,44');
/stig
---(end of broadcast)---
TIP 8: explain analyze is your friend
Re: [GENERAL] postgresql rpms (7.4.2, 7.4.5, 7.4.8) for redhat 8.0
Could you please sign them with your PGP key and upload them again? I think I can upload them to main FTP site. do i do that with rpm or can i just sign them and provide the signautres in textfiles next to the rpm files? ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] postgresql rpms (7.4.2, 7.4.5, 7.4.8) for redhat 8.0
hi. i just compiled a few versions of postgresql rpms for redhat 8.0 based on the official srpms for redhat 9. i started off with the official 7.4.1 release for redhat 8, then added the lowest possible next version of the version i compiled. i ended up at 7.4.8. it seems to work fine. i am not running a production server on this machine so it _seems_ to work fine, but i can't tell at the moment if there is something not running well. anyhow, if somebody is interested i have put the compiled files here: ftp://82.182.149.199/pub/postgresql/unofficial/ feel free to grab them but do read the README file. /stig ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] Postgresql 7.4.7 docs(PDF)
Hrishikesh Deshmukh wrote: What they have is for version 7.2 and i want for 7.4.7 only, i have tried to follow instructions on how to make the pdf/ps version and all i get is errors. If someone already has a pdf/ps and can email it, will be a big help. Thanks, Hrishi On 5/19/05, Richard Huxton wrote: Hrishikesh Deshmukh wrote: Hi All, If someone can email Postgresql 7.4.7 docs(PDF). It will be a big help. I am unable to get pdf docs for this version on debian system. Please help. Available from here: http://www.postgresql.org/docs/manuals/ See the links on the right-hand-side of the page. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) whats the problem? 7.4 documentation in pdf is there: http://www.postgresql.org/files/documentation/pdf/7.4/postgresql-7.4.2-A4.pdf http://www.postgresql.org/files/documentation/pdf/7.4/postgresql-7.4.2-US.pdf changelog (release notes): http://www.postgresql.org/docs/7.4/static/release.html ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] dumping on 7.4.6 importing on 7.4.1
Tom Lane wrote: Is it possible to dump a database on a 7.4.6 server and then restore it on a 7.4.1 server? Should work, but why aren't you updating the 7.4.1 server? There were some pretty nasty bugs fixed between .1 and .6. problem is i dont have full power over that machine. i will try to talk to the admin. it's redhat 8.0 with postgresql installed from rpms, maybe there are new rpms somewhere? i could not find any official builds for rh8, does the rh9 rpms work? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[GENERAL] dumping on 7.4.6 importing on 7.4.1
Hi. Is it possible to dump a database on a 7.4.6 server and then restore it on a 7.4.1 server? should i use the 7.4.1 pg_dump or the 7.4.6 pg_dump? should i use any switches? thanks ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] logging queries and time used
Hi. i would like to log every single query coming in to the database into a table. i would like the log to include the entire query and execution time and execution cost, and if possible the user that executed the query. A trigger is what i was thinking of, but how can i find out the actual query, the time it took to execute it, etc.? stig ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] The data directory was initialized by PostgreSQL version 7.3,
Bilicki Vilmos wrote: Hi all, I have upgraded my cygwin installation and it has replaced my old 7.3 postgresql. My questions are the following: How can I use the old files with the newer version? If this is not possible, how can I migrate my database to a newer version without the old database engine? If this is not possible how can I downgrade the postgresql to an appropriate version? (The setup utility provides only the 7.4 version) Many thanks for helping me, Vilmos ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match see: http://www.postgresql.org/docs/7.4/static/install-upgrading.html ---(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] schema repository
Is there a schema repository somewhere? i am looking for a data warehouse clickstream schema to get some view on how others have made such a schema. ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] cost logging
Hello. For a project we are planning cost management. Each "user" should pay for the cost he/she generates on the postgresql server. The idea is that a query should be charged by the ammount of CPU time used and/or the ammount of data read from disk. The acctual time (in milliseconds) it took to execute will not be a good way of getting the cost since the same query might take more or less time depending on current load and depeding on the state of a table. Question is, can in some "good" way log or save (possibly using triggers) the CPU cost for each query that was run? if there is such cost management? please point me to the chapter in the manual if i simply missed it. postgresql 7.4.5 is used, platform is linux. /stig ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
