Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-09-24 Thread Magnus Hagander
idea. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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 #8406: Postgresql 9.3 from OpenSCG dose not start automaticly when enalbled in system runlevel

2013-08-29 Thread Magnus Hagander
Description: Postgresql 9.3 from OpenSCG dose not start automaticly when enalbled in system runlevel. It must by started manualy. Hello! Bugs in the OpenSCG packaging should be reported to OpenSCG, to make sure they actually spot them and can fix it before the release. -- Magnus Hagander Me: http

Re: [BUGS] BUG #8397: pg_basebackup -x from new standby server sometimes causes Segmentation fault

2013-08-25 Thread Magnus Hagander
On Sun, Aug 25, 2013 at 9:05 AM, TAKATSUKA Haruka haru...@sraoss.co.jp wrote: Thanks for the response. On Sat, 24 Aug 2013 17:04:21 +0200 Magnus Hagander mag...@hagander.net wrote: (1) create new standby server dir by pg_basebackup without -x (2) start new standby server (3

Re: [BUGS] BUG #8397: pg_basebackup -x from new standby server sometimes causes Segmentation fault

2013-08-24 Thread Magnus Hagander
- since AFAICT this error gets thrown only after all the data has been sent arlready. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] yum repository

2013-07-08 Thread Magnus Hagander
longer than expected. We expect it to be up again fairly soon. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [BUGS] BUG #8241: submisson

2013-06-21 Thread Magnus Hagander
Hi! There was a bug in the website code caused by an upgrade. This was fixed yesterday, so please try again now. /Magnus On Jun 20, 2013 5:09 PM, luk...@novosoft.net wrote: The following bug has been logged on the website: Bug reference: 8241 Logged by: Oksana Email address:

Re: [BUGS] BUG #7852: TeamPostgresql is giving error

2013-02-05 Thread Magnus Hagander
On Feb 5, 2013 6:20 PM, yogesh.khandel...@emc.com wrote: The following bug has been logged on the website: Bug reference: 7852 Logged by: Yogesh Khandelwal Email address: yogesh.khandel...@emc.com PostgreSQL version: 9.0.8 Operating system: Linux Description: hi,

Re: [BUGS] BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

2013-01-25 Thread Magnus Hagander
On Sun, Jan 20, 2013 at 4:59 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: + PGresult *res = ExecuteSqlQueryForSingleRow(fout, SELECT pg_is_in_recovery()); That function call needs to be schema-qualified for security. Applied and backpatched

Re: [BUGS] BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

2013-01-20 Thread Magnus Hagander
On Tue, Jan 15, 2013 at 10:35 PM, Magnus Hagander mag...@hagander.net wrote: On Tue, Jan 15, 2013 at 12:13 AM, j...@tanga.com wrote: The following bug has been logged on the website: Bug reference: 7809 Logged by: Joe Van Dyk Email address: j...@tanga.com PostgreSQL

Re: [BUGS] BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

2013-01-15 Thread Magnus Hagander
of saying could not open file, could we find a way to say this is an unlogged table on a slave, it's not going to work? We can fix pg_dump the easy way, but what about custom tools... -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs

Re: [BUGS] BUG #7792: pg_dump does not treat -c flag correctly when using tar format

2013-01-07 Thread Magnus Hagander
that needs to be clarified in the documentation if people find it confusing. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [BUGS] BUG #7792: pg_dump does not treat -c flag correctly when using tar format

2013-01-07 Thread Magnus Hagander
On Mon, Jan 7, 2013 at 4:41 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Mon, Jan 7, 2013 at 1:32 AM, Tom Lane t...@sss.pgh.pa.us wrote: emes...@redhat.com writes: * restore.sql includes DROP statements for each object even tough -c flag was not given

Re: [BUGS] BUG #7767: pg_ctl allows postgres running under administrator's privilege

2012-12-29 Thread Magnus Hagander
access to any permissions received by being in the Administrators or Power Users group for example. You can verify it by for example attempting to COPY to a file that only administrators have access to (access must be granted through the group, of course) -- Magnus Hagander Me: http

Re: [BUGS] pg_basebackup fails if a data file is removed

