>> Send a SIGQUIT to the postmaster to simulate a crash. When you bring it
>> back up, it thinks it is recovering from a backup, so it reads
>> backup_label. The checkpoint for the backup label is in 00...6, so it
>> reads that just fine. But then it tries to read the WAL starting at the
>> redo lo
The following bug has been logged online:
Bug reference: 5715
Logged by: Joel Lopes Da Silva
Email address: j...@lopes-da-silva.com
PostgreSQL version: 9.0.1
Operating system: Mac OS X 10.6 Snow Leopard
Description:man pages missing after compiling PostgreSQL 9.0.1
so
"Joel Lopes Da Silva" writes:
> After compiling the sources of PostgreSQL 9.0.1 on Mac OS X 10.6 Snow
> Leopard, I couldn't find any man pages.
What commands did you issue, exactly?
I think the top-level "make" targets got rearranged a bit since 8.4,
but it's premature to speculate without facts
Hi guys!
I wanted to install PokerTracker3, but the required PostgreSQL could not be
installed because (apparently) it was installed before by another program...
So, when I start PokerTracker3, a PostgreSQL server window opens containing
already filled in data about Server, Password etc...
When
El 18/10/2010 12:10, Sebastian Frey escribió:
Hi guys!
I wanted to install PokerTracker3, but the required PostgreSQL could not be
installed because (apparently) it was installed before by another program...
So, when I start PokerTracker3, a PostgreSQL server window opens containing
already f
Excerpts from Vladimir Kokovic's message of sáb oct 16 15:45:02 -0300 2010:
> Hi,
>
> I'm not sure whether it is OK, a blank format for bytea, which is presented
> in 9.1devel (pg_dump and psql)
Yeah, an empty bytea is now output differently by default (just like any
other bytea). The \x means "
Joel Lopes Da Silva writes:
> On Oct 18, 2010, at 7:16 AM, Tom Lane wrote:
>> What commands did you issue, exactly?
> I did:
> ./configure --enable-thread-safety \
> --with-openssl \
> --with-perl
Excerpts from Vladimir Kokovic's message of lun oct 18 14:50:30 -0300 2010:
> Hi,
>
> Yes, pgdiff shows the difference for a table that has fields with empty
> bytea comparing 9.1devel and 8.4 pg_dump files!
Would it be enough to flip bytea_output?
--
Álvaro Herrera
The PostgreSQL Company - Co
On Mon, 2010-10-18 at 17:02 +0900, Fujii Masao wrote:
> Yep, to automatically delete backup_label and continue recovery seems to be
> dangerous. How about just emitting FATAL error when neither restore_command
> nor primary_conninfo is supplied and backup_label exists? This seems to be
> simpler th
Hi,
I think that empty bytea shoukd be like in 8.4, without \\x !
Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia
On Mon, Oct 18, 2010 at 8:02 PM, Alvaro Herrera
wrote:
> Excerpts from Vladimir Kokovic's message of lun oct 18 14:50:30 -0300 2010:
> > Hi,
> >
> > Yes, pgdiff shows th
Vladimir Kokovic writes:
> I think that empty bytea shoukd be like in 8.4, without \\x !
We could do that, but it seems completely cosmetic. The real problem
here is that you've got client-side code that doesn't understand the
hex-based format. It's going to break as soon as it sees a non-empty
On Mon, Oct 18, 2010 at 11:27 AM, Rodriguez Fernando
wrote:
> El 18/10/2010 12:10, Sebastian Frey escribió:
>>
>> Hi guys!
>>
>> I wanted to install PokerTracker3, but the required PostgreSQL could not
>> be installed because (apparently) it was installed before by another
>> program...
>> So, wh
On Mon, Oct 18, 2010 at 2:07 PM, Jeff Davis wrote:
> On Mon, 2010-10-18 at 17:02 +0900, Fujii Masao wrote:
>> Yep, to automatically delete backup_label and continue recovery seems to be
>> dangerous. How about just emitting FATAL error when neither restore_command
>> nor primary_conninfo is suppli
Hi Tom,
On Oct 18, 2010, at 9:25 AM, Tom Lane wrote:
> Joel Lopes Da Silva writes:
>> On Oct 18, 2010, at 7:16 AM, Tom Lane wrote:
>>> What commands did you issue, exactly?
>
>> I did:
>
>> ./configure --enable-thread-safety \
>>--with-openssl
On Oct 18, 2010, at 7:16 AM, Tom Lane wrote:
> "Joel Lopes Da Silva" writes:
>> After compiling the sources of PostgreSQL 9.0.1 on Mac OS X 10.6 Snow
>> Leopard, I couldn't find any man pages.
>
> What commands did you issue, exactly?
>
> I think the top-level "make" targets got rearranged a bi
Hi,
Yes, pgdiff shows the difference for a table that has fields with empty
bytea comparing 9.1devel and 8.4 pg_dump files!
Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia
On Mon, Oct 18, 2010 at 5:45 PM, Alvaro Herrera
wrote:
> Excerpts from Vladimir Kokovic's message of sáb oct 16
On Mon, 2010-10-18 at 17:51 -0400, Robert Haas wrote:
> On Mon, Oct 18, 2010 at 2:07 PM, Jeff Davis wrote:
> > On Mon, 2010-10-18 at 17:02 +0900, Fujii Masao wrote:
> >> Yep, to automatically delete backup_label and continue recovery seems to be
> >> dangerous. How about just emitting FATAL error
On 10/18/2010 10:10 PM, Sebastian Frey wrote:
Hi guys!
I wanted to install PokerTracker3, but the required PostgreSQL could not be
installed because (apparently) it was installed before by another program...
So, when I start PokerTracker3, a PostgreSQL server window opens containing
already fi
The following bug has been logged online:
Bug reference: 5716
Logged by: Andrew Tipton
Email address: and...@adioso.com
PostgreSQL version: 9.0.1
Operating system: Ubuntu 10.04
Description:Regression joining tables in UPDATE with composite types
Details:
Attempting
Hi,
How did you install existing instance of PG server..?? Did you use any of
the community installers..??
IMO to avoid data load, you need to remove your data directory if it is not
required now. To get rid of user accounts, you need to remove them as well.
Regards,
On Mon, Oct 18, 2010 at 7:4
On Tue, Oct 19, 2010 at 7:00 AM, Jeff Davis wrote:
>> > Do users have any expectation that they can restore a backup without
>> > using recovery.conf by merely having the WAL segments in pg_xlog?
>>
>> I would expect that to work.
What's the use case?
> If that's the expectation, I believe my or
21 matches
Mail list logo
