>>>Ryan Bradetich said:
> the table would look like:
> 1 | Mon Feb 17 00:34:24 MST 2003 | p101 | user x has an invalid shell.
> 1 | Mon Feb 17 00:34:24 MST 2003 | p101 | user y has an invalid shell.
> 1 | Mon Feb 17 00:34:24 MST 2003 | p101 | user y has expired password.
> 2 | Mon Feb 17 00:34
> I ended up with few only indexes on the operations table, because the
> processes that fill it up do minimal lookups to see if data is already in the
> table, if not do inserts. Then at regular intervals, the table is cleaned up -
> that is, a process to remove the duplicate is run. This unfortun
On Sun, Feb 16, 2003 at 23:51:49 -0500,
Greg Stark <[EMAIL PROTECTED]> wrote:
>
> Hm, odd, nobody mentioned this solution:
>
> If you don't have a primary key already, create a unique index on the
> combination you want to be unique. Then:
>
> . Try to insert the record
> . If you get a duplic
> But this argument is mostly irrelevant if the proposed change will not
> affect behavior in a default installation. I guess I'm not entirely
> clear on exactly which cases it will affect. What will your proposed
> change do in each possible combination (database encoding is SQL_ASCII
> or not,
Hi,
I've seen this (see below) in the postmaster's log-file.
I doubt this is normal behaviour.
I'm using PostgreSQL 7.2.3 on hppa-hp-hpux10.20, compiled by GCC 2.95.2
Does anybody know what may cause calls to semctl resp. shmctl
(semaphore control resp. shared memory control) to fail?
The applic
Greetings,
I am doing a project for college developing a java
system utilizing a RDBMS. The choice is between PostgreSQL and Oracle and I'm
wondering exactly how impossible would it be to make it compatible with both.
Postgre is said to be completely ANSI SQL complaint, is it feasible to im
Ryan Bradetich <[EMAIL PROTECTED]> writes:
> the table would look like:
> 1 | Mon Feb 17 00:34:24 MST 2003 | p101 | user x has an invalid shell.
> 1 | Mon Feb 17 00:34:24 MST 2003 | p101 | user y has an invalid shell.
Ah, I see your point now. (Thinks: what about separating the "anomaly"
column i
Christoph Haller <[EMAIL PROTECTED]> writes:
> I've seen this (see below) in the postmaster's log-file.
> I doubt this is normal behaviour.
> I'm using PostgreSQL 7.2.3 on hppa-hp-hpux10.20, compiled by GCC 2.95.2
> Does anybody know what may cause calls to semctl resp. shmctl
> (semaphore control
>
> This is a fairly spectacular failure :-(. As far as I can see from
the
> semctl and shmctl man pages, the only plausible reason for EINVAL is
> that something had deleted the semaphores and shared memory out from
> under Postgres. I do not believe that Postgres itself could have done
> that
On Mon, 16 Feb 2003, Ryan Bradetich wrote:
> I am not sure why all the data is duplicated in the index ...
Well, you have to have the full key in the index, or how would you know,
when you look at a particular index item, if it actually matches what
you're searching for?
MS SQL server does have
Martin Matusiak kirjutas E, 17.02.2003 kell 16:53:
> Greetings,
>
> I am doing a project for college developing a java system utilizing a
> RDBMS. The choice is between PostgreSQL and Oracle and I'm wondering
> exactly how impossible would it be to make it compatible with both.
> Postgre is said
This is a patch that allows PostgreSQL to use a configuration
file that is outside the main database directory.
It adds one more command line parameter, "-C" which
specifies the location of the postgres configuration file.
A patched version of PostgreSQL will function as:
postmaster -C /etc/post
Kevin Brown <[EMAIL PROTECTED]> writes:
> Is it possible for the database engine to properly deal with a
> database when it is told to use a different database encoding than the
> one the database was initdb'd with?
It can't be "told to use a different database encoding". However, the
default *cl
mlw <[EMAIL PROTECTED]> writes:
> If no hba_conf and/or ident_conf setting is specified, the default
> $PGDATA/pg_hba.conf and/or $PGDATA/pg_ident.conf will be used.
Doesn't anybody see the (a) inconsistency and (b) uselessness of this?
If you are trying to keep your config files out of the data d
On Fri, Feb 14, 2003 at 10:35:41AM -0500, Tom Lane wrote:
> FHS or no FHS, I would think that the preferred arrangement would be to
> keep Postgres' config files in a postgres-owned subdirectory, not
> directly in /etc. That way you need not be root to edit them. (My idea
Besides, what are you
On Sun, Feb 16, 2003 at 12:16:44AM -0500, Tom Lane wrote:
> Nor will I buy an argument that only a few developers have need for test
> installations. Ordinary users will want to do that anytime they are
> doing preliminary tests on a new PG version before migrating their
> production database to i
Christoph Haller wrote:
> No, I'm not sure at all about a loose-cannon script running around
> issuing ipcrm commands.
> I have to ask the other staff members what scripts are running.
> I already had a suspicion that something like an ipcrm command is
> causing this,
> but it was denied. Now, with
Tom Lane wrote:
mlw <[EMAIL PROTECTED]> writes:
If no hba_conf and/or ident_conf setting is specified, the default
$PGDATA/pg_hba.conf and/or $PGDATA/pg_ident.conf will be used.
Doesn't anybody see the (a) inconsistency and (b) uselessness of this?
If you are trying to keep your config f
Curt Sampson wrote:
> On Mon, 16 Feb 2003, Ryan Bradetich wrote:
> > Since my only requirement is that the rows be unique, I have developed a
> > custom MD5 function in C, and created an index on the MD5 hash of the
> > concatanation of all the fields.
>
> Well, that won't guarantee uniqueness, si
Postgres has a bad habit of becoming very confused if the page header of
a page on disk has become corrupted. In particular, bogus values in the
pd_lower field tend to make it look like there are many more tuples than
there really are, and of course these "tuples" contain garbage. That
leads to c
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Postgres has a bad habit of becoming very confused if the
Tom> page header of a page on disk has become corrupted. In
Tom> particular, bogus values in the pd_lower field tend to make
I haven't read this piece of pgsql code very
On Thu, Feb 13, 2003 at 03:27:01PM +1000, Paul L Daniels wrote:
> Good evening, tonight while running my routine vacuum, the following came up on my
>screen:
>
> ---8<---
> NOTICE: Rel xamefiles: Uninitialized page 708135 - fixing
> NOTICE: Rel xamefiles: Uninitialized page 708136 -
I noticed a pretty obscure deadlock condition with REINDEX in CVS HEAD:
client1:
nconway=# create table a (b int unique, c int unique);
CREATE TABLE
nconway=# begin;
BEGIN
nconway=# lock table a in access exclusive mode;
LOCK TABLE
client2:
nconway=# reindex index a_b_key;
< blocks, waiting to
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Thu, Feb 13, 2003 at 03:27:01PM +1000, Paul L Daniels wrote:
>> NOTICE: Rel xamefiles: Uninitialized page 708135 - fixing
>> NOTICE: Rel xamefiles: Uninitialized page 708136 - fixing
>> NOTICE: Rel xamefiles: Uninitialized page 708137 - fixing
>
I'm preparing a patch to make more psql slash commands
tab-completable (\di, \dv etc-) and have come across the following dilemma:
- only relations visible in the current search path should be returned [*]
- to determine visibilty via pg_catalog.pg_table_is_visible(), the
relation's OID is nec
> Hello,
>
> I was wondering what kind of functions/constants exist in Postgre to dig
up
> metadata. I barely scratched the surface of Oracle but I know you find
> things like user_tables there that can be used to extract info about your
> tables. What I'm looking for is some kind of functions to
Neil Conway <[EMAIL PROTECTED]> writes:
> Naturally, this situation is not a very common one. But it seems to me
> that the practice of acquiring locks in REINDEX in an inconsistent order
> is asking for trouble: REINDEX TABLE locks the heap rel first, followed
> by any indexes of the heap rel, but
Ian Barwick <[EMAIL PROTECTED]> writes:
> Q: is there any likelihood of the pg_catalog views (pg_views, pg_tables,
>pg_indexes, pg_rules, possibly others I have missed) returning the
>relevant OID or (probably cleaner) the result of pg_table_is_visible()
>as a boolean?
That strikes m
On Mon, 2003-02-17 at 18:39, Tom Lane wrote:
> > I was thinking of changing reindex_index() to acquire an AccessShareLock
> > on the index in question, find its parent rel ID, release the lock, then
> > acquire an AccessExclusiveLock on the parent rel, followed by an
> > AccessExclusiveLock on the
Neil Conway <[EMAIL PROTECTED]> writes:
> On Mon, 2003-02-17 at 18:39, Tom Lane wrote:
>> If you release the lock then I think you are opening yourself to worse
>> troubles than this one, having to do with someone renaming/deleting the
>> table and/or index out from under you.
> Presumably, the re
On Mon, 17 Feb 2003, Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > On Mon, 2003-02-17 at 18:39, Tom Lane wrote:
> >> If you release the lock then I think you are opening yourself to worse
> >> troubles than this one, having to do with someone renaming/deleting the
> >> table and/or
> This is a fairly spectacular failure :-(. As far as I can see from the
> semctl and shmctl man pages, the only plausible reason for EINVAL is
> that something had deleted the semaphores and shared memory out from
> under Postgres. I do not believe that Postgres itself could have done
> that ---
On Mon, 17 Feb 2003, Tom Lane wrote:
> Postgres has a bad habit of becoming very confused if the page header of
> a page on disk has become corrupted.
What typically causes this corruption?
If it's any kind of a serious problem, maybe it would be worth keeping
a CRC of the header at the end of t
I didn't think pgstattuple had proper visibility checks.
---
Hans-Jürgen Schönig wrote:
> This patch adds a note to the documentation describing why the
> performance of min() and max() is slow when applied to the entire ta
Curt Sampson <[EMAIL PROTECTED]> writes:
> On Mon, 17 Feb 2003, Tom Lane wrote:
>> Postgres has a bad habit of becoming very confused if the page header of
>> a page on disk has become corrupted.
> What typically causes this corruption?
Well, I'd like to know that too. I have seen some cases tha
[EMAIL PROTECTED] ("Martin Matusiak") wrote:
> Would it be possible to create some sort of transparent API based on
> ODBC to be used with PostgreSQL and Oracle? I know there exists a
> JDBC - ODBC bridge for java.
If you wrote your application exclusively using JDBC using functions
existing in bo
On Mon, 17 Feb 2003, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
>
> > If it's any kind of a serious problem, maybe it would be worth keeping
> > a CRC of the header at the end of the page somewhere.
>
> See past discussions about keeping CRCs of page contents. Ultimately
> I think
Curt Sampson <[EMAIL PROTECTED]> writes:
> Well, I wasn't proposing the whole page, just the header. That would be
> significantly cheaper (in fact, there's no real need even for a CRC;
> probably just xoring all of the words in the header into one word would
> be fine) and would tell you if the pa
On Tue, 18 Feb 2003, Tom Lane wrote:
> The header is only a dozen or two bytes long, so torn-page syndrome
> won't result in header corruption.
No. But the checksum would detect both header corruption and torn pages.
Two for the price of one. But I don't think it's worth changing the page
layout
Added to TODO:
* Allow CIDR format to be used in pg_hba.conf
---
Kurt Roeckx wrote:
> Currently in pg_hba.conf you specify the ip addresses that can
> connect with 2 fields: the ip address and the mask.
>
> What d
Can this improvement get merged up into CVS current, or did you already
do that Tom?
---
Tatsuo Ishii wrote:
> > Nice work, Tatsuo! Wade, can you confirm that this patch solves your
> > problem?
> >
> > Tatsuo, please commi
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> The database encoding is set to the encoding when the database was
> created and the default value of the client encoding is set to same as
> the database encoding. This behavior will not be changed by the change
> I proposed.
As long as it still behaves
Christopher Kings-Lynne wrote:
> > If you don't have a primary key already, create a unique index on the
> > combination you want to be unique. Then:
> >
> > . Try to insert the record
> > . If you get a duplicate key error
> > then do update instead
> >
> > No possibilities of duplicate records
Tom Lane wrote:
> mlw <[EMAIL PROTECTED]> writes:
> > If no hba_conf and/or ident_conf setting is specified, the default
> > $PGDATA/pg_hba.conf and/or $PGDATA/pg_ident.conf will be used.
>
> Doesn't anybody see the (a) inconsistency and (b) uselessness of this?
> If you are trying to keep your co
mlw wrote:
> I don't like the idea of specifying a directory, per se' because if you
> have multiple database installations, how would you share the
> configuration without symlinks?
Oh, for example, you would be sharing postgresql.conf, perhaps, but not
pg_hba.conf.
--
Bruce Momjian
Bruce Momjian wrote:
mlw wrote:
I don't like the idea of specifying a directory, per se' because if you
have multiple database installations, how would you share the
configuration without symlinks?
Oh, for example, you would be sharing postgresql.conf, perhaps, but not
pg_hba.conf.
This is a patch that allows PostgreSQL to use a configuration
file that is outside the main database directory.
It adds one more command line parameter, "-C" which
specifies either the location of the postgres configuration
file or a directory containing the configuration files.
A patched version
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
Oleg Bartunov wrote:
> Bruce,
>
> we jus
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Can this improvement get merged up into CVS current, or did you already
> do that Tom?
It's irrelevant to current.
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I didn't think pgstattuple had proper visibility checks.
It doesn't, see followup discussion.
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I am not sure about this patch. First, src/bin/pg_dump/po/pt_BR.po
isn't in CVS anymore. Seems we don't have a Portugese translation file
anymore for this. As far as Kerberos, you are the first to mention
those additional libraries. Perhaps something for LIBS in
Makefile.global would fix this,
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
Teodor Sigaev wrote:
> Please apply patch
People seemed to like the idea:
Add a script to ask system configuration questions and tune
postgresql.conf.
---
Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > Tom Lane writes:
> >
> > > Well, as I com
Would it be possible to create some sort of transparent API based on ODBC to
be used with PostgreSQL and Oracle? I know there exists a JDBC - ODBC bridge
for java.
Martin
- Original Message -
From: "Hannu Krosing" <[EMAIL PROTECTED]>
To: "Martin Matusiak" <[EMAIL PROTECTED]>
Cc: <[EMAIL
Have you read the README file in storage/lmgr/README?
---
Sumaira Ali wrote:
[ text/html is unsupported, treating like TEXT/PLAIN ]
> hi, does anyone know what lockmethod means
>in the lock.h file and whats the use of lock
My 3rd attempt to post ...
Consider this query on a large table with lots of different IDs:
SELECT id FROM my_table GROUP BY id ORDER BY count(id) LIMIT 10;
It has an index on id. Obviously, the index helps to evaluate count(id)
for a given value of id, but count()s for all the `id's shoul
Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > On Mon, 17 Feb 2003, Tom Lane wrote:
> >> Postgres has a bad habit of becoming very confused if the page header of
> >> a page on disk has become corrupted.
>
> > What typically causes this corruption?
>
> Well, I'd like to know that
Added to TODO:
* Allow WAL information to recover corrupted pg_controldata
---
Curt Sampson wrote:
> On Fri, 14 Feb 2003, Bruce Momjian wrote:
>
> > Is there a TODO here, like "Allow recovery from corrupt pg_contro
On Tue, 18 Feb 2003, Bruce Momjian wrote:
>
> Added to TODO:
>
> * Allow WAL information to recover corrupted pg_controldata
>...
> > Using pg_control to get the checkpoint position speeds up the
> > recovery process, but to handle possible corruption of pg_control,
> > we sho
59 matches
Mail list logo