2012-12-21 Thread Magnus Hagander
, by e.g doing a VACUUM FULL on the table about to be copied. A straightforward fix is to allow sendFile() to ignore ENOENT. Patch attached. Looks good to me. Nice spot - don't tell me you actually ran into it during testing? :) -- Magnus Hagander Me: http://www.hagander.net/ Work: http

Re: [BUGS] BUG #7744: docs should link to postgresql_psycopg2

2012-12-11 Thread Magnus Hagander
people, not us. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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] error

2012-12-11 Thread Magnus Hagander
, you need to use at least the same version as the one you created the dump with. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] Bug reporting form :-(

2012-11-07 Thread Magnus Hagander
fallout from a patch that went into the website codebase a few days ago. I'll look at getting it fixed in a few hours. Sorry about that! -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] BUG #7606: service restart failed

2012-10-16 Thread Magnus Hagander
what the reason for not starting is - which in this case is that PostgreSQL has no idea what listen_addresse is, since it's spelled wrong. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown

2012-09-12 Thread Magnus Hagander
?) Oh, and what do you actually mean by long time? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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 #7517: terminated by exception 0xC0000409

2012-09-04 Thread Magnus Hagander
of, but it's always a possible side-effect from something else - so it's always worth applying the latest patches. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription

Re: [BUGS] BUG #7490: documentation typo

2012-08-13 Thread Magnus Hagander
as listed, at least for me... -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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 #6722: Debugger broken?

2012-08-13 Thread Magnus Hagander
pushing merge commits, if that has been enabled. But there are no such rules enabled for the pldebugger one. Note of course, which you probably already know, that doing a force push may cause problems for others who have cloned the repository... -- Magnus Hagander Me: http://www.hagander.net

Re: [BUGS] Error on pg_settings.bytea_output for pg9.1

2012-08-07 Thread Magnus Hagander
try to keep the environment for the query tool connection as clean as possible. So if it's reasonably easy to do this (I haven't looked at the code, but I would assume it is), then I suggest doing that *and* backpatching it so it'll go into the next version of the stable branch. -- Magnus

Re: [BUGS] Meeting schedule

2012-07-03 Thread Magnus Hagander
my problem of installation. Thank you. I have no idea what HM2 is, but if you are a customer of theirs, it sounds like you should bring it up with them? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #6705: 32 bit

2012-06-27 Thread Magnus Hagander
On Jun 27, 2012 8:26 AM, Craig Ringer ring...@ringerc.id.au wrote: On 06/26/2012 06:26 PM, Dave Page wrote: Any ideas for a one-liner to add? I'm struggling to find nice wording, that doesn't invite people to report issues without investigating themselves first: * If you need help, please

Re: [BUGS] BUG #6705: 32 bit

2012-06-27 Thread Magnus Hagander
On Jun 27, 2012 8:42 AM, Craig Ringer ring...@ringerc.id.au wrote: On 06/27/2012 02:33 PM, Magnus Hagander wrote: ... where that provides the common-issues list, a pointer to look at the installation log, then a report template for cases where it wasn't one of the common quick-fixes. I'm

Re: [BUGS] pg_tablespace.spclocation column removed in 9.2

2012-06-25 Thread Magnus Hagander
couldn't deal with, because they simply can't know the future... --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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 #6689: socket file name convention doesn't allow different IPs and the same port for different pgclusters

2012-06-15 Thread Magnus Hagander
On Fri, Jun 15, 2012 at 7:33 PM, Mark Schneider m...@it-infrastrukturen.org wrote: Am 15.06.2012 07:56, schrieb Magnus Hagander: On Wed, Jun 13, 2012 at 2:45 AM,m...@it-infrastrukturen.org  wrote: The following bug has been logged on the website: Bug reference:      6689 Logged

Re: [BUGS] BUG #6689: socket file name convention doesn't allow different IPs and the same port for different pgclusters

2012-06-14 Thread Magnus Hagander
on different ports still. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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 #6687: initdb -A ident can almost never be correct

2012-06-11 Thread Magnus Hagander
, and what are you expecting to happen? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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 #6687: initdb -A ident can almost never be correct

2012-06-11 Thread Magnus Hagander
On Mon, Jun 11, 2012 at 6:01 PM, David Fetter da...@fetter.org wrote: On Mon, Jun 11, 2012 at 05:51:06PM +0200, Magnus Hagander wrote: On Mon, Jun 11, 2012 at 5:14 PM,  da...@fetter.org wrote: The following bug has been logged on the website: Bug reference:      6687 Logged

