Hi!
Thank you, I actually tried that and it seems that only lead to even more
corrupted data. I am currently trying to recover the 'hot-standby' host
that is also unhappy about one of the wal_files. I am looking at the wal
with less and see only data i do not care about in it (mostly
session-loggi
Hi List!
On an originally designated hot_standby that had been not so hot for the
last 24h i tried to replay the wal_files left over from a (seemingly
corrupted) master server [missing clog... ].
I get this output:
"/etc/postgresql/9.1/main/postgresql.conf" 584L, 19942C written
root@pgstandby7:/
On Tue, Jul 30, 2013 at 4:07 AM, Klaus Ita wrote:
> Sorry for cross-posting, i read that pg-bug was not the right place for
> this email
>
> Hi list!
>
> depressed me gets error messages like these:
>
> 2013-07-29 20:57:09 UTC ERROR: could not access
> status of transaction 8393477
> 2013-07-29
On Tue, Jul 30, 2013 at 9:51 AM, saritha N wrote:
> Thanks for your reply Raghavendra,
>
>
Thanks for the update.
Request to mark postgresql group email while replying so it will help much
if other's have better idea as well if any correction in my test case.
> Whatever you have sent its very
On Tue, Jul 30, 2013 at 6:05 AM, Sajeev Mayandi
wrote:
> Hi,
>
> I have bunch of rules created for tables to implement upsert functionality.
> My problem is our tables gets updated from multiple places , non
> –necessarily with the same no of columns. I want to figure out columns are
> being ask
I worked on a library project once that needed to perform similarity searches.
The first thing needed was to construct a word dictionary where there was a
number corresponding to each word.
1, 'aardvark'
...
9, 'zygote'
Then you need a list of stop words like 'AND', 'THE':
https://en.wikiped
Hi,
I have bunch of rules created for tables to implement upsert functionality.
My problem is our tables gets updated from multiple places , non –necessarily
with the same no of columns. I want to figure out columns are being asked to
be updated
E.g. The rule for the the table base-tabl
On Sat, Jul 27, 2013 at 10:04 AM, Janek Sendrowski wrote:
> If I'm searching for a sentence like "The tiger is the largest cat species"
> for example.
> I can only find the sentences, which include the words "tiger, largest, cat,
> species", but I also like to have the sentences with only three
Hi Jeff,
On Tue, Jul 30, 2013 at 3:25 AM, Jeff Janes wrote:
> On Tue, Jul 23, 2013 at 10:56 PM, Amit Langote
> wrote:
>> On Wed, Jul 24, 2013 at 3:20 AM, Jeff Janes wrote:
>>>
>>> The heap structure used in external sorts is cache-unfriendly. The
>>> bigger the heap used, the more this unfrie
Sorry for cross-posting, i read that pg-bug was not the right place for
this email
Hi list!
depressed me gets error messages like these:
2013-07-29 20:57:09 UTC ERROR: could not access
status of transaction 8393477
2013-07-29 20:57:09 UTC DETAIL: Could not open
file "pg_clog/0008": No such f
- Original Message -
From: Stephen Brearley
I need someone to please look at my error log which I posted nearly six
weeks ago, and tell me what is wrong.
Are you trying to tell us how to help you? Or are you looking for help?
Since my e-mail suggesting that you work to get Postg
On 07/29/2013 12:41 PM, Adrian Klaver wrote:
On 07/29/2013 12:23 PM, Stephen Brearley wrote:
Hi Folks/Alvaro/George Weaver/Sachin Kotwal
<<< PLEASE CAN SOMEONE HELP ME!! >>>
To start the process and catch up any one not following the first time,
some questions:
1) Exactly what are you instal
Stephen Brearley wrote on 29.07.2013 21:23:
1.Explain why my bug report has not been responded to
Because it's not a bug as you simply upgraded incorrectly.
5.Tell me how I should uninstall Postgres, if I am doing this wrong
You did run the "Uninstall", did you?
6.Tell me how to remove an
On 07/29/2013 12:23 PM, Stephen Brearley wrote:
Hi Folks/Alvaro/George Weaver/Sachin Kotwal
<<< PLEASE CAN SOMEONE HELP ME!! >>>
To start the process and catch up any one not following the first time,
some questions:
1) Exactly what are you installing i.e the one click installer from EDB ?
Hi Folks/Alvaro/George Weaver/Sachin Kotwal
<<< PLEASE CAN SOMEONE HELP ME!! >>>
Apologies for 'shouting': I have been trying since 21st June to get someone
to help me, since my initial post using the bug reporting form which has
still been ignored. I am just trying to get started with Post
On Mon, Jul 29, 2013 at 10:08 PM, Javier de la Torre wrote:
> You think it will be possible to, instead of comparing schemas, looking
> for the last modified OID on the DB to figure out where it happened?
>
Not really. When a row has been updated, you can only see the new values.
By comparing t
On Jul 28, 2013, at 5:29 PM, Amit Langote wrote:
> I think, the WAL recycling on standby names the recycled segments with
> the latest timelineID (in this case it's 0x10) which creates WALs that
> there shouldn't have been like 0010146A0001 instead of
> 000F146A0001. This p
On Tue, Jul 23, 2013 at 10:56 PM, Amit Langote wrote:
> On Wed, Jul 24, 2013 at 3:20 AM, Jeff Janes wrote:
>>
>> The heap structure used in external sorts is cache-unfriendly. The
>> bigger the heap used, the more this unfriendliness becomes apparent.
>> And the bigger maintenance_work_mem, the
On Jul 29, 2013, at 16:57, Tom Jenkinson wrote:
> Hi Tom,
>
> On Mon 29 Jul 2013 15:46:12 BST, Tom Lane wrote:
>> Tom Jenkinson writes:
>>> A little bit of information in the linked bugzilla report is that the
>>> exception being returned has an XA error code of XAER_RMERR "An error
>>> occurre
Hi Tom,
On Mon 29 Jul 2013 15:46:12 BST, Tom Lane wrote:
Tom Jenkinson writes:
A little bit of information in the linked bugzilla report is that the
exception being returned has an XA error code of XAER_RMERR "An error
occurred in rolling back the transaction branch. The resource manager is
fr
Hi Tom,
A little bit of information in the linked bugzilla report is that the
exception being returned has an XA error code of XAER_RMERR "An error
occurred in rolling back the transaction branch. The resource manager is
free to forget about the branch when returning this error so long as all
On Jul 26, 2013, at 11:27 AM, Jeff Janes wrote:
> That does not look like the entire message. What was before and after
> it in the log?
>
> For example:
>
> ERROR: role "foobar" already exists
> STATEMENT: create role foobar encrypted password 'XXX';
>
> If it were not for the ERROR, the ST
On Mon, Jul 29, 2013 at 7:14 PM, saritha N wrote:
> Hi,
>
> I am new to postgresql.We are migrating our application from oracle to
> postgresql.We are using postgresql version 9.2.All most everything we are
> migrated but I am unable to write a function for UPDATEXML which works same
> as in ora
John DeSoi writes:
> I was surprised to discover this today. I can work around it, but it seems
> counterintuitive. If 5 can't be parsed as a smallint, I would feel better if
> '5' was not one either.
Yeah, 5 is an int not a smallint, but '5' is not a smallint: it's a
literal of unknown type, f
On Jul 29, 2013, at 15:44, saritha N wrote:
> I am new to postgresql.We are migrating our application from oracle to
> postgresql.We are using postgresql version 9.2.All most everything we are
> migrated but I am unable to write a function for UPDATEXML which works same
> as in oracle.Please
On Mon, Jul 29, 2013 at 8:11 AM, John DeSoi wrote:
> I was surprised to discover this today. I can work around it, but it seems
> counterintuitive. If 5 can't be parsed as a smallint, I would feel better
> if '5' was not one either.
>
>
> temp=# create or replace function itest (param smallint) r
2013/7/23 Adrian Klaver :
> On 07/23/2013 05:15 AM, Ian Lawrence Barwick wrote:
>>
>> Is there some simple way of viewing the search path (or other
>> role-specific setting) for a role different to the current role? Apart
>> from
>> querying 'pg_db_role_setting' directly?
>>
>> Just wondering if I'
I was surprised to discover this today. I can work around it, but it seems
counterintuitive. If 5 can't be parsed as a smallint, I would feel better if
'5' was not one either.
John DeSoi, Ph.D.
psql (9.2.4)
Type "help" for help.
temp=# create or replace function itest (param smallint) return
On 07/29/2013 07:27 AM, Ingmar Brouns wrote:
On Mon, Jul 29, 2013 at 3:45 PM, Adrian Klaver wrote:
On 07/29/2013 04:24 AM, Ingmar Brouns wrote:
Hi,
This work?:
test=> select replace(1.500::text, '.', ',');
replace
-
1,500
(1 row)
that would work, but that requires keeping
Tom Jenkinson writes:
> A little bit of information in the linked bugzilla report is that the
> exception being returned has an XA error code of XAER_RMERR "An error
> occurred in rolling back the transaction branch. The resource manager is
> free to forget about the branch when returning this
On Mon, Jul 29, 2013 at 3:45 PM, Adrian Klaver wrote:
> On 07/29/2013 04:24 AM, Ingmar Brouns wrote:
>>
>> Hi,
>>
>> I need to convert some numerical values to text using the decimal
>> separator that corresponds to the current locale. However, I do
>> not want to lose information by padding with
Thanks Andrew,
You think it will be possible to, instead of comparing schemas, looking for the
last modified OID on the DB to figure out where it happened?
On Jul 29, 2013, at 3:42 PM, Andrew Tipton wrote:
> On Mon, Jul 29, 2013 at 9:12 PM, Javier de la Torre
> wrote:
> Hi,
>
> I was look
Ondrej Chaloupka writes:
> The OTS specification requires both bottom up and top down recovery to be
> triggered by the recovering resource. This causes that two rollback calls are
> done against the DB. DB receives rollback call and does the rollback. Then
> for the second time it returns the
On 07/29/2013 04:24 AM, Ingmar Brouns wrote:
Hi,
I need to convert some numerical values to text using the decimal
separator that corresponds to the current locale. However, I do
not want to lose information by padding with zero decimals or
truncating zero decimals. So I basically want a text ca
Hi,
I am new to postgresql.We are migrating our application from oracle to
postgresql.We are using postgresql version 9.2.All most everything we are
migrated but I am unable to write a function for UPDATEXML which works same
as in oracle.Please help me to resolve .
Thanks & Regards,
Saritha
On Mon, Jul 29, 2013 at 9:12 PM, Javier de la Torre
wrote:
> Hi,
>
> I was looking at the new event triggers on 9.3 and was doing some testing.
> I have compiled PostgreSQL 9.3 Beta2
> It looks from the examples that the only info right now available on
> plpgsql when the triggers fire is tg_event
Hi,
I would like to consult with you a problematic response put by PostgreSQL after
transaction recovery run by Narayana (JBossTS).
I work on tests for Narayana and I hit a issue with PostgreSQL. The db returns
incorrect code XAException.XA_HEURHAZ when the TM does recovery after crash of
the
On Mon, Jul 29, 2013 at 1:24 PM, Ingmar Brouns wrote:
> Hi,
>
> I need to convert some numerical values to text using the decimal
> separator that corresponds to the current locale. However, I do
> not want to lose information by padding with zero decimals or
> truncating zero decimals. So I basic
Hi,
I was looking at the new event triggers on 9.3 and was doing some testing. I
have compiled PostgreSQL 9.3 Beta2
It looks from the examples that the only info right now available on plpgsql
when the triggers fire is tg_event and tg_tag.
When developing on C you get access to more things. Bu
Hi,
I need to convert some numerical values to text using the decimal
separator that corresponds to the current locale. However, I do
not want to lose information by padding with zero decimals or
truncating zero decimals. So I basically want a text cast that
also replaces the dot by a comma. I've
Hi Lonni,
Greetings,
I have a postgresql-9.3-beta1 cluster setup (from the
yum.postgresql.org RPMs), where I'm experimenting with the postgres
FDW extension. The documentation (
http://www.postgresql.org/docs/9.3/static/postgres-fdw.html )
references three Cost Estimation Options which can be s
On Sat, Jul 27, 2013 at 10:24 PM, Olivier Austina
wrote:
> Hi,
>
> Can SQL be used to retrieve data from multimedia content such as audio,
> video, image, full text?
> Regards
> Olivier
>
I am not sure if this is really helpful but anyway, if you are willing
to spend some efforts on getting multi
Here is pg_lock for relation Y (= 2027300)
locktype | database | relation | page | tuple | virtualxid | transactionid
| classid | objid | objsubid | virtualtransaction | pid | mode
| granted
--+--+--+--+---++---+-+---+--
43 matches
Mail list logo
