On Sun, Dec 11, 2016 at 7:31 PM, Torsten Förtsch wrote:
> Is it possible to catch CREATE TABLE and ALTER TABLE RENAME in 9.5?
You are looking for pg_ddl_command via event triggers.
src/test/modules/test_ddl_deparse is one example of that in the code
tree.
--
Michael
--
Sent via pgsql-general
On Mon, Dec 12, 2016 at 9:31 AM, Patrick B wrote:
> No.. it didn't copy. i tested here. I had to manually copy the history file
> from /var/lib/pgsql/9.2/data/pg_xlogs from the new master to the same
> directory on the slaves.
An archive command is able to properly fetch the history files to
defi
On Sun, Dec 11, 2016 at 12:00 PM, Sreekanth Palluru wrote:
> I am looking at possibility of PG introducing corruption if relation extends
> and before it updates new page with pageheader in memory and crash happens?
>
> Is this possible?
No.
> Does PG updates pageheader when relation get extend
On Saturday, December 10, 2016, Tom DalPozzo wrote:
>
> I have one direct DB client (let's name it MIDAPP) only. This client of
> the DB is a server for up to 1 final clients.
> Any time MIDAPP is going to reply to a client, it must save a "status
> record with some data" related to that cli
2016-12-12 12:09 GMT+13:00 Patrick B :
> 2016-12-12 12:00 GMT+13:00 Venkata B Nagothi :
>
>>
>> On Mon, Dec 12, 2016 at 7:48 AM, Patrick B
>> wrote:
>>
>>> Hi guys,
>>>
>>> Are the history files copied with the wal_files? Or I have to do it
>>> separated?
>>>
>>> 0003.history': No such file o
2016-12-12 12:00 GMT+13:00 Venkata B Nagothi :
>
> On Mon, Dec 12, 2016 at 7:48 AM, Patrick B
> wrote:
>
>> Hi guys,
>>
>> Are the history files copied with the wal_files? Or I have to do it
>> separated?
>>
>> 0003.history': No such file or directory
>>
>>
>> I'm using PostgreSQL 9.2.
>>
>
>
On Mon, Dec 12, 2016 at 7:48 AM, Patrick B wrote:
> Hi guys,
>
> Are the history files copied with the wal_files? Or I have to do it
> separated?
>
> 0003.history': No such file or directory
>
>
> I'm using PostgreSQL 9.2.
>
Can you please explain the scenario you are referring to ? during s
Hi guys,
Are the history files copied with the wal_files? Or I have to do it
separated?
0003.history': No such file or directory
I'm using PostgreSQL 9.2.
Cheers
Patrick
On Fri, Dec 09, 2016 at 05:22:07PM +, Joanna Xu wrote:
> Hi All,
>
> We plan to use ora2pg tool to migrate Oracle to PostgreSQL. During the
> testing, while importing content of the output.sql into PostgrSQL database,
> it terminated with the following error "ERROR: type "aq$_jms_text_mess
> On Dec 11, 2016, at 08:37, Melvin Davidson wrote:
>
> Yes, I see your point, but the case where the row does not fit into the same
> block
> would only occur with unlimited field types such as var[], bytea[], etc.
No, that's not correct either. A block can fill up for any number of reasons
On Sat, Dec 10, 2016 at 5:42 PM, Peter J. Holzer wrote:
> On 2016-12-09 21:45:35 -0500, Melvin Davidson wrote:
> > On Fri, Dec 9, 2016 at 6:40 PM, Samuel Williams <
> space.ship.travel...@gmail.com>
> > wrote:
> > >I also read that when you change a column which is not index, all the
> > >indexes
On Sun, Dec 11, 2016 at 12:10 AM, Andres Freund wrote:
> On 2016-12-10 22:34:02 +0100, Torsten Förtsch wrote:
> > I am working on a logical decoding output plugin. I am only interested in
> > the changes in one particular table.
> >
> > One way to check for the table would be to compare class_for
12 matches
Mail list logo
