hello all
i've did pg_dump --data-only for quit a while and didn't have any
problem with restoring the resulting backup.
but since the schema changed slightly the restore fails:
ERROR: insert or update in table angebotsmuster violates
foreignkey-constraints
it seems to me like the order of the
On 8/28/2006 9:36 PM, Joshua D. Drake wrote:
Hello,
O.k. so how about a phased approach?
1. Contact maintainers to create their new projects on pgfoundry and
begin moving tickets
2. Migrate CVS
3. Migrate mailing lists
Apparently something cut the throat first. GBorg is down since
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jan Wieck
Sent: 31 August 2006 13:59
To: Joshua D. Drake
Cc: Dave Cramer; Greg Sabino Mullane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cutting the Gborg throat
On 8/28/2006 9:36 PM,
On 8/30/06, Randall Lucas [EMAIL PROTECTED] wrote:
I'm storing facts about an entity (e.g., company) in a normalized
form with various repeating groups, link tables, etc. My workflow
requires that after (or as part of) collecting these facts, I be able
to sign off as having verified all of the
Hello,
O.k. so how about a phased approach?
1. Contact maintainers to create their new projects on
pgfoundry and
begin moving tickets
2. Migrate CVS
3. Migrate mailing lists
Apparently something cut the throat first. GBorg is down since
Sunday.
Neptune lost
On Tue, 2006-08-29 at 11:56, David Fetter wrote:
On Tue, Aug 29, 2006 at 11:02:12AM -0500, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Does PostgreSQL support them?
Not yet.
Note, however, that by using the dblink package you can get something
like them.
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jan Wieck
Sent: 31 August 2006 13:59
To: Joshua D. Drake
Cc: Dave Cramer; Greg Sabino Mullane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cutting the Gborg throat
On
On 8/31/2006 9:10 AM, Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jan Wieck
Sent: 31 August 2006 13:59
To: Joshua D. Drake
Cc: Dave Cramer; Greg Sabino Mullane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cutting the
-Original Message-
From: Jan Wieck [mailto:[EMAIL PROTECTED]
Sent: 31 August 2006 14:51
To: Dave Page
Cc: Joshua D. Drake; Dave Cramer; Greg Sabino Mullane;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cutting the Gborg throat
Neptune lost 2 disks at once... Buts
Apparently something cut the throat first. GBorg is down since
Sunday.
Neptune lost 2 disks at once... Buts whats more interesting is
that
yours is the first complaint I've seen.
Meaning what?
A) Will be restored from backup
B) Data is lost finally and must be recovered from other
I seem to get this error user postgres could not be created, user
account already exists when trying to install postgres. Anyone knows
how to fix this?
Erik Jones wrote:
Erik Jones wrote:
Ok, consider the following table definition:
CREATE TABLE stats (
id SERIAL PRIMARY KEY,
hits bigint
Michael Nolan [EMAIL PROTECTED] writes:
Situation in a nutshell:
Production and test databases are on two separate systems inside the
firewall. The web server is at an ISP, outside the firewall.
The firewall sends all data coming from the ISP, port 5432 to a specific IP
address inside the
On Thu, Aug 31, 2006 at 03:27:13PM +0200, Magnus Hagander wrote:
Hello,
O.k. so how about a phased approach?
1. Contact maintainers to create their new projects on
pgfoundry and
begin moving tickets
2. Migrate CVS
3. Migrate mailing lists
Apparently
You don't look carefully enough. There's been a couple of
complaints
earlier. But no, not many.
Perhaps it's because you responded with a message to the effect
we're on it when I asked, and people took that to mean that
prompt action was in the works :)
Probably. Heck, that's what *I*
Can you give a link to the PostgreSQL binding? I haven't been able to
find it there. All I see is C, Perl and PHP bindings for the generation
of UUIDs, and nothing about storage.
(For my application, as it happens, I don't need to generate UUIDs in
the database, but I recognize that would be
Jan Wieck wrote:
On 8/28/2006 9:36 PM, Joshua D. Drake wrote:
Hello,
O.k. so how about a phased approach?
1. Contact maintainers to create their new projects on pgfoundry and
begin moving tickets
2. Migrate CVS
3. Migrate mailing lists
Apparently something cut the throat first. GBorg
grate mailing lists
Apparently something cut the throat first. GBorg is down since Sunday.
Neptune lost 2 disks at once... Buts whats more interesting is that
yours is the first complaint I've seen.
Fetter also brought it up, but it was on IRC :)
Regards, Dave.
--
=== The
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: 31 August 2006 15:47
To: Dave Page
Cc: Jan Wieck; Dave Cramer; Greg Sabino Mullane;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cutting the Gborg throat
grate mailing lists
Apparently
Postgres version: 8.1.3
I have a code similar to this pseudo-code:
try {
create temp table temp_report ...;
... do some processing using this table...
drop table temp_report;
commit;
} catch all errors {
rollback;
}
This code occasionally triggered the following error (couldn't
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Apparently something cut the throat first. GBorg is down since Sunday.
Neptune lost 2 disks at once... Buts whats more interesting is that
yours is the first complaint I've seen.
The squeaky wheel gets the grease? I'm certainly unhappy about
Hello everyone! i am checking a database due to some inconsintencies and
i was wandering if its possible to find out the creation date of a
record (using the oid, whatever...). Maybe i am saying something stupid
(since i am no DB expert) so if this is the case, please point it out
gently.
From this array how could I get back the fact that this array consists
of a two dimensional array with X elements?
Select array_dims('{{1,4,10,11},{1,5,4,5}}'::text [])
I would like to get back the number 4 here?
Thanks for the help.
Balázs
---(end of
Gibson wrote:
I seem to get this error user postgres could not be created, user
account already exists when trying to install postgres. Anyone knows
how to fix this?
Sounds to me like the user postgres on the OS already exists.
Joshua D. Drake
Erik Jones wrote:
Erik Jones wrote:
Ok,
How do i remove this user?I am running on Win XP here.
Joshua D. Drake wrote:
Gibson wrote:
I seem to get this error user postgres could not be created, user
account already exists when trying to install postgres. Anyone knows
how to fix this?
Sounds to me like the user postgres on the OS
Csaba Nagy wrote:
The code is possible to be executed in parallel by multiple threads, on
different connections, or in sequence on the same connection. I would
expect it in both cases to work correctly... in manual tests I was able
to create in parallel temporary tables named identically in
Obviously the test section has separate configurations to the live section -
simply have 2 databases defined in the same server 'ourlivedatabase' and
'ourtestdatabase'. This still gives one small login/config setting that
changes between live and dev.
On 31/8/2006 12:20, Kelly Burkhart [EMAIL
On Thu, 2006-08-31 at 17:25, Alban Hertroys wrote:
Csaba Nagy wrote:
The code is possible to be executed in parallel by multiple threads, on
different connections, or in sequence on the same connection. I would
expect it in both cases to work correctly... in manual tests I was able
to
Csaba Nagy wrote:
In any case, the error message is strange in itself, as if I try to
create the temporary table when it exists, the error I get in manual
trial is:
ERROR: relation test_temp_table already exists
compared to the error from the OP which I cite here for
I prefer to have my live and test databases on separate systems, if only because each one takes up well over 100 GB of disk space. Our hardware firewall doesn't support port changes, but I was able to get the rinetd port redirector working to redirect 5431 to 5432 on the test system.. (And it
Go to Start/ Control Panel / Administrative tools / Computer Management /
and you see Local Users and groups
Delete the user from there
- Original Message -
From: Gibson [EMAIL PROTECTED]
Cc: pgsql general pgsql-general@postgresql.org
Sent: Friday, September 01, 2006 2:31 AM
Subject:
I thought some people in this group may find this letter from one of
NetBSD's founders very interesting.
http://mail-index.netbsd.org/netbsd-users/2006/08/30/0016.html
It is current, to the point and has some direct correlations with our
project that we may want to be aware of.
Sincerely,
Csaba Nagy [EMAIL PROTECTED] writes:
In any case, the error message is strange in itself, as if I try to
create the temporary table when it exists, the error I get in manual
trial is:
ERROR: relation test_temp_table already exists
compared to the error from the OP which I
I have been having performance problems with my DB so this morning I
added some config to log queries that take more than 250ms. The result
is surprising because some queries will take as long as 10 seconds, but
then you do a explain analyze on them they show that indexes are being
used and they
# [EMAIL PROTECTED] / 2006-08-31 07:35:30 -0700:
Ralf Engelschall's OSSP uuid looks very good. Written in C with
interfaces into PostgreSQL, PHP and C++ (classes wrapping the C
structures and functions).
http://www.ossp.org/pkg/lib/uuid/
Can you give a link to the
Matthew Schumacher [EMAIL PROTECTED] writes:
I have been having performance problems with my DB so this morning I
added some config to log queries that take more than 250ms. The result
is surprising because some queries will take as long as 10 seconds, but
then you do a explain analyze on
On Thu, Aug 31, 2006 at 09:11:52AM -0700, Joshua D. Drake wrote:
I thought some people in this group may find this letter from one of
NetBSD's founders very interesting.
http://mail-index.netbsd.org/netbsd-users/2006/08/30/0016.html
It is current, to the point and has some direct
Hi!I am unable to install postgres 7.1.2 on my Ubuntu Linux Box. I am installing postgres 7.1.2 from source. I stopped at the process of invoking the make command. I have a 7.1.2 database with me and plan to replicate it to another box. Pg_dump reports and error while I was dumping.
My Linux
On 8/31/06, Jonathan Chocolate [EMAIL PROTECTED] wrote:
Hi!
I am unable to install postgres 7.1.2 on my Ubuntu Linux Box. I am
installing postgres 7.1.2 from source. I stopped at the process of invoking
the make command.
I have a 7.1.2 database with me and plan to replicate it to another box.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonathan Chocolate wrote:
Hi!
I am unable to install postgres 7.1.2 on my Ubuntu Linux Box. I am
installing postgres 7.1.2 from source. I stopped at the process of
invoking the make command.
What error(s)?
I have a 7.1.2 database with me and
Josh,
It is current, to the point and has some direct correlations with our
project that we may want to be aware of.
Well, we're not in any danger of the board of a foundation taking over
Postgres. ;-)
The only part of this that I see as relevant to us is setting of
development goals. And
The only part of this that I see as relevant to us is setting of
development goals. And we've already discussed this ad nauseum on the
Hackers list and AFAIK have an initial plan (the enhanced TODO), lacking
only the resources to implement it this month.
Almost the whole thing is relevant
On Fri, Sep 01, 2006 at 01:57:03AM +0800, Jonathan Chocolate wrote:
Hi!
I am unable to install postgres 7.1.2 on my Ubuntu Linux Box. I am
installing postgres 7.1.2 from source. I stopped at the process of invoking
the make command.
Dear gods, that's an ancient version. You're not going to
Martijn van Oosterhout wrote:
-- Start of PGP signed section.
On Thu, Aug 31, 2006 at 09:11:52AM -0700, Joshua D. Drake wrote:
I thought some people in this group may find this letter from one of
NetBSD's founders very interesting.
Hello -
I am attempting to find a way to make use of arrays of text, as
demonstraited by the following:
CREATE TABLE messages (
id SERIAL,
format TEXT NOT NULL,
arguments TEXT[]
);
Into that table will be values that you would associate with some form of
printf. For example:
INSERT
Josh,
On the other hand, we do suffer from the locked project problem (the
recent recursive query debacle is a perfect example).
Yep, and that was immediately recognized as a problem in need of a
solution. In fact, some of the arguments againts the issue/feature
tracker were that it would
In general, I think that people who harp on PostgreSQL's lack of a
benevolent dictator as an inhibitor to progress are people who are not
comfortable with democracy and are looking for excuses why company X needs
to take over the project for its own good.
Well I definitely don't think we need
Joshua D. Drake wrote:
The only part of this that I see as relevant to us is setting of
development goals. And we've already discussed this ad nauseum on the
Hackers list and AFAIK have an initial plan (the enhanced TODO), lacking
only the resources to implement it this month.
Tom Lane wrote:
Matthew Schumacher [EMAIL PROTECTED] writes:
I have been having performance problems with my DB so this morning I
added some config to log queries that take more than 250ms. The result
is surprising because some queries will take as long as 10 seconds, but
then you do a
On Thu, Aug 31, 2006 at 11:18:27AM -0700, Joshua D. Drake wrote:
On the other hand, we do suffer from the locked project problem (the
recent recursive query debacle is a perfect example).
Maybe, but we don't have the extreme form. Patches have been submitted
by people other than the ones
On the other hand, we do suffer from the locked project problem (the
recent recursive query debacle is a perfect example).
Yep, but fortunately this problem doesn't happen to us often.
I think this might happen more then you think. I ran into it with Alvaro
just a couple of days ago. I
Martijn van Oosterhout kleptog@svana.org writes:
On Fri, Sep 01, 2006 at 01:57:03AM +0800, Jonathan Chocolate wrote:
I am unable to install postgres 7.1.2 on my Ubuntu Linux Box.
Dear gods, that's an ancient version. You're not going to get a lot of
help fixing something that old, nearly 6
[EMAIL PROTECTED] wrote:
Hello -
I am attempting to find a way to make use of arrays of text, as
demonstraited by the following:
Interesting problem. Apparently plperl is not cool about parsing arrays
in the arguments to Perl arrays -- at least I couldn't make it work, and
I don't find any
In response to Joshua D. Drake [EMAIL PROTECTED]:
On the other hand, we do suffer from the locked project problem (the
recent recursive query debacle is a perfect example).
Yep, but fortunately this problem doesn't happen to us often.
I think this might happen more then you think.
[EMAIL PROTECTED] writes:
* If I could figure a way to pass a variable number of arguments to a
plperl function, or an array reference, I could use something like this
function:
Doesn't plperl already contain a feature to convert a Postgres array
into a Perl array? It may be
On Thu, 2006-08-31 at 11:04 -0800, Matthew Schumacher wrote:
Tom Lane wrote:
Matthew Schumacher [EMAIL PROTECTED] writes:
I have been having performance problems with my DB so this morning I
added some config to log queries that take more than 250ms. The result
is surprising because some
Josh Berkus josh@agliodbs.com writes:
In general, I think that people who harp on PostgreSQL's lack of a
benevolent dictator as an inhibitor to progress are people who are not
comfortable with democracy and are looking for excuses why company X needs
to take over the project for its own
Jeff Davis wrote:
http://www.postgresql.org/docs/8.1/static/mvcc.html
In the Explicit Locking section it details the locks acquired by
UPDATE, etc.
From what you described, I would not expect many locking problems. Are
there any other types of queries you run that may cause a lock? Do you
Jeff Davis [EMAIL PROTECTED] writes:
From what you described, I would not expect many locking problems. Are
there any other types of queries you run that may cause a lock?
Row locks (SELECT FOR UPDATE/SHARE) are a possible problem, particularly
if this is a pre-8.1 Postgres where exclusive row
Alvaro Herrera wrote:
[EMAIL PROTECTED] wrote:
Hello -
I am attempting to find a way to make use of arrays of text, as
demonstraited by the following:
Interesting problem. Apparently plperl is not cool about parsing arrays
in the arguments to Perl arrays -- at least I couldn't make it
[EMAIL PROTECTED] (Jonathan Chocolate) writes:
I am unable to install postgres 7.1.2 on my Ubuntu Linux Box. I am installing
postgres 7.1.2 from source. I stopped at the
process of invoking the make command.
I have a 7.1.2 database with me and plan to replicate it to another box.
Pg_dump
Matthew Schumacher [EMAIL PROTECTED] writes:
I have autovacuum = on in the config file with a pretty frequent
autovacuum_naptime, but I'm unsure if that does a vacuum or vacuum full.
autovacuum *never* does a vacuum full, because that would lead to
unexpected blockages of foreground queries.
Csaba Nagy [EMAIL PROTECTED] writes:
create temp table temp_report ...;
... do some processing using this table...
drop table temp_report;
commit;
This code occasionally triggered the following error (couldn't reliably
reproduce):
ERROR: type temp_report already exists
BTW, when
Tom Lane wrote:
Josh Berkus josh@agliodbs.com writes:
In general, I think that people who harp on PostgreSQL's lack of a
benevolent dictator as an inhibitor to progress are people who are not
comfortable with democracy and are looking for excuses why company X needs
to take over the
On Thu, Aug 31, 2006 at 09:17:54AM -0400, Merlin Moncure wrote:
On 8/30/06, Randall Lucas [EMAIL PROTECTED] wrote:
An inverted way of thinking about the problem is the notion of getting a
source document (say, a company registration form) and parsing and
storing it in a normalized format.
Bruce Momjian wrote:
Tom Lane wrote:
It's pointless to suppose that individual developers would really be
answerable to any project-wide management, since that's not who they're
paid by. So I tend to think that a project roadmap would be more of an
exercise in wishful thinking than a
65 matches
Mail list logo
