Tom Lane escreveu:
Vinicius <[EMAIL PROTECTED]> writes:
I tryed to create another data dir because I don't have the template1
database.
I think you got bit by one of the early-FC3 selinux policy bugs; see
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=142607
https://bugzilla.redhat.com/bugz
Vinicius escreveu:
Tom Lane escreveu:
Vinicius <[EMAIL PROTECTED]> writes:
I tryed to create another data dir because I don't have the template1
database.
I think you got bit by one of the early-FC3 selinux policy bugs; see
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=142607
https://bugzi
Vinicius escreveu:
And I still don't get the template1 database.
Thanks.
I think the server must be running to create the template1 database. I'm
a newbie, sorry.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi All,
Have just installed a linux (red hat 9) version of postgreSQL (7.4.2)
and for some reason the database has no functions/operators/aggregates
that I have on a Windows BETA4 version.
Are these seperate installations or are they supposed to be standard
with the general installation.
Regards
This Error message was given when i was dropping the database.
There are idle connections to the database as seen from ps -ef | grep postgres
How can i drop the database with out restarting the postgres server.?.
FYI: i am dropping the database to perform restoration of this backup
database using
The DETAIL part is:-
DETAIL: Process 17593 waits for AccessExclusiveLock on relation
1571110842 of database 917916301; blocked by process 17868.
DETAIL: Process 25284 waits for AccessShareLock on relation
1613149934 of database 917916301; blocked by process 25010.
the deadlock was from the appl
Hi,
I need some help in bringing back this db please.
The partition ran out of space from an import process. I cleared up the space
and attempted to start the postgres service again, but it doesn't start and i
get following in the message log.
HINT: This probably means that some data is co
Vinicius <[EMAIL PROTECTED]> writes:
> /var/log/messages shows:
> "...
> Feb 21 09:10:43 ronin kernel: audit(1108987843.094:0): avc: denied {
> read } for pid=6766 exe=/usr/bin/postgres path=/tmp/sh-thd-1108997049
> (deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
> tconte
"Anjan Dave" <[EMAIL PROTECTED]> writes:
> The partition ran out of space from an import process. I cleared up the space
> and attempted to start the postgres service again, but it doesn't start and i
> get following in the message log.
> PANIC: could not access status of transaction 45514755
>
Tom,
You're the man!
I zeroed out the troubled pg_clog file and the db started up fine! Here's the
link to the discussion, and a detailed explanation of the issue by Tom:
http://groups-beta.google.com/group/comp.databases.postgresql.hackers/browse_thread/thread/c97c853f640b9ac1/d6bc3c75eed6c2
Emergency: I have a 200+ million row zip code radius table that has recently gone haywire.
I cannot access it and get the following error code
ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
My environment.
Postgresql 7.3.2
OS: Redhat Linux 7.2
Any ideas to fi
"Anjan Dave" <[EMAIL PROTECTED]> writes:
> Tom, is the issue resolved after 7.4.1?
Yes, that's why I told you to update.
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an app
Christopher Smith <[EMAIL PROTECTED]> writes:
> ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
This is a hardware failure: your disk drive has dropped some sectors.
I don't think you can do anything about it except go back to your last
backup :-(
Oh, and buy a new di
I've checked the mirrors and although there is a directory for x86 64
bit rpms, it's empty. Are there plans to build these any time soon?
Anyone point me to the latest srpms for 7.4.?
Thanks.
--
Until later, Geoffrey
---(end of broadcast)---
TIP 9:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 21 Feb 2005, Geoffrey wrote:
I've checked the mirrors and although there is a directory for x86 64 bit
rpms, it's empty. Are there plans to build these any time soon?
Yep there is(was), but we are not sure when we will build it...
BTW, nex
Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 21 Feb 2005, Geoffrey wrote:
I've checked the mirrors and although there is a directory for x86 64
bit rpms, it's empty. Are there plans to build these any time soon?
Yep there is(was), but we are not sure when we wil
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 21 Feb 2005, Geoffrey wrote:
Anyone point me to the latest srpms for 7.4.?
http://www.postgresql.org/ftp/binary/v7.4.7/srpms/redhat/rhel-es-3.0/
Can I build 64 bit from these, or do I need specific 64 bit srpms?
AFAIK, you can rebuild them u
Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 21 Feb 2005, Geoffrey wrote:
Anyone point me to the latest srpms for 7.4.?
http://www.postgresql.org/ftp/binary/v7.4.7/srpms/redhat/rhel-es-3.0/
Can I build 64 bit from these, or do I need specific 64 bit srpms?
AFAIK
Tom,
you are exactly CORRECT. One scsi down... crap!
Thanks for the support and quick response!
Tom Lane <[EMAIL PROTECTED]> wrote:
Christopher Smith <[EMAIL PROTECTED]>writes:> ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output errorThis is a hardware failure: your disk driv
Hi,
I've checked the mirrors and although there is a directory for x86 64 bit
rpms, it's empty. Are there plans to build these any time soon?
I should have built them. Sorry it took so long. Everything was delayed
because of some problems at work adn at home. I will try to catch up with
the RPM
Hi again,
I've checked the mirrors and although there is a directory for x86 64 bit
rpms, it's empty. Are there plans to build these any time soon?
I should have built them. Sorry it took so long. Everything was delayed
because of some problems at work adn at home. I will try to catch up with
t
Sander Steffann wrote:
Hi,
I've checked the mirrors and although there is a directory for x86 64
bit rpms, it's empty. Are there plans to build these any time soon?
I should have built them. Sorry it took so long. Everything was delayed
because of some problems at work adn at home. I will try t
Sander Steffann wrote:
Hi again,
I've checked the mirrors and although there is a directory for x86 64
bit rpms, it's empty. Are there plans to build these any time soon?
I should have built them. Sorry it took so long. Everything was
delayed because of some problems at work adn at home. I will
23 matches
Mail list logo
