Tom Lane wrote:
"Jimmie H. Apsey" <[EMAIL PROTECTED]> writes:
At this point, I am unable to do a pg_dump using our new Rec Hat
Enterprise Linux AS 4 version of Postgres which is version 7.4.
Here's what I get when I try to do a pg_dump of our database:
[
This may be my second posting but I think I've done it correctly this time.
At this point, I am unable to do a pg_dump using our new Rec Hat
Enterprise Linux AS 4 version of Postgres which is version 7.4.
Here's what I get when I try to do a pg_dump of our database:
---
I cannot do a /usr/bin/pgdump with my new Postgres 7.4. When I try,
here is what I get:
---
[ ~]$ /usr/bin/pg_dump dcf_20050404 >&
/home/japsey/DCF_RAID_01/source/sql/backup/bu/dcf_200
are often 'stupid' and you will soon
see my contribution.
Thank you,
Jim Apsey
---
Tom Lane wrote:
"Jimmie H. Apsey" <[EMAIL PROTECTED]> writes:
On the 'old' Red Hat AS 2.1 here is the results of explain and the query:
The major proble
[ ~]$
Where do I go to get clues about the results of "explain"?
Jim Apsey
Dann Corbit wrote:
I assume that the schema is identical on both systems.
After running vacuum on both systems [for each of the underlying tables
in tpv], what does explain say about the queries?
Are the shared m
n the 'new' system.
Jim Apsey
--
Dann Corbit wrote:
-----Original Message-
From: Jimmie H. Apsey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 14, 2004 1:18 PM
To: Dann
Hello all,
I have just loaded Postgresql 7.3.6-7 onto a new server on the
recommendation of Tom Lane. It is part of Red Hat AS 3.
I have Postgresql 7.1.3-5 running on Red Hat AS 2.1.
I have a simple view from which I select on both systems. The 7.3.6-7
version requires 18+ seconds to do a selec
When
I tried to subscribe I got:
Not Found
The requested URL /mj/mj_wwwusr was not found on this server.
Apache/1.3.33 Server at webmail.anachronic.net Port 80
Thank you,
Jim Apsey
I got a server from DELL which contained a Red Hat Linux AS 3 in the
box.
It contained no postgresql server which I got from an earlier link, http://archives.postgresql.org/pgsql-admin/2003-11/msg00368.php
When I did rpm of everything I end up with a non-working postgresql.
This may be becaus
Tom Lane wrote:
"Geisler, Jim" <[EMAIL PROTECTED]> writes:
So, as far as I know, PostgreSQL does not have any way of verifying the loss
of referential integrity.
What are you trying to accomplish here, and in what PG version?
Are you trying to check that PG thinks that
Geisler, Jim wrote:
Message
So, as far as I know, PostgreSQL does not have any way of
verifying the loss of referential integrity.
Are there any recommended methods or utilities for checking
referential integrity in a PostgreSQL database?
Of course, Tom Lane suggested I lo
Tom Lane wrote:
"Jimmie H. Apsey" <[EMAIL PROTECTED]> writes:
Each FK constraint should have three associated triggers (two on the
referencing table, one on the referenced table).
OH, that's very scary for me that t
Tom Lane wrote:
"Jimmie H. Apsey" <[EMAIL PROTECTED]> writes:
Referential Integrity on one of our production tables seems to have been
lost. I am running Postgres 7.1.3 embedded within Red Hat
kernel-2.4.9-e.49.
7.1 is mighty ancient, but ...
Referential Integrity on one of our production tables seems to have been
lost. I am running Postgres 7.1.3 embedded within Red Hat
kernel-2.4.9-e.49.
Within that I have a table with referential integrity constraints which
no longer work.
I do not know how to disable referential integrity on a
Why would you want to do that?
Why not do it an easier way and dump the database and restore it into
your new database?
There's got to be a lot of stuff to consider when doing something as
radical as renaming a database.
I am a developer of dental computer systems using Postgres within Red
Ha
I could not select from pg_catalog. Is it called something else in
Postgres 7.1.3?
Postgres 7.1.3 is included in RED HAT ADVANCED SERVER 2.1 which I am using.
Jim Apsey
[EMAIL PROTECTED] wrote:
This is an a view I have found somewhat useful in helping partially
automate definition of functions d
16 matches
Mail list logo