Re: [BUGS] BUG #6687: initdb -A ident can almost never be correct

2012-06-11 Thread Magnus Hagander
On Mon, Jun 11, 2012 at 6:14 PM, David Fetter da...@fetter.org wrote: On Mon, Jun 11, 2012 at 06:04:22PM +0200, Magnus Hagander wrote: On Mon, Jun 11, 2012 at 6:01 PM, David Fetter da...@fetter.org wrote: On Mon, Jun 11, 2012 at 05:51:06PM +0200, Magnus Hagander wrote: On Mon, Jun 11, 2012

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-24 Thread Magnus Hagander
/pg_upgrade.zip - please see if that one works for you. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-23 Thread Magnus Hagander
\pg_upgrade_utility.log       SUCCESS Offset: 396 Length: 16 183     3:48:01 p.m.    cmd.exe:99396   OPEN     C:\ccviews\pg_upgrade_utility.log       SHARING VIOLATION       Options: Open  Access: 0012019F We probably need to send these to different logfiles. Bruce? --  Magnus Hagander  Me: http

Re: [BUGS] log_collector doesn't respond to reloads

2012-04-28 Thread Magnus Hagander
it. I think process title seems reasonable. We do that for archiver for example, to tell you where it's writing, don't we? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #6502: Missing Link at Version Tracker

2012-03-04 Thread Magnus Hagander
This is clearly not a bug... I have no idea what Version Tracker is, or where you got that link from, but postgresql 9.0.1 is an out of date version. You can find downloads for all current versions at http://www.postgresql.org/download/. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http

Re: [BUGS] BUG #6502: Missing Link at Version Tracker

2012-03-04 Thread Magnus Hagander
for. //Magnus On Sun, Mar 4, 2012 at 14:02, Ronald Hofmann pro...@jumbosoft.de wrote: So you say 9.01 for 10.4 (from 2007) is current? No thank you, I chose MySql Regards --- Am 04.03.2012 um 12:44 schrieb Magnus Hagander mag...@hagander.net: On Fri, Mar 2, 2012 at 06:41,  pro...@jumbosoft.de

Re: [BUGS] Doc-bug; minor typo in auto_explain documentation

2012-01-27 Thread Magnus Hagander
better. Fix applied. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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 #6398: Your projects.postgresql.org site is down

2012-01-13 Thread Magnus Hagander
website is down (tried to visit the pgpool page), and I didn't know where else to report it. This is not a PostgreSQL bug. Please see threads on the pgsql-www mailinglist (archives.postgresql.org/pgsql-www). --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com

Re: [BUGS] BUG #6396: PgFoundry is down

2012-01-12 Thread Magnus Hagander
page PgFounfry id out. I want to download the npgsql, but I cannot. This is not a PostgreSQL bug. (It is known that pgfoundry is down - see the pgsql-www mailinglist where such issues are discussed) --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent

Re: [BUGS] BUG #6372: Error while creating database with fsync parameter as on incase of CIFS

2012-01-02 Thread Magnus Hagander
postgres_cifs_kaz_1[15812]: [2-2] [local] 15812 2011-12-30 03:00:26.511 PST STATEMENT:  CREATE DATABASE KazDB Please help to make it work. PostgreSQL does not support data directory over CIFS. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via

Re: [BUGS] BUG #6372: Error while creating database with fsync parameter as on incase of CIFS

