[BUGS] Postgresql installation on P2020 board
Hi, im trying to install postgresql8.4 in P2020 board . when i try to start postgresql im facing the follwing error. [postg...@p2020ds /]$ initdb -D /usr/local/data/ 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. The default database encoding has accordingly been set to SQL_ASCII. The default text search configuration will be set to "english". fixing permissions on existing directory /usr/local/data ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 28MB creating configuration files ... ok creating template1 database in /usr/local/data/base/1 ... FATAL: only sys attr supported in caches is OID PANIC: cannot abort transaction 1, it was already committed child process was terminated by signal 6: Aborted initdb: removing contents of data directory "/usr/local/data" Please help me to solve this problem. Thanks&Regards Tamilselvam.M Software Engineer Product Engineering Services L&T Infotech ,Chennai - 600 089 --- Tel:044-22535789 ;Extn:5789 ;Mob:9884671873 Mail - tamilselva...@lntinfotech.com This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system. __
Re: [BUGS] BUG #5669: server process was terminated by exception 0xC0000005
On Wed, Sep 22, 2010 at 9:04 PM, Tom Lane wrote: > Robert Haas writes: >> Can SHOW return a NULL value, rather than the empty string? > > I think that would take some work in guc.c, and likely a redefinition > of the API for show-hook functions. I'm not excited about doing it, > particularly not in a bug fix that needs to be back-patched. OK. Yeah, that doesn't seem worth it. It was just a thought. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Postgresql installation on P2020 board
TamilSelvam M writes: > im trying to install postgresql8.4 in P2020 board . > when i try to start postgresql im facing the follwing error. > creating template1 database in /usr/local/data/base/1 ... FATAL: only sys > attr supported in caches is OID Offhand I'd guess you have a compiler bug to deal with. As a short-term workaround, you might be able to avoid it by reducing the optimization level you compile Postgres with. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] installer problems
Hi, I'm having problems installing the database, see: anfitrite:/opt# ./postgresql-9.0.0-1-linux.bin Error: Error running /tmp/postgresql_installer/getlocales : child killed: floating-point exception Press [Enter] to continue : anfitrite:/opt# anfitrite:/opt# uname -a Linux anfitrite 2.6.18-6-686 #1 SMP Fri Feb 19 23:40:03 UTC 2010 i686 GNU/Linux anfitrite:/opt# cat /etc/debian_version 4.0 Thanks. Samuel rett...@gmail.com
[BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results
The following bug has been logged online:
Bug reference: 5673
Logged by: David Schmitt
Email address: da...@dasz.at
PostgreSQL version: 8.4.4
Operating system: Windows 7
Description:Optimizer creates strange execution plan leading to
wrong results
Details:
Background: The following statement is a slightly modfied version of a
statement created by the Entity Framework OR-Mapper when doing a specific
query involving the DefaultPropertyValues base class and the three child
classes CurrentDateTimeDefaultValues, NewGuidDefaultValues,
EnumDefaultValues. There are 60 unique rows in DefaultProperty Values, each
of which is referenced by exactly one row in either
CurrentDateTimeDefaultValues(5 rows), NewGuidDefaultValues(54 rows), or
EnumDefaultValues (1 row). All tables have an ID column and appropriate
PK/FK constraints modeling the inheritance.
Analysis: In the first case the optimizer creates a single Append operation
for the three sequential table scans (lines 10-13) and creates an additional
Index Scan on EnumDefaultValues (lines 14,15) which results in 61 rows
returned in 09. Particularily suspicious are the tow references to the
Extent5 alias on lines 13 and 14. In the second run, I dropped the primary
key on EnumDefaultValues. Now the Append on line 09 returns 60 rows and the
execution plan references EnumDefaultValues only once.
select *
from "dbo"."DefaultPropertyValues" AS "Extent1"
INNER JOIN "dbo"."DefaultPropertyValues" AS "Extent2" ON
"Extent1"."ID"="Extent2"."ID"
LEFT JOIN (
SELECT "UnionAll1"."ID" AS "C1","UnionAll1"."C1" AS
"C2","UnionAll1"."C2"
AS "C3","UnionAll1"."C3" AS "C4","UnionAll1"."C4" AS "fk_EnumVal" FROM (
SELECT "Extent3"."ID" AS "ID",TRUE AS "C1",FALSE AS
"C2",FALSE AS
"C3",CAST (NULL AS int4) AS "C4"
FROM "dbo"."CurrentDateTimeDefaultValues" AS
"Extent3"
UNION ALL
SELECT "Extent4"."ID" AS "ID", TRUE AS "C1",FALSE AS
"C2",TRUE AS
"C3",CAST (NULL AS int4) AS "C4"
FROM "dbo"."NewGuidDefaultValues" AS "Extent4")
AS "UnionAll1"
UNION ALL
SELECT "Extent5"."ID" AS "ID",FALSE AS "C1",TRUE AS "C2",FALSE
AS
"C3","Extent5"."fk_EnumValue" AS "fk_EnumValue"
FROM "dbo"."EnumDefaultValues" AS "Extent5") AS
"UnionAll2"
ON "Extent2"."ID"="UnionAll2"."C1"
WHERE ("Extent1"."fk_Property" IS NOT NULL ) AND ("Extent1"."fk_Property"=
(((783
Result:
60;"2010-09-20 13:22:17.773308";"2010-09-20
13:22:17.773308";"ecbd6901-13e8-4beb-a6a2-0548eba345a8";;;783;60;"2010-09-20
13:22:17.773308";"2010-09-20
13:22:17.773308";"ecbd6901-13e8-4beb-a6a2-0548eba345a8";;;783;60;f;t;f;3
60;"2010-09-20 13:22:17.773308";"2010-09-20
13:22:17.773308";"ecbd6901-13e8-4beb-a6a2-0548eba345a8";;;783;60;"2010-09-20
13:22:17.773308";"2010-09-20
13:22:17.773308";"ecbd6901-13e8-4beb-a6a2-0548eba345a8";;;783;60;f;t;f;3
EXPLAIN ANALYZE:
01 "Nested Loop Left Join (cost=1.76..7.42 rows=1 width=100) (actual
time=0.121..0.134 rows=2 loops=1)"
02 " Join Filter: ("Extent2"."ID" = "Extent3"."ID")"
03 " -> Hash Join (cost=1.76..3.60 rows=1 width=96) (actual
time=0.061..0.061 rows=1 loops=1)"
04 "Hash Cond: ("Extent2"."ID" = "Extent1"."ID")"
05 "-> Seq Scan on "DefaultPropertyValues" "Extent2"
(cost=0.00..1.60 rows=60 width=48) (actual time=0.008..0.013 rows=60
loops=1)"
06 "-> Hash (cost=1.75..1.75 rows=1 width=48) (actual
time=0.025..0.025 rows=1 loops=1)"
07 " -> Seq Scan on "DefaultPropertyValues" "Extent1"
(cost=0.00..1.75 rows=1 width=48) (actual time=0.023..0.024 rows=1
loops=1)"
08 "Filter: (("fk_Property" IS NOT NULL) AND
("fk_Property" = 783))"
09 " -> Append (cost=0.00..4.07 rows=61 width=11) (actual
time=0.005..0.046 rows=61 loops=1)"
10 "-> Append (cost=0.00..3.60 rows=60 width=11) (actual
time=0.004..0.028 rows=60 loops=1)"
11 " -> Seq Scan on "CurrentDateTimeDefaultValues" "Extent3"
(cost=0.00..1.05 rows=5 width=11) (actual time=0.004..0.005 rows=5
loops=1)"
12 " -> Seq Scan on "NewGuidDefaultValues" "Extent4"
(cost=0.00..1.54 rows=54 width=11) (actual time=0.002..0.014 rows=54
loops=1)"
13 " -> Seq Scan on "EnumDefaultValues" "Extent5"
(cost=0.00..1.01 rows=1 width=11) (actual time=0.002..0.002 rows=1
loops=1)"
14 "-> Index Scan using "PK_[zbox].[dbo].[EnumDefaultValues]" on
"EnumDefaultValues" "Extent5" (cost=0.00..0.47 rows=1 width=11) (actual
time=0.009..0.010 rows=1 loops=1)"
15 " Index Cond: ("Extent2"."ID" = "Extent5"."ID")"
16 "Total runtime: 0.258 ms"
Result:
60;"2010-09-20 13:22:17.773308";"2010-09-20
13:22:17.773308";"ecbd6901-13e8-4beb-a6a2-0548eba345a8";;;783;60;"2010-09-20
13:22:17.773308";"2010-09-20
13:22:17.773308";"ecbd6901-13e8-4beb-a6a2-0548eba345a8";;;783;60;f;t;f;3
EXPLAIN ANAL
Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results
"David Schmitt" writes: > Description:Optimizer creates strange execution plan leading to > wrong results Please supply a self-contained example demonstrating the incorrect results. The information you've provided is completely inadequate for investigating this problem report. A SQL script that creates some test tables and executes a query that gives wrong answers would be helpful. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] installer problems
On Thu, Sep 23, 2010 at 3:19 PM, Samuel Rettore wrote: > Hi, > > I'm having problems installing the database, see: > > anfitrite:/opt# ./postgresql-9.0.0-1-linux.bin > > Error: Error running /tmp/postgresql_installer/getlocales : child killed: > floating-point exception > Press [Enter] to continue : > anfitrite:/opt# > > > anfitrite:/opt# uname -a > Linux anfitrite 2.6.18-6-686 #1 SMP Fri Feb 19 23:40:03 UTC 2010 i686 > GNU/Linux > > anfitrite:/opt# cat /etc/debian_version > 4.0 Debian is not a supported platform for the installers - we don't see enough demand for it to justify the testing requirements I'm afraid. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Postgresql installation on P2020 board
Excerpts from TamilSelvam M's message of jue sep 23 02:08:05 -0400 2010: > creating template1 database in /usr/local/data/base/1 ... FATAL: only sys > attr supported in caches is OID > PANIC: cannot abort transaction 1, it was already committed > child process was terminated by signal 6: Aborted > initdb: removing contents of data directory "/usr/local/data" What kind of operating system is it running? One would think that if it's like a regular *nix, it shouldn't emit this kind of error. Maybe it's a compiler bug of some sort. I think you need to trace the boostrapping process to see what's it trying to do. -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] libpq: system-wide root.crt
Magnus Hagander writes: > On Thu, Aug 19, 2010 at 23:11, Martin Pitt wrote: >>> I received a request to support system-wide root certificates in >>> libpq. > I wonder if we want to have a default value for this rather than > disabling it when it's not specified by configure. But is there any > kind of reasonable default that's not going to be > platform/distribution specific? Given the potential security issues, I would argue very strenuously that this should NOT be enabled by default. It should happen only if the option is requested at configure time, and configure should be told the exact path where to look for certs. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results
On 9/23/2010 5:33 PM, Tom Lane wrote:
"David Schmitt" writes:
Description:Optimizer creates strange execution plan leading to
wrong results
Please supply a self-contained example demonstrating the incorrect results.
The information you've provided is completely inadequate for
investigating this problem report. A SQL script that creates some test
tables and executes a query that gives wrong answers would be helpful.
Executing the attached example.sql on a fresh database demonstrates the
problem I'm seeing:
postg...@db:~$ dropdb test; createdb test; psql test < example.sql
[load dump]
[execute query]
ID | CreatedOn | ChangedOn |
ExportGuid | fk_CreatedBy | fk_ChangedBy | fk_Property | ID |
CreatedOn | ChangedOn | ExportGuid
| fk_CreatedBy | fk_ChangedBy | fk_Property | C1 | C2 | C3 | C4 |
fk_EnumVal
+++--+--+--+-++++--+--+--+-+++++
60 | 2010-09-20 13:22:17.773308 | 2010-09-20 13:22:17.773308 |
ecbd6901-13e8-4beb-a6a2-0548eba345a8 | | |
783 | 60 | 2010-09-20 13:22:17.773308 | 2010-09-20 13:22:17.773308 |
ecbd6901-13e8-4beb-a6a2-0548eba345a8 | | |
783 | 60 | f | t | f | 3
60 | 2010-09-20 13:22:17.773308 | 2010-09-20 13:22:17.773308 |
ecbd6901-13e8-4beb-a6a2-0548eba345a8 | | |
783 | 60 | 2010-09-20 13:22:17.773308 | 2010-09-20 13:22:17.773308 |
ecbd6901-13e8-4beb-a6a2-0548eba345a8 | | |
783 | 60 | f | t | f | 3
(2 rows)
[remove pk]
[execute query again]
ALTER TABLE
ID | CreatedOn | ChangedOn |
ExportGuid | fk_CreatedBy | fk_ChangedBy | fk_Property | ID |
CreatedOn | ChangedOn | ExportGuid
| fk_CreatedBy | fk_ChangedBy | fk_Property | C1 | C2 | C3 | C4 |
fk_EnumVal
+++--+--+--+-++++--+--+--+-+++++
60 | 2010-09-20 13:22:17.773308 | 2010-09-20 13:22:17.773308 |
ecbd6901-13e8-4beb-a6a2-0548eba345a8 | | |
783 | 60 | 2010-09-20 13:22:17.773308 | 2010-09-20 13:22:17.773308 |
ecbd6901-13e8-4beb-a6a2-0548eba345a8 | | |
783 | 60 | f | t | f | 3
(1 row)
Hopefully, this helps you debugging it! Thanks for your time and work on
the otherwise really great PostgreSQL.
Best Regards, David
--
dasz.at OG Tel: +43 (0)664 2602670 Web: http://dasz.at
Klosterneuburg UID: ATU64260999
FB-Nr.: FN 309285 g FB-Gericht: LG Korneuburg
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET default_with_oids = false;
CREATE OR REPLACE FUNCTION uuid_generate_v4()
RETURNS uuid AS
'$libdir/uuid-ossp', 'uuid_generate_v4'
LANGUAGE 'c' VOLATILE STRICT
COST 1;
--
-- Name: CurrentDateTimeDefaultValues; Type: TABLE; Schema: dbo; Owner: zbox;
Tablespace:
--
CREATE TABLE "CurrentDateTimeDefaultValues" (
"ID" integer NOT NULL
);
--
-- Name: DefaultPropertyValues; Type: TABLE; Schema: dbo; Owner: zbox;
Tablespace:
--
CREATE TABLE "DefaultPropertyValues" (
"ID" integer NOT NULL,
"CreatedOn" timestamp without time zone,
"ChangedOn" timestamp without time zone,
"ExportGuid" uuid DEFAULT public.uuid_generate_v4() NOT NULL,
"fk_CreatedBy" integer,
"fk_ChangedBy" integer,
"fk_Property" integer NOT NULL
);
--
-- Name: DefaultPropertyValues_ID_seq; Type: SEQUENCE; Schema: dbo; Owner: zbox
--
CREATE SEQUENCE "DefaultPropertyValues_ID_seq"
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
--
-- Name: DefaultPropertyValues_ID_seq; Type: SEQUENCE OWNED BY; Schema: dbo;
Owner: zbox
--
ALTER SEQUENCE "DefaultPropertyValues_ID_seq" OWNED BY
"DefaultPropertyValues"."ID";
--
-- Name: DefaultPropertyValues_ID_seq; Type: SEQUENCE SET; Schema: dbo; Owner:
zbox
--
SELECT pg_catalog.setval('"DefaultPropertyValues_ID_seq"', 60, true);
--
-- Name: EnumDefaultValues; Type: TABLE; Schema: dbo; Owner: zbox; Tablespace:
--
CREATE TABL
Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results
David Schmitt writes: > On 9/23/2010 5:33 PM, Tom Lane wrote: >> Please supply a self-contained example demonstrating the incorrect results. > Executing the attached example.sql on a fresh database demonstrates the > problem I'm seeing: Yup, it sure does. Looking for the cause now. Thanks for the report! regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] Feature request - pg_dump - -W specify pwd in command line
Afternoon the 8.4 pg_dump seems to work fine and as documented. I need to be able to put pwds in the command line to facilitate non-supervised backups etc I tried the following command line but, understandably, it refuses to cooperate: pg_dump.exe -h localhost -p 5432 -U postgres -W tstpwd1 -t TRAN -t CLIENT -t ?CAS -F custom -b -Z 9 -f "C:\data\fidTcarl.sqlnative" fid2 -W tstpwd1 -W forces a password prompt, if I insert my 'test password' into the commandline instruction, it just terminates with a pg_dump: too many command-line arguments (first is "-t") blah is there another way to insert the pwd into the command line interface, please? Carl Carl Holliday t 012 342 3096 skysn...@wonderland.co.za -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results
David Schmitt writes: > Executing the attached example.sql on a fresh database demonstrates the > problem I'm seeing: Found it. If you need a patch right away, it's a one-liner: diff --git a/src/backend/optimizer/path/allpaths.c b/src/backend/optimizer/path/allpaths.c index 2d86da3..b7cf0b8 100644 --- a/src/backend/optimizer/path/allpaths.c +++ b/src/backend/optimizer/path/allpaths.c @@ -425,7 +425,7 @@ set_append_rel_pathlist(PlannerInfo *root, RelOptInfo *rel, childpath = childrel->cheapest_total_path; if (IsA(childpath, AppendPath)) subpaths = list_concat(subpaths, - ((AppendPath *) childpath)->subpaths); + list_copy(((AppendPath *) childpath)->subpaths)); else subpaths = lappend(subpaths, childpath); regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Feature request - pg_dump - -W specify pwd in command line
"Carl Holliday" writes: > I need to be able to put pwds in the command line to facilitate > non-supervised backups etc We intentionally do not allow passwords on the command line, because putting them there is a huge security hole. Use a ~/.pgpass file instead. See http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] UNLISTEN bug
Jeff Davis writes: > The bug is pretty simple: ProcessIncomingNotify() is called in a tight > loop in EnableNotifyInterrupt() while notifyInterruptOccurred is true. > EnableNotifyInterrupt() is assuming that ProcessIncomingNotify() will > unset it, but it has an early return that's triggered by my UNLISTEN. > Simply adding an additional "notifyInterruptOccurred = 0" in the early > return path (patch attached) seems to work. I added it there rather than > moving the whole line up, because I wasn't sure if it's safe to do that > before DisableCatchupInterrupt(). Hm. AFAICS just moving the flag reset up to the top is safe, and the cleanest way to fix it. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] libpq: system-wide root.crt
On tor, 2010-09-23 at 08:36 +0200, Magnus Hagander wrote: > I wonder if we want to have a default value for this rather than > disabling it when it's not specified by configure. But is there any > kind of reasonable default that's not going to be > platform/distribution specific? I would like for us to find a way to do it without configure options. Compiling in stuff is always weird. I'm thinking, libpq could really use a global (and, for that matter, a per-user) configuration file, where you could set defaults for some of the things that you currently have to use environment variables for, e.g., sslmode. And then you can configure the system-wide root.crt location there. Alternatively, if you think that that is overkill, then using an environment variable to configure this feature would be consistent with the existing mechanisms. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] installer problems
On tor, 2010-09-23 at 16:45 +0100, Dave Page wrote: > On Thu, Sep 23, 2010 at 3:19 PM, Samuel Rettore wrote: > > Hi, > > > > I'm having problems installing the database, see: > > > > anfitrite:/opt# ./postgresql-9.0.0-1-linux.bin > > > > Error: Error running /tmp/postgresql_installer/getlocales : child killed: > > floating-point exception > > Press [Enter] to continue : > > anfitrite:/opt# > > > > > > anfitrite:/opt# uname -a > > Linux anfitrite 2.6.18-6-686 #1 SMP Fri Feb 19 23:40:03 UTC 2010 i686 > > GNU/Linux > > > > anfitrite:/opt# cat /etc/debian_version > > 4.0 > > Debian is not a supported platform for the installers - we don't see > enough demand for it to justify the testing requirements I'm afraid. Surely the error message can be polished, though? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] installer problems
On Thu, Sep 23, 2010 at 11:46 PM, Peter Eisentraut wrote: > On tor, 2010-09-23 at 16:45 +0100, Dave Page wrote: >> On Thu, Sep 23, 2010 at 3:19 PM, Samuel Rettore wrote: >> > Hi, >> > >> > I'm having problems installing the database, see: >> > >> > anfitrite:/opt# ./postgresql-9.0.0-1-linux.bin >> > >> > Error: Error running /tmp/postgresql_installer/getlocales : child killed: >> > floating-point exception >> > Press [Enter] to continue : >> > anfitrite:/opt# >> > >> > >> > anfitrite:/opt# uname -a >> > Linux anfitrite 2.6.18-6-686 #1 SMP Fri Feb 19 23:40:03 UTC 2010 i686 >> > GNU/Linux >> > >> > anfitrite:/opt# cat /etc/debian_version >> > 4.0 >> >> Debian is not a supported platform for the installers - we don't see >> enough demand for it to justify the testing requirements I'm afraid. > > Surely the error message can be polished, though? Well we don't know what errors we might get on unsupported platforms until we test them, and we certainly don't have the resources to test every unsupported platform. It's hard enough to test the 40 or so we do support. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] installer problems
On tor, 2010-09-23 at 23:56 +0100, Dave Page wrote: > > Surely the error message can be polished, though? > > Well we don't know what errors we might get on unsupported platforms > until we test them, and we certainly don't have the resources to test > every unsupported platform. It's hard enough to test the 40 or so we > do support. I don't accept that argument, but FWIW, it works just fine on my Debian installation, so nothing to worry about. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #5674: initdb failed if path contains symlink
The following bug has been logged online: Bug reference: 5674 Logged by: Itagaki Takahiro Email address: itagaki.takah...@gmail.com PostgreSQL version: 9.0.0 (32bit) Operating system: Windows 7 (64bit) Description:initdb failed if path contains symlink Details: Windows 7 supports symbolic links like UNIX, but initdb cannot initialize a database cluster if the path (-D) contains symlinks. > mkdir D:\real > mklink /D D:\link D:\real > initdb -D D:\real\pgdata --encoding=UTF8 --locale=C => OK > initdb -D D:\link\pgdata2 --encoding=UTF8 --locale=C => could not create directory "D:/link": File exists -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
