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 reas
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
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
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
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://arch
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 archive
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:
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
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
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
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
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 spee
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
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
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 clie
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
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)---
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 no
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 wro
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
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
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
que
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 en
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
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
25 matches
Mail list logo