2012-01-02 Thread Magnus Hagander
On Mon, Jan 2, 2012 at 21:14, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Mon, Jan 2, 2012 at 17:27,  anjali_...@yahoo.co.in wrote: PST ERROR:  could not fsync file base/16409: Invalid argument Dec 30 03:00:26 devok64-8 postgres_cifs_kaz_1[15812]: [2-2

Re: [BUGS] BUG #6372: Error while creating database with fsync parameter as on incase of CIFS

2012-01-02 Thread Magnus Hagander
On Mon, Jan 2, 2012 at 21:28, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Mon, Jan 2, 2012 at 21:14, Tom Lane t...@sss.pgh.pa.us wrote: I'm wondering what's your basis for asserting we don't support CIFS in general?  It's probably not terribly bulletproof

Re: [BUGS] BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1

2011-12-29 Thread Magnus Hagander
(maybe postgres) and tries to use it in another. That's a really easy mistake to make... --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #6302: Certificate lookup fails for users with /dev/null as home directory

2011-12-03 Thread Magnus Hagander
On Mon, Nov 21, 2011 at 19:03, Diego Elio Pettenò flamee...@flameeyes.eu wrote: Il giorno lun, 21/11/2011 alle 18.59 +0100, Magnus Hagander ha scritto: So a simple extension of the check to be for both ENOENT and ENOTDIR would work, right? In this case, yes... Ok, I've applied this quick-fix

Re: [BUGS] BUG #6314: The like command does not handle a long string of special chars

2011-12-02 Thread Magnus Hagander
website code that applied HTML escapes to plaintext emails, which in the end caused double escaping. I've just pushed a fix for this, so from now on bugreports won't do that. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [BUGS] BUG #6302: Certificate lookup fails for users with /dev/null as home directory

2011-11-21 Thread Magnus Hagander
On Nov 21, 2011 8:29 AM, Diego Elio Pettenò flamee...@flameeyes.eu wrote: The following bug has been logged online: Bug reference: 6302 Logged by: Diego Elio Pettenò Email address: flamee...@flameeyes.eu PostgreSQL version: 9.1.1 Operating system: Gentoo Linux

Re: [BUGS] BUG #6302: Certificate lookup fails for users with /dev/null as home directory

2011-11-21 Thread Magnus Hagander
On Mon, Nov 21, 2011 at 18:43, Diego Elio Pettenò flamee...@flameeyes.eu wrote: Il giorno lun, 21/11/2011 alle 09.08 +0100, Magnus Hagander ha scritto: What actual error do you get? ENOTDIR, sorry but I don't really want to break my system again just to show the strerror output ;) So

Re: [BUGS] pg_restore: [custom archiver] error during file seek: Invalid argument

2011-10-31 Thread Magnus Hagander
. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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 #6264: Superuser does not have inherent Replication permission

2011-10-25 Thread Magnus Hagander
definitely accept a docs patch to clarify what happens, because I agree it's confusing. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [BUGS] BUG #6238: ECPG converts long long to long on Windows

2011-10-16 Thread Magnus Hagander
for, that is not the same as HAVE_LONG_LONG_INT_64? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [BUGS] BUG #6233: pg_dump hangs with Access Violation C0000005

2011-10-05 Thread Magnus Hagander
or flags, you get two completely separate heaps in the app. Which is exactly the reason why we added that function to libpq. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

2011-10-03 Thread Magnus Hagander
the (NP) flag to not propagate inheritance or something? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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] Timezone issues with Postrres

2011-09-23 Thread Magnus Hagander
picked were more or less still guestimates. So I think it's just a mistake in that, and should be changed. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription

Re: [BUGS] BUG #6089: error in documentation: incorrect string literal for SSL mode; 'disabled' vs 'disable'

2011-07-05 Thread Magnus Hagander
src/interfaces/libpq/fe-connect.c. This appears to be a documentation mistake that goes back to at least version 8.4. Yup, it's a doc bug alright. It goes back to 8.4, where that table was added. I've applied a fix for this, will be in the next release. Thanks for reporting! --  Magnus

Re: [BUGS] BUG #6082: server segfault - pg_stat_reset_shared(null)

2011-07-03 Thread Magnus Hagander
On Wed, Jun 29, 2011 at 23:52, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Wed, Jun 29, 2011 at 15:31, Steve Haslam araq...@googlemail.com wrote: = select pg_stat_reset_shared(null) *server segfault* Thanks for the report - fixed, and will be in next

Re: [BUGS] BUG #6082: server segfault - pg_stat_reset_shared(null)

2011-06-29 Thread Magnus Hagander
nice way though... --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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] Changed behaviour of \'

2011-05-11 Thread Magnus Hagander
many people that we need to be even more clear than that. Like specifically saying that changing it back to off will make legacy applicatoins work again. Given that *so* many apps use it... And people don't look at warnings ;) --  Magnus Hagander  Me: http://www.hagander.net/  Work: http

Re: [BUGS] BUG #6011: Some extra messages are output in the event log at PostgreSQL startup

