[BUGS] backup using pg_dump postgreSQL 8.3.8

2011-03-09 Thread Sandy Test
We have postgreSQL 8.3.8 installed on a windows 8 server (64 bit). We want to be able to run a nightly backup using the pg_dump command. Unfortunately, even with the pg_hba.conf fix of adding host postgres ... trust, It still asks for a password. 1. Is this a 64bit issue? If the server w

Re: [BUGS] backup using pg_dump postgreSQL 8.3.8

2011-03-09 Thread Devrim GÜNDÜZ
On Wed, 2011-03-09 at 15:05 +0200, Sandy Test wrote: > > We want to be able to run a nightly backup using the pg_dump command. > > Unfortunately, even with the pg_hba.conf fix of adding host > postgres ... > trust, > > It still asks for a password. Please post this to pgsql-general or pgsql-a

[BUGS] BUG #5921: pg_dump asks for password

2011-03-09 Thread sandyt
The following bug has been logged online: Bug reference: 5921 Logged by: sandyt Email address: sa...@mcw.co.il PostgreSQL version: 8.3.8 Operating system: windows 2008 server (64 bit) Description:pg_dump asks for password Details: We want to be able to run a nightly

Re: [BUGS] CREATEROLE does not permit commenting on newly-created roles

2011-03-09 Thread Robert Haas
On Wed, Mar 9, 2011 at 12:45 AM, Tom Lane wrote: > How that gets boiled down into a release note will depend on whoever > writes the release notes. > >> along with the change you made for PLs. In 9.0, to comment on a procedural language, you must be superuser. But your recent commit changed it to

Re: [BUGS] CREATEROLE does not permit commenting on newly-created roles

2011-03-09 Thread Tom Lane
Robert Haas writes: > On Wed, Mar 9, 2011 at 12:45 AM, Tom Lane wrote: >>> along with the change you made for PLs. >> Huh? > In 9.0, to comment on a procedural language, you must be superuser. > But your recent commit changed it to check for language ownership. Oh. That's just a bug fix: it s

Re: [BUGS] CREATEROLE does not permit commenting on newly-created roles

2011-03-09 Thread Tom Lane
I wrote: > In particular, I suggest the attached patch (code-complete, but sans > documentation changes). Applied with doc fixes. I waited till after alpha4 was cut, though. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make change

[BUGS] Problem with installation

2011-03-09 Thread Igor Markovic
Hi, I've tried everyting to install PostgreSQL, but I just can't make it work. I've tried different versions, I've played with the settings of my firewall and did basicly everything I've seen on the internet to fix it. I'd like to ask if somebody can help me through teamviewer, cause I'm def

Re: [BUGS] BUG #5889: "Intersects" for polygons broken

2011-03-09 Thread Robert Haas
On Tue, Mar 8, 2011 at 3:20 PM, Konrad Garus wrote: > http://www.postgresql.org/docs/current/static/functions-geometry.html > > I wish it explained what arguments each of the operators accepts, and > whether any automatic conversions take place (like polygon to box in > that 8.3 issue). > > What h

Re: [BUGS] BUG #5707: Cross compilation for windows is broken

2011-03-09 Thread Bruce Momjian
Robert Haas wrote: > On Sat, Feb 26, 2011 at 2:14 AM, Bruce Momjian wrote: > > Has this been addressed? > > Not me. Sounds like no one cares enough to figure out how to do this. > Perhaps this should be a TODO. Agreed. TODO added: Fix cross-compiling on Windows *

Re: [BUGS] BUG #5921: pg_dump asks for password

2011-03-09 Thread Josh Kupershmidt
On Wed, Mar 9, 2011 at 9:04 AM, sandyt wrote: > > The following bug has been logged online: > > Bug reference:      5921 > Logged by:          sandyt > Email address:      sa...@mcw.co.il > PostgreSQL version: 8.3.8 > Operating system:   windows 2008 server (64 bit) > Description:        pg_dump a

[BUGS] BUG #5922: Add-on installation error.

2011-03-09 Thread Luke Gilbert
The following bug has been logged online: Bug reference: 5922 Logged by: Luke Gilbert Email address: luke.gilb...@navistar.com PostgreSQL version: 9.0 Operating system: Windows 7 Description:Add-on installation error. Details: Of all the lists, this seems to be be t

[BUGS] BUG #5923: Build problem

2011-03-09 Thread charles johnson
The following bug has been logged online: Bug reference: 5923 Logged by: charles johnson Email address: cjohn...@valverdecomputing.com PostgreSQL version: 9.1 alpha 4 Operating system: Windows 7 Description:Build problem Details: The build died straightaway in 8 sec

Re: [BUGS] BUG #5923: Build problem

2011-03-09 Thread Tom Lane
"charles johnson" writes: > Build started: Project: postgres, Configuration: Release|Win32 > Running bison on src\backend\replication\repl_gram.y > 1 file(s) copied. > Running flex on src\backend\replication\repl_scanner.l > flex: fatal internal error, exec failed You seem to ha

Re: [BUGS] BUG #5922: Add-on installation error.

2011-03-09 Thread Dave Page
On Thu, Mar 10, 2011 at 8:44 AM, Luke Gilbert wrote: > > The following bug has been logged online: > > Bug reference:      5922 > Logged by:          Luke Gilbert > Email address:      luke.gilb...@navistar.com > PostgreSQL version: 9.0 > Operating system:   Windows 7 > Description:        Add-on