Re: [BUGS] BUG #4834: "pg_ctl stop -m fast" fails to stop database

2009-06-02 Thread Tom Lane
"Aleksey Tsalolikhin" writes: > "pg_ctl stop -m fast" fails to stop database when idle clients are > connected. It fails to disconnect the idle clients. It works for me. Can you provide a reproducible test case? regards, tom lane -- Sent via pgsql-bugs mailing list (p

[BUGS] BUG #4834: "pg_ctl stop -m fast" fails to stop database

2009-06-02 Thread Aleksey Tsalolikhin
The following bug has been logged online: Bug reference: 4834 Logged by: Aleksey Tsalolikhin Email address: aleksey.tsalolik...@gmail.com PostgreSQL version: 8.3.7 Operating system: CentOS 5.2 Description:"pg_ctl stop -m fast" fails to stop database Details: "pg_ctl

Re: [BUGS] BUG #4809: Missing Expected Operator

2009-06-02 Thread Bruce Momjian
Paul Matthews wrote: > > The following bug has been logged online: > > Bug reference: 4809 > Logged by: Paul Matthews > Email address: p...@netspace.net.au > PostgreSQL version: 8.3.7 > Operating system: Linux OpenSuse 11.0 > Description:Missing Expected Operator > De

Re: [BUGS] Delayed Write Failed

2009-06-02 Thread John R Pierce
mcronix wrote: Hi First time poster and complete postgres noob. I basically only ever use it along side an online poker database program, Holdem manager - I've been running postgres 8.2 with HEM for ages now, with no problems, when earlier today I had a window popup from the task bar saying Delay

Re: [BUGS] Delayed Write Failed

2009-06-02 Thread Dave Page
On Tue, Jun 2, 2009 at 4:45 PM, mcronix wrote: > > Hi > First time poster and complete postgres noob. I basically only ever use it > along side an online poker database program, Holdem manager - I've been > running postgres 8.2 with HEM for ages now, with no problems, when earlier > today I had a

[BUGS] Delayed Write Failed

2009-06-02 Thread mcronix
Hi First time poster and complete postgres noob. I basically only ever use it along side an online poker database program, Holdem manager - I've been running postgres 8.2 with HEM for ages now, with no problems, when earlier today I had a window popup from the task bar saying Delayed Write Failed,

Re: [BUGS] Re: 42804: structure of query does not match error where using RETURN QUERY

2009-06-02 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> [ experiments... ] Hmm, looks like RETURN QUERY isn't too bright about >> dropped columns in the function result type. I'm not too sure about how >> hard this is to fix, but in the meantime you will need to dump and >> recreate/reload that particular ta

Re: [BUGS] Re: 42804: structure of query does not match error where using RETURN QUERY

2009-06-02 Thread Bruce Momjian
Tom Lane wrote: > Michal Szymanski writes: > >> Exactly what modifications did you make? > > > We have added few new columns and we delete one column. > > [ experiments... ] Hmm, looks like RETURN QUERY isn't too bright about > dropped columns in the function result type. I'm not too sure abou

Re: [BUGS] failed to run initdb: 255!

2009-06-02 Thread Dave Page
On Tue, Jun 2, 2009 at 9:21 AM, tolszak wrote: > > I used enterprisedb installer for PostgreSql beta 2 8.4 and encounter > similar behaviour. Please try the test build from http://developer.pgadmin.org/~dpage/postgresql-8.4.0-1b2-windows.exe. It should resolve the permissions errors and errors r

Re: [BUGS] BUG #4833: Can't start service

2009-06-02 Thread Massa, Harald Armin
Jacek, please check the contents of the application message log in eventviewer. Also check if there is a new postgresql-log file written, and if yes, the contents. Usually they are below data/pg_log. To diagnose further, we need those information, best wishes, Harald On Tue, Jun 2, 2009 at 10

Re: [BUGS] failed to run initdb: 255!

2009-06-02 Thread tolszak
WarrenDLC wrote: > > Yes I am > > I used enterprisedb installer for PostgreSql beta 2 8.4 and encounter similar behaviour. I used msi installers from http://www.postgresql.org/ftp/binary/ http://www.postgresql.org/ftp/binary/ and it worked fine. I think EnterpriseDb installer couldn't sta

Re: [BUGS] failed to run initdb: 255!

2009-06-02 Thread WarrenDLC
Well, i'm currently using Vista home premium. I've actually tried the MSI's from the link you've sent. the same problems occur. tolszak wrote: > > > > WarrenDLC wrote: >> >> Yes I am >> >> > I used enterprisedb installer for PostgreSql beta 2 8.4 and encounter > similar behaviour. > I use

[BUGS] BUG #4833: Can't start service

2009-06-02 Thread Jacek
The following bug has been logged online: Bug reference: 4833 Logged by: Jacek Email address: jkacpr...@op.pl PostgreSQL version: 8.2.4 Operating system: Win XP Home Description:Can't start service Details: hi, I have following problem Yesterday postgres was workin

Re: [BUGS] failed to run initdb: 255!

2009-06-02 Thread WarrenDLC
Yes I am tolszak wrote: > > > WarrenDLC wrote: >> >> I've been running the installation and when it comes to initialize the >> first database cluster, initdb freezes and closes. the install continues >> with a "non fatal" error, but the installation does not work correctly. >> I have removed

Re: [BUGS] failed to run initdb: 255!

2009-06-02 Thread tolszak
WarrenDLC wrote: > > I've been running the installation and when it comes to initialize the > first database cluster, initdb freezes and closes. the install continues > with a "non fatal" error, but the installation does not work correctly. > I have removed old users using net user delete > I h