Tom Lane wrote:
> Heikki Linnakangas writes:
>> Tom Lane wrote:
>>> Specifically, I propose this patch instead.
>
>> It looks better, but leaves the door open for WAL insertions for a much
>> longer period. Particularly, there's the call to CheckpointGuts(), which
>> does a lot of things. Maybe
The following bug has been logged online:
Bug reference: 5016
Logged by: Itagaki Takahiro
Email address: itagaki.takah...@oss.ntt.co.jp
PostgreSQL version: 8.5 Alpha 1
Operating system: Windows XP (mingw)
Description:dlltool error in libecpg_compatdll.def
Details:
I
Craig,
I looked into this problem extensively today, and here's what I found.
It's not PostgreSQL that is leaking memory; it's the fact that our
application is also using PostGIS 1.3.6.
We have modified the test program such that it clearly shows memory leak
when PostGIS is used.
Below is the e
On Wed, 2009-08-26 at 16:51 -0700, WANGRUNGVICHAISRI, SHIVESH wrote:
> However, I still insist that potentially the PostgreSQL community might
> want to look into why making use of libpq causes the client program's
> memory consumption to keep growing. This can be easily observed using
> the earli
On Wed, 2009-08-26 at 12:52 -0700, John R Pierce wrote:
> Sam Mason wrote:
> > On Wed, Aug 26, 2009 at 02:55:37PM +, Ken Smith wrote:
> >
> >> I also noted
> >> that if I try to run from the commandline that you use '/' in some of the
> >> program paths causing the OS to say it cannot find t
On Wed, 2009-08-26 at 16:51 -0700, WANGRUNGVICHAISRI, SHIVESH wrote:
>
> So my claim that PostgreSQL was leaking memory was not true, and I do
> apologize.
>
No problem. That's why it's important to look into these things - so we
find out.
> However, I still insist that potentially the Postgre
On Wed, Aug 26, 2009 at 10:12 PM, Alvaro Herrera wrote:
>
> The frustrating thing about this, is that we complain over and over, and
> hub.org email setup keeps breaking every so often.
The problem is not that it keeps breaking -- that's normal. The
problem is that it breaks and he's not aware bec
The frustrating thing about this, is that we complain over and over, and
hub.org email setup keeps breaking every so often. We need to thank
Marc very much for his hosting effort during all this time since he
first set things up back in 1996/7, but we also need to be looking
around for plausible
Greg Stark wrote:
> On Wed, Aug 26, 2009 at 7:59 PM, Gergely
> Czuczy wrote:
> > AFAIK exim generates a bounce to test the address, and for that I'm
> > getting a reject saying that the user is unknown for the VERP address.
> >
> > Aug 26 04:02:05 hostname exim[70819]: H=mx1.hub.org
> > [200.46.208
Magnus Hagander writes:
> On Wed, Aug 26, 2009 at 15:57, Tom Lane wrote:
>> Magnus Hagander writes:
>>> But that will still fail if the user has set it up to require a client
>>> certificate.
>>
>> But not till it gets to the pg_hba checks. We might need to have some
> How would that be differ
On Wed, Aug 26, 2009 at 7:59 PM, Gergely
Czuczy wrote:
> AFAIK exim generates a bounce to test the address, and for that I'm
> getting a reject saying that the user is unknown for the VERP address.
>
> Aug 26 04:02:05 hostname exim[70819]: H=mx1.hub.org
> [200.46.208.106] sender verify fail for
>
hello
2009/8/26 Anze Cevka :
> Hello!
>
> I am wondering where can I found out what is my postgre SQL password,
> because I forgot it.
>
you have to add line to pg_hba.conf file for postgresql user.
from local change authentication method to trust (attention - from
this moment, your database is
Hello!
I am wondering where can I found out what is my postgre SQL password, because I
forgot it.
Thanks for your help.
Best regards
Anze
_
Share your memories online with anyone you want.
http://www.microsoft.com/middleeast/wi
On Wed, Aug 26, 2009 at 15:57, Tom Lane wrote:
> Magnus Hagander writes:
>> But that will still fail if the user has set it up to require a client
>> certificate.
>
> But not till it gets to the pg_hba checks. We might need to have some
How would that be different from what we have now? sslmode=
Thanks. and sorry for using this form of reporting, but by not being
able to use the MLs, filling a bugreport form seemed to be the best way
to communicate this.
On Wed, 26 Aug 2009 15:04:57 -0400
Alvaro Herrera wrote:
> Gergely Czuczy wrote:
> > AFAIK exim generates a bounce to test the address
AFAIK exim generates a bounce to test the address, and for that I'm
getting a reject saying that the user is unknown for the VERP address.
Aug 26 04:02:05 hostname exim[70819]: H=mx1.hub.org
[200.46.208.106] sender verify fail for
: response
to "RCPT
TO:"
from mx1.hub.org [200.46.208.106] was: 55
Sam Mason wrote:
On Wed, Aug 26, 2009 at 02:55:37PM +, Ken Smith wrote:
I also noted
that if I try to run from the commandline that you use '/' in some of the
program paths causing the OS to say it cannot find the file - "C:/Program
Files/Java/jdk1.5.0_16/jre/bin/java.exe".
I'm pre
On Wed, Aug 26, 2009 at 02:55:37PM +, Ken Smith wrote:
> I also noted
> that if I try to run from the commandline that you use '/' in some of the
> program paths causing the OS to say it cannot find the file - "C:/Program
> Files/Java/jdk1.5.0_16/jre/bin/java.exe".
I'm pretty sure that Windows
Magnus Hagander wrote:
> On Wed, Aug 26, 2009 at 21:04, Alvaro Herrera
> wrote:
> > Gergely Czuczy wrote:
> >> AFAIK exim generates a bounce to test the address, and for that I'm
> >> getting a reject saying that the user is unknown for the VERP address.
> >>
> >> Aug 26 04:02:05 hostname exim[708
On Wed, Aug 26, 2009 at 21:04, Alvaro Herrera wrote:
> Gergely Czuczy wrote:
>> AFAIK exim generates a bounce to test the address, and for that I'm
>> getting a reject saying that the user is unknown for the VERP address.
>>
>> Aug 26 04:02:05 hostname exim[70819]: H=mx1.hub.org
>> [200.46.208.106]
Gergely Czuczy wrote:
> Thanks. and sorry for using this form of reporting, but by not being
> able to use the MLs, filling a bugreport form seemed to be the best way
> to communicate this.
Yeah, it's OK, don't worry about it.
--
Alvaro Herrerahttp://www.CommandPr
Gergely Czuczy wrote:
> AFAIK exim generates a bounce to test the address, and for that I'm
> getting a reject saying that the user is unknown for the VERP address.
>
> Aug 26 04:02:05 hostname exim[70819]: H=mx1.hub.org
> [200.46.208.106] sender verify fail for
> : response
> to "RCPT
> TO:"
> f
Hello,
okey, i've removed the check for postgresql.org.
OTOH, may I ask how does VERP work at all for the mailing list, if the
returning mails are not handled? Just interested.
On Wed, 26 Aug 2009 17:43:17 +0100
Greg Stark wrote:
> On Wed, Aug 26, 2009 at 7:29 AM, Gergely
> Czuczy wrote:
> >
>
Gergely Czuczy wrote:
> Hello,
>
> okey, i've removed the check for postgresql.org.
>
> OTOH, may I ask how does VERP work at all for the mailing list, if the
> returning mails are not handled? Just interested.
It works reasonably well. What do you mean by "returning mails are not
handled"?
--
Gergely Czuczy wrote:
> The mailing lists are using VERP, but the sender address verifications are
> failing for these addresses, therefore sender address verification-enabled
> MTAs are unable to receive mails from the lists.
We require that addresses subscribed to the list do not have ugly send
On Wed, Aug 26, 2009 at 7:29 AM, Gergely
Czuczy wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5012
> Logged by: Gergely Czuczy
> Email address: gergely.czu...@harmless.hu
> PostgreSQL version: 8.4
> Operating system: FreeBSD
> Description: maili
Greg Stark wrote:
I don't know where to find Postgres logs on Windows but it
shouldn't be hard to find.
$(INSTALLDIR)/data/pg_log
D:\postgres\8.3\data\pg_log on mine here.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.po
On Wed, Aug 26, 2009 at 4:38 PM, Craig
Ringer wrote:
> If it is in fact postgres.exe that crashes at some point, it'd also
> *REALLY* help to have a backtrace of the crash.
If Postgres crashes due to running out of memory it prints a memory
dump to its log which would (hopefully) make it clear whe
On Wed, 2009-08-26 at 07:09 -0700, WANGRUNGVICHAISRI, SHIVESH wrote:
> I also did use the Process Explorer as you suggested; I'm sorry I
> didnt mention that in the post. As I mentioned before in the zip file,
> the working set kept growing.
Yes, but does the *private* working set? The screen sho
Heikki Linnakangas writes:
> Tom Lane wrote:
>> Specifically, I propose this patch instead.
> It looks better, but leaves the door open for WAL insertions for a much
> longer period. Particularly, there's the call to CheckpointGuts(), which
> does a lot of things. Maybe I'm just too paranoid abo
james bardin wrote:
> Is this the type of fix that would make it into the next 8.4.x release?
Yes. this fix will go into the next 8.4.x release.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes
Tom Lane wrote:
> I wrote:
>> ... but this solution is astonishingly ugly. I think we should move up
>> the LocalSetXLogInsertAllowed call, instead.
>
> Specifically, I propose this patch instead.
It looks better, but leaves the door open for WAL insertions for a much
longer period. Particularl
On Wed, Aug 26, 2009 at 9:55 AM, Ken Smith wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5015
> Logged by: Ken Smith
> Email address: kensm...@adobe.com
> PostgreSQL version: 8.4
> Operating system: Windows
> Description: MySQL migration wizard
The following bug has been logged online:
Bug reference: 5013
Logged by: Ishara
Email address: ishara...@gmail.com
PostgreSQL version: 8.4
Operating system: Solaris x86
Description:Error in psqlodbc configuration
Details:
Hi,
I used ./configure --with-odbc --enable
The following bug has been logged online:
Bug reference: 5015
Logged by: Ken Smith
Email address: kensm...@adobe.com
PostgreSQL version: 8.4
Operating system: Windows
Description:MySQL migration wizard does not start
Details:
I have downloaded and installed PostgreS
The following bug has been logged online:
Bug reference: 5012
Logged by: Gergely Czuczy
Email address: gergely.czu...@harmless.hu
PostgreSQL version: 8.4
Operating system: FreeBSD
Description:mailing list VERP addresses not sender-verifiable
Details:
Hello,
The mai
I wrote:
> ... but this solution is astonishingly ugly. I think we should move up
> the LocalSetXLogInsertAllowed call, instead.
Specifically, I propose this patch instead. I'm not set up to try the
test case though, can you do that?
regards, tom lane
Index: src/backend
On Wed, Aug 26, 2009 at 4:40 AM, Heikki
Linnakangas wrote:
>> Is this currently possible, or do I have to send a full file-level backup to
>> sync the ex-master server with the new master?
>
> That should work. (Note that you do need to restore the ex-master from
> the old base backup; you can't ju
Magnus Hagander writes:
> But that will still fail if the user has set it up to require a client
> certificate.
But not till it gets to the pg_hba checks. We might need to have some
variant on PQrequiresPassword to detect that failure type, but we'll
already know what we need to.
This still poi
On Wed, Aug 26, 2009 at 15:30, Tom Lane wrote:
> Magnus Hagander writes:
>> I think this indicates that pg_ctl is trying to connect to the
>> database just to see if it's running, but you have set it to require
>> SSL certificate on connections from localhost. Could that be so? If
>> so, try setti
Heikki Linnakangas writes:
> Our last-minute changes in 8.4 to allow checkpoint record to be created,
> while forbidding other WAL insertions, missed that CreateCheckPoint()
> calls AdvanceXLInsertBuffer() which requires a valid ThisTimeLineID to
> be set. We need to initialize ThisTimeLineID befo
Magnus Hagander writes:
> I think this indicates that pg_ctl is trying to connect to the
> database just to see if it's running, but you have set it to require
> SSL certificate on connections from localhost. Could that be so? If
> so, try setting the requirement for certificates only on non-local
James Bardin wrote:
> I'm working on a system where the master and standby servers are expected to
> be able to swap roles repeatedly. The first failover works fine, but the
> ex-master, now standby, can't recover using the shipped logs.
>
> Using recovery_target_timeline='latest' finds the new hi
On Wed, Aug 26, 2009 at 08:47, Jalaj Negi wrote:
> Hello, following is PostgreSQL log file.
> I have no certificate to revoke so I havent placed any "root.crl" file in
> servers data directory.
>
> Log File
> ==
44 matches
Mail list logo
