The recovery is unable to find the WAL archive because, it was generated on
26th September.
Whereas the backup is as taken on Oct 2nd, 2011. We deleted all the files.
I do not have that WAL archive copy.
The problem area -
I found that a pg_clog file dated 26th Sep, 2011 is not synced (its not
On 03/10/11 17:03, wrote:
> How can i get record by data block not by sql?
> I want to read and write lots of data by data blocks, so i can form a
> disk-resident tree by recording the block address. But i don't know
> how to implement in postgresql.
> Is there system function can do this?
It
On Mon, Oct 3, 2011 at 4:53 PM, John R Pierce wrote:
> On 10/03/11 2:18 PM, Merlin Moncure wrote:
>>
>> hm -- care to comment in more detail?
>
>
> I've had to custom build it for each platform I've deployed it on, and it
> then has dependencies on the exact JDK version and location. It currentl
On 10/03/2011 09:50 PM, John R Pierce wrote:
On 10/03/11 3:09 PM, Merlin Moncure wrote:
libjvm.so => /usr/lib/libjvm.so (0x00cfc000)
I've never heard of a Sun JRE in /usr/lib
are you using (eeew) GCJ ?
He is using...
merlin@mmoncure-ubuntu:~$ ls -l /usr/lib/libjvm.so
lrwxrwxrwx
On 10/03/11 3:09 PM, Merlin Moncure wrote:
libjvm.so => /usr/lib/libjvm.so (0x00cfc000)
my libjvm.so is ...
$ ldd /usr/pgsql-9.0/lib/pljava.so
linux-vdso.so.1 => (0x7fff7bfff000)
libjvm.so =>
/usr/java/jdk1.5.0_22/jre/lib/amd64/server/libjvm.so (0x7f79d93240
On 10/03/11 2:18 PM, Merlin Moncure wrote:
hm -- care to comment in more detail?
I've had to custom build it for each platform I've deployed it on, and
it then has dependencies on the exact JDK version and location. It
currently doesn't work with JDK 6, only 1.5.It also requires custom
On Mon, Oct 3, 2011 at 4:16 PM, John R Pierce wrote:
> On 10/03/11 2:12 PM, Merlin Moncure wrote:
>>
>> sounds like you should be using pl/sh
>> (http://plsh.projects.postgresql.org/) or pl/java
>> (http://pgfoundry.org/projects/pljava/).
>
> pljava is a integration nightmare
hm -- care to commen
On 10/03/11 2:12 PM, Merlin Moncure wrote:
sounds like you should be using pl/sh
(http://plsh.projects.postgresql.org/) or pl/java
(http://pgfoundry.org/projects/pljava/).
pljava is a integration nightmare
I'd suggest plperlu
--
john r pierceN 37, W 122
santa c
On Mon, Oct 3, 2011 at 4:05 PM, J.V. wrote:
> Is it possible within a stored function to:
> 1) Access the file system (to rename a file for example)
> 2) Call a java program
sounds like you should be using pl/sh
(http://plsh.projects.postgresql.org/) or pl/java
(http://pgfoundry.org/project
On Mon, Oct 3, 2011 at 2:05 PM, J.V. wrote:
> Is it possible within a stored function to:
> 1) Access the file system (to rename a file for example)
> 2) Call a java program
>
For both of these:
1) yes, if you use an untrusted program and
2) These are dangerous because they are operations
Is it possible within a stored function to:
1) Access the file system (to rename a file for example)
2) Call a java program
thanks
J.V.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
2011-10-03 19:31 keltezéssel, Boszormenyi Zoltan írta:
> 2011-10-03 18:12 keltezéssel, Boszormenyi Zoltan írta:
>> Hi,
>>
>> here is the testcase:
>>
>> create type mytype as (id integer, t varchar(255));
>> create table mytest (id serial, t1 varchar(255), t2 varchar(255));
>> create or replace fun
2011-10-03 19:17 keltezéssel, Scott Ribe írta:
> On Oct 3, 2011, at 10:12 AM, Boszormenyi Zoltan wrote:
>
>> But I would like to know why isn't the type conversion from unlimited varchar
>> to varchar(255) invoked in the pl/pgsql function?
> What if t1 || t2 is longer than 255? You need to explicit
On 3 Oct 2011, at 18:12, Boszormenyi Zoltan wrote:
> Hi,
>
> here is the testcase:
>
> create type mytype as (id integer, t varchar(255));
> create table mytest (id serial, t1 varchar(255), t2 varchar(255));
> create or replace function myfunc () returns setof mytype as $$
> begin
> return quer
On Oct 3, 2011, at 10:12 AM, Boszormenyi Zoltan wrote:
> But I would like to know why isn't the type conversion from unlimited varchar
> to varchar(255) invoked in the pl/pgsql function?
What if t1 || t2 is longer than 255? You need to explicitly specify.
--
Scott Ribe
scott_r...@elevated-dev.c
2011-10-03 18:12 keltezéssel, Boszormenyi Zoltan írta:
> Hi,
>
> here is the testcase:
>
> create type mytype as (id integer, t varchar(255));
> create table mytest (id serial, t1 varchar(255), t2 varchar(255));
> create or replace function myfunc () returns setof mytype as $$
> begin
> return qu
On October 3, 2011 05:33:35 AM Venkat Balaji wrote:
> Did anyone observe this behavior ?? Please help !
>
> This is critical for us. I want to recommend not to use "rsync" (use cp or
> scp instead) for production backup.
>
rsync works fine. Why exactly can't the recovery find the backed up copy
On Mon, Oct 3, 2011 at 13:46, Chris Travers wrote:
>
>
> On Mon, Oct 3, 2011 at 9:13 AM, wrote:
>
>> The Ngpsql driver isn't old. They've released updates to it all through
>> version 8 and 9 so far as I know. We do some .Net work against Postgres and
>> it seems to work for what we're doing.
On Mon, Oct 3, 2011 at 9:13 AM, wrote:
> The Ngpsql driver isn't old. They've released updates to it all through
> version 8 and 9 so far as I know. We do some .Net work against Postgres and
> it seems to work for what we're doing.
>
> Indeed, the latest release seems to be less than a month ol
Hi,
here is the testcase:
create type mytype as (id integer, t varchar(255));
create table mytest (id serial, t1 varchar(255), t2 varchar(255));
create or replace function myfunc () returns setof mytype as $$
begin
return query select id, (t1 || t2)::varchar from mytest;
end;$$ language plpgsql
I do not understand what you mean by the term sluggish?
Every .NET driver has some overhead when you first load it, and then it is
being cached into memory.
I have used Npgsql and it worked great for me.
If you are not satisfied with Npgsql, try Devarts connector.
On Oct 2, 2011 5:33 AM, "Rohit
<<< text/html; charset="utf-8": Unrecognized >>>
<>
On Oct 3, 2011, at 3:03 AM, 姜头 wrote:
> I want to read and write lots of data by data blocks, so i can form a
> disk-resident tree by recording the block address.
Then you want some kind of lower-level b-tree manager, not a SQL database, and
certainly not PostgreSQL. Before you go down that pat
On Sun, Oct 02, 2011 at 05:45:48PM +0200, Reuven M. Lerner wrote:
> quite grateful for that. (I really hadn't ever needed to deal with
> such issues in the past, having worked mostly with English and
> Hebrew, which don't have such accent marks.)
That isn't quite true about English. We have word
Hi!
What usage case of Npgsql are you having performance issues?
On Sun, Oct 2, 2011 at 00:32, Rohit Coder
wrote:
> PgSQL has just one old NPGSQL driver for .NET, which is itself sluggish. The
> ODBC driver works better as compared to NPGSQL, but I suspect the ODBC
> driver is not the right cho
I see no evidence that SP1 is installed on this machine.
Karl
On Mon, Oct 3, 2011 at 9:14 AM, Dave Page wrote:
> Thanks Karl. Is SP1 installed? Sachin, Ashesh - anything else you can
> think of that would be useful?
>
> On Mon, Oct 3, 2011 at 1:48 PM, Karl Wright wrote:
>> Sorry for the delay -
On Sat, Oct 01, 2011 at 11:16:06PM +0200, Leif Biberg Kristensen wrote:
> But thank you for the idea, I think that I will strip out at least any
> entities from text entered into the database.
If you're getting &lrm, you might want to check for ZWJ and ZWNJ code
points too. They're nasty becau
Some errata and round up comments.
First of all, I think it's relevant to give some info about the system
I'm running:
OS: Linux
Distro: Gentoo
Perl: dev-lang/perl-5.12.3-r1 USE="-* berkdb gdbm"
Gentoo Base System release: 2.0.2
PORTDIR/metadata/timestamp.chk: Tue, 12 Jul 2011 00:45:01 +
<<< text/html; charset="utf-8": Unrecognized >>>
<>
On Mon, Oct 3, 2011 at 2:39 PM, wrote:
> I am running Windows 7 x64 (version 6.1.7601). My copy is also from the
> MSDN with latest updates applied. When I get to the end of the postgres
> install I get a error:
>
> Problem running post-install step. Installation may not complete
> correctly.
On Mon, Oct 3, 2011 at 9:42 AM, Thomas Kellerer wrote:
> Dave Page wrote on 03.10.2011 10:11:
>>
>> Karl; can you please provide precise details of your Windows version,
>> and anything unusual about your disk configuration? I know this
>> doesn't happen on any of the installations of Windows 7 th
Thanks Karl. Is SP1 installed? Sachin, Ashesh - anything else you can
think of that would be useful?
On Mon, Oct 3, 2011 at 1:48 PM, Karl Wright wrote:
> Sorry for the delay - it's been a busy morning.
>
> The Windows 7 system I'm using is a laptop with a standard basic Nokia
> image. To the bes
Sorry for the delay - it's been a busy morning.
The Windows 7 system I'm using is a laptop with a standard basic Nokia
image. To the best of my knowledge there have been no OEM
modifications of any kind. It describes itself as "Windows 7
Enterprise", and says it is 32-bit. That's it.
Anything
To know the page and row information :
Select ctid,* from ;
For more information at page-level, you can take the help of contrib module
"pageinspect". Which is under
pgsql-path/share/postgresql/contrib/pageinspect.sql
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspo
How can i get record by data block not by sql?
I want to read and write lots of data by data blocks, so i can form a
disk-resident tree by recording the block address. But i don't know how to
implement in postgresql.
Is there system function can do this?
Can someone help me?? Thank you
Another problem in recovery (probably because of "rsync") -
As said earlier, we are taking a production backup everyday incrementally
using "rsync".
But, Postgres some how misses to sync few files in between and keeps on
asking the back dated archive files (more than 1 week ago).
I restored Octo
On 3 October 2011 08:33, Alexander Pyhalov wrote:
> Now we want to select count of all employees who doesn't have any
> subordinates (query 1):
> SELECT count(employee_id) from employees o where not exists (select 1 from
> employees where manager_id=o.employee_id);
> count
> ---
> 89
>
On 10/03/2011 04:14 AM, Sim Zacks wrote:
> I don't know if there is an official definition, but an extension is
> generally a compiled program that is accessed by the SQL. It must be
> compiled with the postgresql headers and have the magic number defined.
> The compiled file must then be put into
You might scrap all BEGIN/COMMIT/ROLLBACK stmts, and run your upgrade_all.sql as
psql --single-transaction -f upgrade_all.sql
Στις Monday 03 October 2011 12:36:58 ο/η Anssi Kääriäinen έγραψε:
> I am having the following problem: I have upgrade scripts which are
> runnable one-by-one. I will also
I am having the following problem: I have upgrade scripts which are
runnable one-by-one. I will also want to run all of them together. Example:
table1.sql:
begin;
alter table table1 add column new_col1;
alter table table1 add column new_col2;
commit;
table2.sql:
begin;
alter table table2 add co
Dave Page wrote on 03.10.2011 10:11:
Karl; can you please provide precise details of your Windows version,
and anything unusual about your disk configuration? I know this
doesn't happen on any of the installations of Windows 7 that we use
for testing (which tend to be the MSDN builds, running on
Maybe I'm misunderstanding something, but isn't such a sql file an
extension or is 95% of the way there? Pyrseas is already distributed
via PGXN, but like some other PGXN "extensions" (dbi-link?), it doesn't
actually create functions in the database. Its two utilities run
entirely as external
On Mon, Oct 3, 2011 at 8:59 AM, Magnus Hagander wrote:
> On Fri, Sep 30, 2011 at 15:34, Karl Wright wrote:
>> I saw a thread where somebody saw icacls.exe being called by the
>> one-click installer. I'm having the same thing - the installer has
>> been running for 45 minutes now and is basically
On Mon, Oct 03, 2011 at 11:48:45AM +0400, Alexander Pyhalov wrote:
> On 10/03/2011 11:19, Achilleas Mantzios wrote:
> >Alexander, that's a classic one,
> >rewrite your last query as :
> >
> >SELECT count(employee_id) from employees where employee_id not in
> > (select manager_id from employees
On Fri, Sep 30, 2011 at 15:34, Karl Wright wrote:
> I saw a thread where somebody saw icacls.exe being called by the
> one-click installer. I'm having the same thing - the installer has
> been running for 45 minutes now and is basically going to have to be
> stopped because I'm out of time waitin
On 10/03/2011 11:19, Achilleas Mantzios wrote:
Alexander, that's a classic one,
rewrite your last query as :
SELECT count(employee_id) from employees where employee_id not in
(select manager_id from employees WHERE manager_id IS NOT NULL);
NULLS semantics are sometimes not so obvious.
Alexander, that's a classic one,
rewrite your last query as :
SELECT count(employee_id) from employees where employee_id not in
(select manager_id from employees WHERE manager_id IS NOT NULL);
NULLS semantics are sometimes not so obvious.
Στις Monday 03 October 2011 09:33:12 ο/η Alexan
47 matches
Mail list logo