2011-05-06 Thread Magnus Hagander
and recompiling, of course). If we didn't send those to the eventlog, they would be completely lost since there is no stderr available to a windows service. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #5979: postgres service cannot be started if database is located in NAS

2011-04-15 Thread Magnus Hagander
SMB mounts anyway. It requires a local NFTS filesystem. SMB mounts cannot be trusted for databases. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http

Re: [BUGS] BUG #5971: NpgSql link doesnt work

2011-04-12 Thread Magnus Hagander
perhaps? Or maybe something blocking your access? Given the timestamp of the email, I would guess this was sent during the big hub.org outage yesterday, at which point all things pgfoundry were offline. So I think it's safe to saythat things have been fixed now. --  Magnus Hagander  Me: http

Re: [BUGS] Missing Bug-Report #5904?

2011-03-04 Thread Magnus Hagander
to_char(current_date, 'TMMonth ');  to_char ---  MäRz 2011 I also can reproduce this at a FreeBSD 7.0-STABLE. IIRC, the FreeBSD locales at least used to be pretty much broken for UTF8. Can you try and see if you get the same problem in a non-UTF8 locale? --  Magnus Hagander  Me

Re: [BUGS] Possible regression: libpq + SSL aborts when user has no home directory

2011-03-03 Thread Magnus Hagander
to the error message... --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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 #5866: Binary replication - default port

2011-02-03 Thread Magnus Hagander
, it will. On the port that you specified. It will not accept connections on a port it's not configured. Regardless of client, whether it's a replication client, or psql, or pgadmin, or your application. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs

Re: [BUGS] What happened to SSL_CIPHERS?

2010-12-18 Thread Magnus Hagander
On Thu, Dec 16, 2010 at 02:25, Josh Berkus j...@agliodbs.com wrote: On 12/15/10 4:58 AM, Magnus Hagander wrote: In any case, a doc patch would be the right thing for the back branches. I can look at this too (yes, I know we just wrapped, but I'm working down the backlog :S). You mean

Re: [BUGS] What happened to SSL_CIPHERS?

2010-12-15 Thread Magnus Hagander
On Fri, Oct 29, 2010 at 19:56, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Fri, Oct 29, 2010 at 10:01, Josh Berkus j...@agliodbs.com wrote: Mind you, we *also* need a doc patch. (This parameter is only available if PostgreSQL was built with SSL support

Re: [BUGS] not all pg_stat_database fields reset after pg_stat_reset()

2010-12-11 Thread Magnus Hagander
them, http://archives.postgresql.org/pgsql-committers/2007-03/msg00144.php Magnus, was this intentional by any chance? Nope, not that I can recall. Looks like an oversight. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing

Re: [BUGS] BUG #5773: DEBUG: reaping dead processes DEBUG: server process (PID 10007) was terminated by signal 11: Segme

2010-11-27 Thread Magnus Hagander
crashing.. Any chance it's a third party module that you didn't recompile for 9.0? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [BUGS] BUG #5767: Memory Leak

2010-11-25 Thread Magnus Hagander
of the process, just like the title does on Unix. Or you can look up the process id in the pg_stat_activity view to identify it. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] What happened to SSL_CIPHERS?

2010-10-29 Thread Magnus Hagander
that depend on a specific compile flag. That would make life easier on automated tools *and* on people sitting down at a new installation. Thoughts? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] What happened to SSL_CIPHERS?

2010-10-28 Thread Magnus Hagander
4.3.3-5ubuntu4) 4.3.3, 64-bit (1 row) postgres=# show ssl_ciphers; ERROR:  unrecognized configuration parameter ssl_ciphers So, did ssl_ciphers go away on purpose?  If so, why?  If not, why isn't it accessible? Are you sure you're on an SSL enabled build? --  Magnus Hagander  Me: http

Re: [BUGS] BUG #5687: RADIUS Authentication issues

2010-10-15 Thread Magnus Hagander
On Tue, Oct 5, 2010 at 15:18, Magnus Hagander mag...@hagander.net wrote: On Tue, Oct 5, 2010 at 11:01, Magnus Hagander mag...@hagander.net wrote: On Sun, Oct 3, 2010 at 18:30, Alan T DeKok al...@freeradius.org wrote: Tom Lane wrote: Hm ... seems to me that is a network security problem

Re: [BUGS] BUG #5687: RADIUS Authentication issues

