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
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
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
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
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
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 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 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 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
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
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
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
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
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
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 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 "
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
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
"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
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
>> 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
21 matches
Mail list logo
