On Tue, Nov 27, 2012 at 8:27 AM, Jeff Janes wrote:
> On Mon, Nov 26, 2012 at 12:23 PM, Kevin Grittner wrote:
> > Jeff Janes wrote:
> >
> >> FATAL: requested recovery stop point is before consistent recovery point
> >>
> >> I don't understand why are you not getting this message.
> >
> > Is it be
On Mon, Nov 26, 2012 at 11:32 PM, Albe Laurenz wrote:
> wd wrote:
> >>> Logs are something like this:
> >>>
> >>> [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery
> has paused
> >>> [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 10 0]HINT:
> Execute pg_xlog_replay_resume() t
On Mon, Nov 26, 2012 at 12:23 PM, Kevin Grittner wrote:
> Jeff Janes wrote:
>
>> FATAL: requested recovery stop point is before consistent recovery point
>>
>> I don't understand why are you not getting this message.
>
> Is it before the point where pg_stop_backup() was run?
It turns out that the
Yes. It would not be advisable to do that but at least you could check you
are able to use npgsql.
The best way would to create a Web application and put your files there.
I hope it helps.
Em 26/11/2012 19:02, "Peter Kroon" escreveu:
> >Do you have more than one .net installation?
> Yes 2 and 4
>Do you have more than one .net installation?
Yes 2 and 4.
I've tried with both pools and get same result.
>Also, can you try to add a bin folder in the root of your web app and put
npgsql.dll and mono.security there?
You mean create a folder called bin in: C:\inetpub\wwwroot ?
2012/11/26 Franci
Hm, this is very strange. Somehow your vb. Net isn't able to find
npgsql in the gac. Do you have more than one .net installation?
Also, can you try to add a bin folder in the root of your web app and put
npgsql.dll and mono.security there?
Sorry for not being very helpful.
Em 26/11/2012 18:51
Installed as well.
C:\Program Files\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools>gacutil
-l mono.security
Microsoft (R) .NET Global Assembly Cache Utility. Version 4.0.30319.17626
Copyright (c) Microsoft Corporation. All rights reserved.
The Global Assembly Cache contains the following asse
Ok, and what about mono.security? Npgsql depends on it and it should be in
the gac as well.
Em 26/11/2012 18:36, "Peter Kroon" escreveu:
> It appears to be installed.
>
> C:\Program Files\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools>gacutil
> -l Npgsql
> Microsoft (R) .NET Global Assembly Ca
Hello
Do you want to search for tables with many unordered rows?
SELECT
schemaname, tablename, correlation
FROM
pg_stats
WHERE
abs(correlation) < 0.2 and
schemaname not in ('pg_catalog', 'information_schema')
;
Or do you want to put the table in order?
BEGIN;
CRE
It appears to be installed.
C:\Program Files\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools>gacutil
-l Npgsql
Microsoft (R) .NET Global Assembly Cache Utility. Version 4.0.30319.17626
Copyright (c) Microsoft Corporation. All rights reserved.
The Global Assembly Cache contains the following as
Jeff Janes wrote:
> FATAL: requested recovery stop point is before consistent recovery point
>
> I don't understand why are you not getting this message.
Is it before the point where pg_stop_backup() was run?
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
> You should check if npgsql has been correctly installed in the gac by
running gac -l Npgsql. If it is it will return something.
>
> Another possibility is to add a folder called bin to the root of your web
app and put npgsql.dll and mono.security. dll inside.
>
> I hope it helps.
>
> Em 26/11/201
On 11/26/2012 07:15 PM, Merlin Moncure wrote:
I don't think you need a CTE or a loop unless you want to delete the
old rows. Why not (hard to say exactly how it will work):
INSERT INTO a(old_id, new_id, ...)
SELECT id, new_id(), ...
from a;
?
Well, the table A, in which I'm copying rows, does
Could you provide an example?
Fo me:
Drop/Creat/populating tables inside a function are slow.
Creating tables outside a function and populating he table inside a
function is fast..
2012/11/24 Craig Ringer
> On 11/24/2012 02:15 AM, Peter Kroon wrote:
> > I found out that declaring tables outsid
>Reinterpreting the question and taking the pseudocode semi-literally is
>the following closer to what was asked?
No, I don't want to use/create a function.
Best,
Peter
2012/11/24 Gavan Schneider
> On Friday, November 23, 2012 at 21:36, Peter Kroon wrote:
>
> Hello,
>>
>> I wish to return t
The actual error message was in Dutch. In my previous post I've added:
"It's unable to find/load dependencies." That's the translation.
I don't have a project. I have a vb.net page, like -> Default.aspx
I used the stackbuilder to install Npgsql and altered nothing else.
2012/11/26 Glyn Astill
I came up with this.
select replace( xmlelement(name my_xslt_tag,(select xmlparse(content
'')))::text ,'_x005F','')::xml;
It works but it's not very fast.
2012/11/23 Peter Kroon
> When I run this query:
> SELECT
> xmlelement(name my_xslt_tag,
> (SELECT XMLPARSE (CONTENT ''))
> )
>
> I get thi
Hi,First sorry for my bad English :D.I'm new in PostgreSQL and database .Now
i'm researching about statistic correlation .I want to make a example with
the table -assume that I have tbl_test table and two column - id & name -
and do something to get correlation of a column is near 0 (zero).What ste
I am also try to create PostgreSQL failover cluster server using RHEL6.1 OS.
I am creating few things, but right now I am not configure
1. Resources and Service Groups.
2. Heartbit,
3. Automatic failover.
Some body please help. I am waiting for your valuable reply.
Thanks
Gautam
Hello,
I created a role called Workers. I am able edit the privileges for the Workers
role in the public schema of a database. I also would like to edit the default
privileges of the schema as well so that the Workers group will automatically
have read permissions to any tables created in the
On Mon, Nov 26, 2012 at 3:35 AM, Vlad K. wrote:
>
> Hello list,
>
> I need to make a copy of certain rows in table A and remember the original
> pkey and new pkey in some temporary table B. Basically the copy statement is
> INSERT INTO a SELECT * FROM a where a.x=y;
>
> I guess I can do it with a
On Mon, Nov 26, 2012 at 12:22 PM, Magnus Hagander wrote:
>
> They look like bytea fields, in which case the parameter you're
> looking for is bytea_output (which is 'hex' by default now, used to be
> 'escape').
YES! Thank you Magnus! This was exactly it.
--
Douglas J Hunley (doug.hun...@gmail.co
On Mon, Nov 26, 2012 at 6:12 PM, Doug Hunley wrote:
> I have an older J2EE-based application that we're trying to limp along
> until everyone can get fully migrated off it, and one of the steps in
> keeping it running is to move it to a new host. Said new host runs
> PostgreSQL 9.2.1 where the exi
On Sat, Nov 24, 2012 at 3:44 PM, wd wrote:
>>
>> What entries are you getting in the log file?
>>
> Logs are something like this:
>
> [2012-11-24 21:51:33.374 CST 583 50b0d0e5.247 1 0]LOG: database system
> was shut down in recovery at 2012-11-24 21:51:32 CST
> [2012-11-24 21:51:33.375 CS
I have an older J2EE-based application that we're trying to limp along
until everyone can get fully migrated off it, and one of the steps in
keeping it running is to move it to a new host. Said new host runs
PostgreSQL 9.2.1 where the existing host runs 8.4.6. On the old
system, the data looks like
wd wrote:
>>> Logs are something like this:
>>>
>>> [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery
has paused
>>> [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 10 0]HINT:
Execute pg_xlog_replay_resume() to continue.
>>
>> Well, try
>>
>> SELECT pg_xlog_replay_resume();
I can't connect to postgres at that time.
On Mon, Nov 26, 2012 at 4:33 PM, Albe Laurenz wrote:
> wd wrote:
> > Logs are something like this:
> > [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery
> has paused
> > [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 10 0]HINT: Exe
2012/11/26 Ranjeet Dhumal :
> Hi Pavel ,
>
> For Tunning this which parameter i have to change from the configuration ,
> and at the time of setting it up which thinks i have to care i mean what
> will be the impact of that ?
you have to use full vacuum
Regards
Pavel
>
>
> On 26 November 201
Hi Pavel ,
For Tunning this which parameter i have to change from the configuration
, and at the time of setting it up which thinks i have to care i mean what
will be the impact of that ?
On 26 November 2012 12:09, Pavel Stehule wrote:
> Hello
>
> 2012/11/26 Ranjeet Dhumal :
> > Hi All ,
> >
An actual error message would be useful, but did you add a reference to the
assembly in your project?
>
> From: Peter Kroon
>To: "pgsql-general@postgresql.org"
>Sent: Friday, 23 November 2012, 18:13
>Subject: [GENERAL] Npgsql
>
>
>I've installed Npgsql via
Hello list,
I need to make a copy of certain rows in table A and remember the
original pkey and new pkey in some temporary table B. Basically the copy
statement isINSERT INTO a SELECT * FROM a where a.x=y;
I guess I can do it with a plpgsql function and a FOR loop statement,
because I n
wd wrote:
> Logs are something like this:
> [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 9 0]LOG: recovery
has paused
> [2012-11-24 21:51:33.591 CST 583 50b0d0e5.247 10 0]HINT: Execute
pg_xlog_replay_resume() to continue.
Well, try
SELECT pg_xlog_replay_resume();
Yours,
Laurenz Albe
On Nov 26, 2012 7:15 AM, "Tom Lane" wrote:
>
> Hari Babu writes:
> > When I was trying get the source code from ftp source, I found that
> > 9.2.0beta1 and 9.2beta1 are pointing to
> > 9.2.0beta1 source code. Is it intentional or Is there any source code
> > difference between 9.2.0beta1 and 9.2b
On 11/25/12 10:36 PM, Ranjeet Dhumal wrote:
Am facing one problem related to pg_toast table , its grown very huge
upto 31GB , even am vacuuming(not full) it daily , my fsm parameters
are default, can anyone tell how to decrease the size , if am firing
any query on gen_bulk_20121126 its respon
34 matches
Mail list logo