2010-10-07 Thread Magnus Hagander
On Tue, Oct 5, 2010 at 19:11, Alan T DeKok al...@freeradius.org wrote: Magnus Hagander wrote: Actually, nevermind that one. Here's a patch I worked up from your description, and that turns out to be fairly similar to yours in what it does I think - except I'm not rearranging the code

Re: [BUGS] BUG #5687: RADIUS Authentication issues

2010-10-05 Thread Magnus Hagander
as attachment or publish it as a git repository I can fetch from? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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 #5687: RADIUS Authentication issues

2010-10-05 Thread Magnus Hagander
On Tue, Oct 5, 2010 at 11:01, Magnus Hagander mag...@hagander.net wrote: On Sun, Oct 3, 2010 at 18:30, Alan T DeKok al...@freeradius.org wrote: Tom Lane wrote: Hm ... seems to me that is a network security problem, not our problem. Who's to say one of the spoofed packets won't pass

Re: [BUGS] BUG #5674: initdb failed if path contains symlink

2010-09-28 Thread Magnus Hagander
On Tue, Sep 28, 2010 at 03:28, Itagaki Takahiro itagaki.takah...@gmail.com wrote: Magnus Hagander mag...@hagander.net writes: But how likely is that to bite us elsewhere then? Initdb works well if the link is a junction (mklink /J). We use junctions for tablespaces, but don't use symbolic

Re: [BUGS] BUG #5674: initdb failed if path contains symlink

2010-09-28 Thread Magnus Hagander
On Tue, Sep 28, 2010 at 11:08, Magnus Hagander mag...@hagander.net wrote: On Tue, Sep 28, 2010 at 03:28, Itagaki Takahiro itagaki.takah...@gmail.com wrote: On Mon, Sep 27, 2010 at 11:14 PM, Tom Lane t...@sss.pgh.pa.us wrote: I think this is a Microsoft bug and it's their problem to fix

Re: [BUGS] BUG #5674: initdb failed if path contains symlink

2010-09-27 Thread Magnus Hagander
because built with MSVC 2008 :-( . Ouch. We could work around it in this place (we could specifically ignore the file exists error on the mkdir call), I guess. But how likely is that to bite us elsewhere then? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com

Re: [BUGS] libpq: system-wide root.crt

2010-09-24 Thread Magnus Hagander
On Fri, Sep 24, 2010 at 00:41, Peter Eisentraut pete...@gmx.net wrote: 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

Re: [BUGS] libpq: system-wide root.crt

2010-09-23 Thread Magnus Hagander
of reasonable default that's not going to be platform/distribution specific? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [BUGS] BUG #5668: initdb failed to create postgres database

2010-09-21 Thread Magnus Hagander
. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- 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 #5628: 9.0beta4 failed automatic crash recovery

2010-08-24 Thread Magnus Hagander
. Are you saying it's fully reproducible? I don't recall if we did any specific changes around this for 9.0, did we? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your

Re: [BUGS] BUG #5628: 9.0beta4 failed automatic crash recovery

2010-08-24 Thread Magnus Hagander
On Tue, Aug 24, 2010 at 11:01 AM, Itagaki Takahiro itagaki.takah...@gmail.com wrote: On Tue, Aug 24, 2010 at 5:25 PM, Magnus Hagander mag...@hagander.net wrote: There might be issues to detach/reattach shared memory on Windows. We've seen this on and off before. Are you saying it's fully

Re: [BUGS] BUG #5627: Can not install on POSReady 2009

2010-08-24 Thread Magnus Hagander
installation than anything. Maybe you have messed up the PATH variable. Seems this is XP embedded? Does it even come with cacls? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] libpq: system-wide root.crt

2010-08-20 Thread Magnus Hagander
-cert-dir=/etc/postgresql-common, and confirm that in the latter case root.crt gets picked up from /etc/postgresql-common/ if it's not in ~/.postgresql/. Hi! Please add this to https://commitfest.postgresql.org/action/commitfest_view/open --  Magnus Hagander  Me: http://www.hagander.net/  Work

Re: [BUGS] libpq: system-wide root.crt

2010-08-17 Thread Magnus Hagander
with support for the CRL as well, since it goes together with the root cert ;) --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [BUGS] BUG #5559: Full SSL verification fails when hostaddr provided

