Re: [BUGS] BUG #3126: Kernel audit Problem
Balaji.S wrote:
>
> The following bug has been logged online:
>
> Bug reference: 3126
> Logged by: Balaji.S
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 7.4.8-1
> Operating system: Red Hat Enterprise Linux ES release 4 (Nahant Update 3)
> Description:Kernel audit Problem
> Details:
>
> Completed the RHEL installation after reboot Postgresql Service is not
> started.I am starting service Postgresql using (service postgresql start)
> command
> i am receiving this error message on the screen(ie.
>
> Jan 7 07:20:23 corems kernel: audit(1010368223.881:0): avc: denied { read
> } for pid=3634 exe=/usr/bin/postgres path=/tmp/sh-thd-1010339898 (deleted)
> dev=hda1 ino=64169 scontext=user_u:system_r:postgresql_t
> tcontext=user_u:object_r:tmp_t tclass=file
This is a SELinux misconfiguration problem.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Re: [BUGS] BUG #3126: Kernel audit Problem
"Balaji.S" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 7.4.8-1 > Operating system: Red Hat Enterprise Linux ES release 4 (Nahant Update 3) > Description:Kernel audit Problem 7.4.8-1 is quite old, and I suspect your selinux-policy package is too. You need some combination of these actions: * update to a current Postgres package * update to a current selinux-policy package * run restorecon on the postgres files to get them labeled properly according to the updated policy * re-initdb, if you were bit by https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=149237 regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[BUGS] BUG #3131: on win pg_connect() is very slow
The following bug has been logged online: Bug reference: 3131 Logged by: dall Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: win Description:on win pg_connect() is very slow Details: System: windows xp, PHP5.1.6, postgresql 8.2 - home pc When I call pg_connect() its 12x slower than on *nix servers.I think its postgreSQL falt not PHP. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[BUGS] alter column type (from timestamp to date) violates not null
Hi!
When change a column type from timestamp to date, the 'infinity' and '-
infinity' values will be NULL. Even if the column has a not null
constraint.
Sorry, if it is a duplicated bug report.
Regards,
psmith
Here is the test procedure:
proba2=# create table a(t timestamp not null);
CREATE TABLE
proba2=# insert into a values ('infinity');
INSERT 0 1
proba2=# SELECT * from a;
t
--
infinity
(1 sor)
proba2=# alter table a alter t type date;
ALTER TABLE
proba2=# SELECT *, t is null as is_null from a;
t | is_null
---+-
| t
(1 sor)
proba2=# \d a
Tábla "public.a"
Oszlop | Típus | Módosító
+---+--
t | date | not null
proba2=# select version();
version
--
PostgreSQL 8.1.0 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
20051023 (prerelease) (Debian 4.0.2-3)
(1 sor)
proba2=# select 'infinity'::timestamp::date is null;
?column?
--
t
(1 sor)
---(end of broadcast)---
TIP 6: explain analyze is your friend
[BUGS] BUG #3127: Error IN initdb On Installation
The following bug has been logged online: Bug reference: 3127 Logged by: Abbas Ansaripoor Email address: [EMAIL PROTECTED] PostgreSQL version: postgresql-8.2. Operating system: Windows Server 2003 Enterprize SP1 Description:Error IN initdb On Installation Details: The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory D:/Program Files/PostgreSQL/8.2/data ... ok creating subdirectories ... ok selecting default max_connections ... '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. 10 selecting default shared_buffers/max_fsm_pages ... '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. '1' is not recognized as an internal or external command, operable program or batch file. 400kB/2 creating configuration files ... ok creating template1 database in D:/Program Files/PostgreSQL/8.2/data/base/1 ... '1' is not recognized as an internal or external command, operable program or batch file. child process exited with exit code 1 initdb: removing contents of data directory "D:/Program Files/PostgreSQL/8.2/data" ---(end of broadcast)--- TIP 6: explain analyze is your friend
[BUGS] BUG #3132: I don't access to DB
The following bug has been logged online: Bug reference: 3132 Logged by: Duilio Andre Chavez Cuarite Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Linux Centos 4 Description:I don't access to DB Details: Hi I am not to access Database of the postgresql, I am view this message You do not have access to any databases. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
