Greetings!
It takes ages to drop a constraint from one of my tables
[ table details at the end ] I cannot insert into it also.
I know pg_dump is not running and no other query is accessing the
table.
Can anyone help me debugging this problem? Can anyone explain the
following entires in pg_
Hello
> Are there any Gentoo users here?
Yes, there are some :)
> Do you wish the PostgreSQL ebuild made use of SLOTS?
> - to allow installing of major versions together (eg. 7.3 and 7.4 on the
> same host)
> - to ease migration of databases to new major versions (where a
> dump/reload is r
Hello,
I could use some help in getting to know how triggers are to be made
exactly. Even with the documentation it is hard for me to understand all
of it...
maybe I think about it in a too complex manner, freezing my own brains...
But here it is:
I have a database that is about how ocomputers
On Thu, Feb 26, 2004 at 15:22:37 +0100,
Michiel Lange <[EMAIL PROTECTED]> wrote:
> But here it is:
> I have a database that is about how ocomputers and phones are connected
> in a patch panel.
> For that I have three tables:
> patches(patch_id(serial, pkey), location(varchar, unique));
> compute
"Barry" <[EMAIL PROTECTED]> writes:
> After running for a couple of days, my postgres server crashes.
Sounds to me like you are starting the postmaster under some resource
limit that it eventually exceeds. Check ulimit settings.
regards, tom lane
Title: Message
Dear
All:
I am trying to
restore a database (size is about 7GB) from a dump file created by a simple
backup script..The format is data.pg.
The schema restores
fine, but during the data restore, i get the following
error:
-bash-2.05b$
pg_restore -a -d access backups/ac
Hello folks.
Are there any Gentoo users here?
Do you wish the PostgreSQL ebuild made use of SLOTS?
- to allow installing of major versions together (eg. 7.3 and 7.4 on the
same host)
- to ease migration of databases to new major versions (where a
dump/reload is required)
I've started a thread
Dear Anjan Dave ,
Message
-bash-2.05b$
pg_restore -a -d access backups/access/data.pg
pg_restore:
[custom archiver] could not read data block -- expected 4096, got 3608
To me this seems as a error in file format.
Anyways try using the following
pg_restore
--disable-triggers -i -a
Is there a way to turn off the CLUSTER setting for a table?
I did a "CLUSTER index ON table" for a number of tables. Now I want to
do a raw CLUSTER command across the whole database, but I'd really like
to turn off the CLUSTER setting for one of the tables (because it takes
too long). I don't s
Jeff Boes <[EMAIL PROTECTED]> writes:
> Is there a way to turn off the CLUSTER setting for a table?
I think you'd just have to reach in and turn off the indisclustered
(sp?) flag in the appropriate row of pg_index.
regards, tom lane
---(end of broa
ÐÐÐ 23 ÐÑÑ 2004 00:57, Tom Lane ÐÐ ÑÐÐÐ:
> "www.mg.te.ua" <[EMAIL PROTECTED]> writes:
> > I have linux box under redhat linux 8.0 with original kernel 2.4.20
> > On this box I successfully build postgresql 7.3.4
> > After upgrading kernel to 2.4.24 i deside to upgrade postgresql.
> > I've succ
I am trying to set up pg_hba.conf for PostgreSQL 7.3. I want to limit
access to a database from a host to the set of users in a file. The
documentation suggests that this is done as follows:
host dbname @user_file 10.0.1.12 255.255.255.255 md5
However, the postmaster complains of a synt
Hi,
I am trying
to use postgresql 7.3.2 JDBC driver through a Java program on RedHat Linux 9.0.
But it's throwing an error.
How I should call
the postgresql data base through my Java program using JDBC
?
Any help would be
greatly appreciated.
Thanks &
Regards,
Kasi
Ph : 630-990-2681
I would like to create a user which has only read privilege, something like
"SELECT ANY TABLE"...
Any pointer or help is appreciated.
Louie Kwan
> Senior Systems Integrator
> NUVO - THE IT OUT-TASKING COMPANY
> (613) 726-5071Direct Line
> (613) 721-1399 Fax
>
---
Title: Message
To whom it may
concern:
I am trying to find
the command to execute against Postgres to determine how many open
statements/queries/updates there at a given time in order to verify my JDBC
statements are being closed.
Thanks,
Derek
Cisco
Systems
[EMAIL PROTECTED]
972-81
ÐÐÐ 23 ÐÑÑ 2004 16:45, Tom Lane ÐÐ ÑÐÐÐ:
> "www.mg.te.ua" <[EMAIL PROTECTED]> writes:
> > mkdir
> > /usr/src/pg-7.4.1/src/test/regress/./tmp_check/install/usr/local/pgsql2/m
> >an/man7 gzip -d -c ./postgres.tar.gz | ( cd
> > /usr/src/pg-7.4.1/src/test/regress/./tmp_check/install/usr/local/pgsql
Hi ,
I have been trying to look at ways to recover from any accidental deletes.
Reading some pevious posts , its clear that its possible since the
records are
just marked for delete and not actually deleted. Its deleted only after
a Vacuum
command is run .
I believe its possible to talk to back
Tom,
I only see this in pg_clog:
[EMAIL PROTECTED] data]# ls pg_clog/
No, I had not been running Vacuum on a regular interval. :( I just
added "vacuumdb --all" to my daily cron, though...
On Feb 22, 2004, at 6:04 PM, Tom Lane wrote:
"Bethany A.Benzur" <[EMAIL PROTECTED]> writes:
Argg... I g
Hello
I am building a server to run 9 databases. Can I run a seperate
postmaster for each of the 9 databases. I would be setting the port
number to a different value for each db of course. The reason I wish to
do this is so that I can install about three databases on a seperate
disk and put
<[EMAIL PROTECTED]> writes:
> I am trying to set up pg_hba.conf for PostgreSQL 7.3. I want to limit
> access to a database from a host to the set of users in a file. The
> documentation suggests that this is done as follows:
> host dbname @user_file 10.0.1.12 255.255.255.255 md5
> However
20 matches
Mail list logo