2010-07-14 Thread Magnus Hagander
yet to see if I agree with the fix as well. Hope to get there soon. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: Duplicate bugs (was Re: [BUGS] BUG #5547: not able to connect to postgres through the oracle using Linux ODBC driver for Postgres)

2010-07-09 Thread Magnus Hagander
of a bug report in a table somewhere just to look for duplicates. We can expire it after just a minute or so. That'll catch the *exact* duplicates. It could catch partial ones, too. I'll stick that on the TODO list for the new website ;) -- Magnus Hagander Me: http://www.hagander.net/ Work: http

Re: [BUGS] [TESTERS] Location of certs -Windows 7 SSL mode?

2010-07-09 Thread Magnus Hagander
On Fri, Jul 9, 2010 at 04:58, Craig Ringer cr...@postnewspapers.com.au wrote: On 8/07/2010 6:31 PM, Magnus Hagander wrote: On Thu, Jul 8, 2010 at 03:10, Craig Ringercr...@postnewspapers.com.au  wrote: IIRC on Windows client certificates live in  %APPDATA%\.postgresql\ That's a typo

Re: [BUGS] [TESTERS] Location of certs -Windows 7 SSL mode?

2010-07-08 Thread Magnus Hagander
lot of thinsg we can rule out as the culprits then :-) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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] [TESTERS] Location of certs -Windows 7 SSL mode?

2010-07-08 Thread Magnus Hagander
environment variable or connection string parameter. See http://www.postgresql.org/docs/9.0/static/libpq-connect.html, for the parameters sslcert and sslkey. Or http://www.postgresql.org/docs/9.0/static/libpq-envars.html for the respective environment vars. -- Magnus Hagander Me: http

Re: [BUGS] [TESTERS] Location of certs -Windows 7 SSL mode?

2010-07-07 Thread Magnus Hagander
says it'll always return ENOENT on failure. Seems to me Windows is confused, but I'm not entirely sure how. Can you try specifying an explicit file say directly in c:\, just to see if that works? BTW, if you post bug reports to -bugs, it'll make a lot more people see them. -- Magnus Hagander Me

Re: [BUGS] BUG #5527: Website escapes way too much

2010-06-28 Thread Magnus Hagander
! -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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 #5488: pg_dump does not quote column names - pg_restore may fail when upgrading

2010-06-10 Thread Magnus Hagander
than manually hacking the dump... yeah. There are (supposedly?) a lot of *other* cases where using an old version of pg_dump won't work. At least we reserve the right for it to be. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs

Re: [BUGS] BUG #5468: Pg doesn't send accepted root CA list to client during SSL client cert request

2010-05-25 Thread Magnus Hagander
can get that done for 9.0 (even if we call it a bugfix) due to lack of time over the next couple of weeks. (and yes, I intend to get back in on the rest of this thread as well once I've cleared my pgcon-induced backlog) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill

Re: [BUGS] BUG #5468: Pg doesn't send accepted root CA list to client during SSL client cert request

2010-05-25 Thread Magnus Hagander
On Tue, May 25, 2010 at 18:44, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Tue, May 25, 2010 at 17:48, Tom Lane t...@sss.pgh.pa.us wrote: Craig Ringer cr...@postnewspapers.com.au writes: Bug 5245 is not the same issue. BTW, does anyone know exactly how

Re: [BUGS] BUG #5468: Pg doesn't send accepted root CA list to client during SSL client cert request

2010-05-21 Thread Magnus Hagander
something we will need to push back for a full release, which would mean 9.1. What would be good is if we can collect a list of interop issues and collect test-cases for them, because given the state of the openssl documentation it really comes down to having fairly detailed test-cases... -- Magnus

Re: [BUGS] BUG #5466: Asia/Novosibirsk timezone problem

2010-05-20 Thread Magnus Hagander
” time zone. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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 #5465: dblink TCP connection hangs blocking translation from being terminated

2010-05-19 Thread Magnus Hagander
afterwards. What would you suggest in this case? kill -9 on a client will make the postmaster restart the whole process, so yes, it's a very heavy operation. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #5466: Asia/Novosibirsk timezone problem

2010-05-19 Thread Magnus Hagander
break Almaty. There's no real easy way for us to find the difference between those, since we're just matching on those two strings. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

  1   2   3   4   5   >