-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ümit Öztosun
Sent: Tuesday, February 06, 2007 3:59 PM
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Very strange error
Have you installed any updates for PostgreSQL? The
> -Original Message-
> From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ümit Öztosun
> Sent: Tuesday, February 06, 2007 2:50 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Very strange error
>
>
> Hi,
>
> Today suddenly our PostgreSQL 8.1 server started produci
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of roopa perumalraja
Sent: Tuesday, February 06, 2007 12:33 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Storing database in cluster (Memory)
Hi all,
As I am inserting 100million rows daily into
> In an 8.1.6 UTF-8 database this example returns false; in 8.2.1 it
> returns true. See the following commit message and the related bug
> report regarding PL/Perl and UTF-8:
>
> http://archives.postgresql.org/pgsql-committers/2006-10/msg00277.php
> http://archives.postgresql.org/pgsql-bugs/2006
You have to call the function in the following form:
SELECT * FROM get_test_data(1) AS (field1 type, field2 type, ...)
In words, you have to tell the database how the data returned by the
function has to be interpreted.
Greetings,
Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
Hi Robert!
Sure, why not? Both databases run on different directories, ports, sockets
and so on.
Greetings,
Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Wolfe, Robert
> Sent: Wednesday, November 22, 2006 4:53 PM
> To: pgsql-general@pos
Hi!
You can at least configure the socket directory, the socket group and the
socket permissions in your postgresql.conf.
Greetings,
Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> garry saddington
> Sent: Wednesday, November 22, 2006
Title: Nachricht
Hello
Gurjeet!
Tried
your suggestion but this is just a marginal improvement.
Our
query needs 126 ms time, your query 110 ms.
Greetings,
Matthias
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Gurjeet SinghSent: Wednes
Hello!
I have to tables, component with unchanging component data and a
component_history table containing the history of some other values that can
change in time.
The table component_history holds a foreign key to the component_id column
in the component table. The table component_history has a
He's just trying to do what you told him.
But the use of initdb won't correct the problem Igor got. There's something
wrong with his database so that he can't start the postmaster process:
> PANIC: failed to re-find parent key in "23724"
Unfortunately i don't have any idea how to solve this issue
Hi!
According to the synopsis of UPDATE you just can update one table at a time.
Just use more UPDATE commands inside a transaction.
-- Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Marko Rihtar
> Sent: Monday, November 13, 2006 2:21 PM
Hm, why not this one:
select ('2006-10-31'::date, '-12-31'::date) OVERLAPS
('2006-10-16'::DATE, '2006-10-31':: DATE);
overlaps
--
f
(1 row)
Greetings,
Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: Thursday,
Hi Anton!
I'm not sure how this is with 8.1 but on 7.4.14 we have to enable row level
statistics collection for autovacuum:
stats_row_level = true
Greetings,
Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Anton Melser
> Sent: Thursday, N
Title: Nachricht
Hi!
Just
use this:
FETCH crs_cnt into row_cnt;
EXIT WHEN NOT FOUND;
Greetings,
Matthias
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Jeremiasz MiedzinskiSent: Thursday, November
09, 2006 1:15 PMTo: pgsql-general@p
Title: Nachricht
What
disk subsystem do you have? Single disks? Raid? Raid with battery buffered write
cache?
Last
one can improve your performance massively.
--
Matthias
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of roopa perumalrajaS
You have to create t2 as following:
CREATE TABLE t2 (id int, grp int references t1(id) ON UPDATE CASCADE ON
DELETE CASCADE, info text);
Through the cascade commands Postgresql will check the t2 table on rows
which have to be deleted or updated according to your changes in t1.
For changing the exi
In PL/pgSQL you could use the RAISE command:
http://www.postgresql.org/docs/8.1/interactive/plpgsql-errors-and-messages.h
tml
Best regards,
Matthias
> -Original Message-
>
> Hi,
>
> this is sort of a silly question, but: what's the proper way to
> intentionally generate an error? I'm w
Title: Nachricht
Hello
Vijay!
Not
100% sure but Ubuntu should have the database set up similar to Debian on which
it's based. This means, you can start the database via:
/etc/init.d/postgresql start
This
should use the distribution specific startup scripts.
Greetings,
Matthias
Just curious but since which version these IN/OUT parameters are supported?
-- Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of A. Kretschmer
> Sent: Wednesday, October 04, 2006 4:01 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GEN
Hello all!
Is it possible to define a complex return type like a record in a function
without having some table around with the needed structure of the return
values?
For example: if i want a function that returns a date and an integer, i
create the function:
CREATE FUNCTION bla(text) RETURNS SET
What kind of errors? Just saying "i got some errors" isn't very helpfull for
us to be able to help you properly ;)
So, what exact error messages you get when trying to restore the database?
-- Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf O
Title: Nachricht
Hm,
depends on how the security settings of the database are set. For local users
you could set in the pg_hba.conf ident as authentication method. Then they won't
need a password anymore.
See
the pg_hba.conf documentation for more infos.
Another way could be to execute the d
Hello everyone!
Small update on this issue:
Our server has four 146GB disks as pairwise RAID 1 and one of these is
affected by the bug mentioned in the HP support page.
As quick fix i moved our database to the the other raid device built of
unaffected disks. Till now i don't got any new database c
Title: Nachricht
Hi
Alain!
To get
all the users and so on to the other machine, you have to use the pg_dumpall
tool with the -g switch. This will dump out all the users, groups and roles i
think.
--
Matthias
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTE
Title: Nachricht
Simply
dump the database with pg_dump, copy the dump to the other machine and restore
the dump there.
See
the man pages of pg_dump how to use the tool. If you're database contains
foreign keys or similar, make sure to include OIDs into the database
dump.
--
Matthias
Hello there!
Are there any good and recommendable books about PL/PGSQL programming?
Covering new features of PostgreSQL 8.x is no must but would be nice to
have.
Best regards,
Matthias
---(end of broadcast)---
TIP 1: if posting/reading through Usen
Hello all!
Ok, i found out some more informations. According to
http://h2.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&;
taskId=110&prodSeriesId=397634&prodTypeId=15351&prodSeriesId=397634&objectID
=PSD_EX050119_CW01 one of our four disks in the server has a firmware issue.
Th
Hello Tom!
Not yet, but i will try this one too. Anything special i should look for
when dumping out the bad pages?
-- Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
> Sent: Wednesday, September 20, 2006 4:32 PM
> To: [EMAIL PRO
Hello Scott!
Thank you. Memtest86 i know. I think we will use this for testing our
hardware too.
Got some other nice information meanwhile from someone also running a DL380
server which had a defect backplane causing similar issues.
He also gave me the hint that there's a test suite CD by Compaq t
Hello Scott!
Thank you for the quick answer. I'll try to check our hardware which is a
Compaq DL380 G4 with a batteyr buffered write cache on our raid controller.
As the system is running stable at all i think it's not the cpu or memory.
At moment i tend more to a bad disk or SCSI controller but
Hello!
We're running the latest release of PostgreSQL 7.4.13 on a Debian Sarge
machine. Postgres has been compiled by oureselves.
We have a pretty big database running on this machine, it has about 6.4 GB
approximately. One table contains about 55 million rows.
Into this table we insert about 5000
Hello Lukasz!
You need some port forwarding onto your router/firewall. You have to forward
incoming connections on port 5432 (or the port postmaster is listening on)
from IP xxx.xxx.xxx.xxx to IP yyy.yyy.yyy.yyy with the according port. If
your router is a Linux machine, take a look into the iptab
32 matches
Mail list logo
