Hi, Jaime
thank you for your answer.
I understand it.
I turned synchronous_commit to "local",
I get desirable behavior.
I've thought that if there are no standby,
the primary would behave like stand-alone...
sorry, this is my misunderstanding.
regards,
(2011/05/27 14:53), Jaime Casanova wrot
On Fri, May 27, 2011 at 12:26 AM, Tomonari Katsumata
wrote:
>
>
> I've checked "unlogged table" and "Streaming Replication".
> I'm thinking about using unlogged tables as work-tables on Primary.
>
> 1) construct Streaming Replication Environment.
> Primary and Standby are same server with differe
The following bug has been logged online:
Bug reference: 6042
Logged by: Tomonari Katsumata
Email address: katsumata.tomon...@po.ntts.co.jp
PostgreSQL version: 9.1beta1
Operating system: RHEL5.3 x86_64
Description:unlogged table with Streaming Replication
Details:
H
On 05/26/2011 11:21 PM, Marco Spiga wrote:
Thanks Craig for your reply.
I have read wikipedia link and what you have tell me is TRUE.
But if I give these select:
megaradius=# SELECT to_hex(-42);
to_hex
--
ffd6
(1 riga)
megaradius=# SELECT to_hex(4294967254);
to_hex
I wrote:
> Robert Haas writes:
>> On Sun, May 15, 2011 at 5:02 PM, Tom Lane wrote:
>>> Robert Haas writes:
On Thu, May 12, 2011 at 6:20 PM, Tom Lane wrote:
> One possibility is to start showing "default" when the ACL is null,
> which would be quite easy to implement:
> COALESCE
2011/5/26 Euler Taveira de Oliveira :
> Em 26-05-2011 08:37, Emanuel escreveu:
>
>> Description: Unlogged table was created bad in slave node
>>
> Unlogged table contents are not available to slave nodes [1].
>
I know it. But the error raised isn't pretty nice for common users.
IMHO it coul
Alvaro Herrera writes:
> Excerpts from Euler Taveira de Oliveira's message of jue may 26 12:00:05
> -0400 2011:
>> I think we should emit the real cause in those cases, if possible (not too
>> much overhead). The message would be "Unlogged table content is not
>> available
>> in standby server
Excerpts from Euler Taveira de Oliveira's message of jue may 26 12:00:05 -0400
2011:
> Em 26-05-2011 08:37, Emanuel escreveu:
>
> > Description:Unlogged table was created bad in slave node
> >
> Unlogged table contents are not available to slave nodes [1].
>
> > postgres=# select * from
Em 26-05-2011 08:37, Emanuel escreveu:
Description:Unlogged table was created bad in slave node
Unlogged table contents are not available to slave nodes [1].
postgres=# select * from voidy ;
ERROR: could not open file "base/12071/17034": No existe el archivo o
directorio
I think we
The following bug has been logged online:
Bug reference: 6040
Logged by: Jordi Areny
Email address: as...@ascii.cat
PostgreSQL version: 9.03
Operating system: Windows 7 64 bits
Description:ODBC 64 + SSL Hangs
Details:
Server: PostGreSQL 8.04 On Ubuntu 10.04 Or Windo
The following bug has been logged online:
Bug reference: 6041
Logged by: Emanuel
Email address: postgres@gmail.com
PostgreSQL version: 9.1 beta
Operating system: Ubuntu
Description:Unlogged table was created bad in slave node
Details:
MASTER=
SLAVE SYNC=6667
The following bug has been logged online:
Bug reference: 6039
Logged by: Zajaczkowski
Email address: mathias.zajaczkow...@ubik.ch
PostgreSQL version: 9.00
Operating system: Windows Server 2008 Standard Edition SP 2
Description:Trying to use server status
Details:
As
12 matches
Mail list logo
