Dear John and all,
>8.1 has been obsolete and unsupported for about 6 years now.8.1.18 was
>released in 2009, the final 8.1.23 release was in 2010, after which it was
>>dropped.
Yes, we understood your point.
But we require some information related to this rpm.
>These errors suggest disk fi
> On Sep 15, 2016, at 1:20 AM, Yogesh Sharma
> wrote:
>
> Dear John and all,
>
> >8.1 has been obsolete and unsupported for about 6 years now.8.1.18 was
> >released in 2009, the final 8.1.23 release was in 2010, after which it was
> >>dropped.
> Yes, we understood your point.
> But we r
On 9/15/2016 12:25 AM, Yogesh Sharma wrote:
Dear John,
Thanks for your support.
Please find below name of rpm.
RPMS/postgresql-8.1.18-2.1.x86_64.rpm
RPMS/postgresql-devel-8.1.18-2.1.x86_64.rpm
RPMS/postgresql-libs-8.1.18-2.1.x86_64.rpm
RPMS/postgresql-python-8.1.18-2.1.x86_64.rpm
RPMS/postgre
On 9/15/2016 12:53 AM, John R Pierce wrote:
ok, those RPM's were built and packaged by Redhat, I believe. If you
have a RHEL support contract, you should be able to get help from
them. If you don't, you really shouldn't be running RHEL as there's
no updates available without one.
wait
Dear John,
Thanks for your support.
>as far as how do you determine whats wrong with your file system?
I tried fsck and hardware check using SMART disk info, no issue found with disk
or filesystem.
>what file system are you using for the volume containing the postgres data
>directory ? with R
Hi, I'm getting this error:
2016-09-15 09:35:24 ART [13984-1] ERROR: could not read block 4 in file
"base/12210/11965": Error de entrada/salida
2016-09-15 09:35:39 ART [14082-1] ERROR: could not read block 4 in file
"base/12210/11965": Error de entrada/salida
2016-09-15 09:35:54 ART [14170-1]
I've got a table that stores some multilingual content:
CREATE TABLE search (
content text NOT NULL,
language regconfig NOT NULL,
fulltext tsvector
);
CREATE INDEX search_fulltext ON search USING GIN(fulltext);
INSERT INTO search (language, content) VALUES
Yogesh Sharma writes:
> We are using below postgresql rpm.
> postgresql-8.1.18-2.1
As already noted, that version is *way* obsolete, and full of known bugs.
It's irresponsible to be storing data you care about in such a version.
Having said that ...
> In our system, below error is found and occu
"=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" writes:
> Hi, I'm getting this error:
> 2016-09-15 09:35:24 ART [13984-1] ERROR: could not read block 4 in file
> "base/12210/11965": Error de entrada/salida
That looks like a hardware problem ... might want to budget for a new disk
sometime soon, before fail
El 15/09/16 a las 11:05, Tom Lane escribió:
"=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" writes:
Hi, I'm getting this error:
2016-09-15 09:35:24 ART [13984-1] ERROR: could not read block 4 in file
"base/12210/11965": Error de entrada/salida
That looks like a hardware problem ... might want to budget f
Hi all,
I have suspicions that my message don't get to pgsql-general mailing list.
Please, someone, answer this message if this get the mailing list.
Best regards, Alex
It did.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
From: Alex Sviridov
Sent: Thursday, September 15, 2016 4:57 PM
To: pgsql-general@post
El 15/09/16 a las 11:57, Alex Sviridov escribió:
Hi all,
I have suspicions that my message don't get to pgsql-general mailing list.
Please, someone, answer this message if this get the mailing list.
Best regards, Alex
Arrived ok.
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 6
Hey guys!
We are looking for active beta participants to try out our new SaaS-Based
Database Monitoring Tool. Our tool will monitor your databases and their
underlying (virtual) infrastructure. If you would like to be a part of the
beta, sign up here: http://www.bluemedora.com/early-access/
We wil
Hi,
Below is my test environment.
2 DB servers: 9.4 postgres
1 PgPool and PgpoolAdmin server:
pgpool - version 3.5.4 (ekieboshi)
pgpoolAdmin - 3.5.3
php - PHP 5.6.25-2+deb.sury.org~xenial+1 (cli)
While setting up pgpoolAdmin I am getting error
"/var/www/html/pgpoolAdmin-3.5.3/conf/pgmgt.conf.php
Hi,
Could someone share below information?
- PgSQL versions supported on ubuntu 16
- PgSQL versions supported on debian 8
--
thanks and regards,
Meera R Nair
> On 15 Sep 2016, at 14:46, Jaap Roes wrote:
>
> I've got a table that stores some multilingual content:
>
>CREATE TABLE search (
> content text NOT NULL,
> language regconfig NOT NULL,
> fulltext tsvector
>);
>CREATE INDEX search_fulltext ON search USING GIN(fulltext
I am following the instructions here:
http://blog.dbi-services.com/connecting-your-postgresql-instance-to-an-oracle-database/
to install Oracle foreign data wrapper, oracle_fdw, on a PostgreSQL server.
---
Oracle version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -
64bit Production
On Thu, Sep 15, 2016 at 5:46 AM, Jaap Roes wrote:
> I've got a table that stores some multilingual content:
>
> CREATE TABLE search (
> content text NOT NULL,
> language regconfig NOT NULL,
> fulltext tsvector
> );
> CREATE INDEX search_fulltext ON search USING GIN(f
On 9/15/2016 12:40 AM, MEERA wrote:
Could someone share below information?
- PgSQL versions supported on ubuntu 16
- PgSQL versions supported on debian 8
any current PG version (thats 9.1.latest (likely to be deprecated soon
when 9.6 releases) to 9.5.latest) can be run on most any version o
On Thu, Sep 15, 2016 at 3:25 PM, Arun Rangarajan
wrote:
> I am following the instructions here:
> http://blog.dbi-services.com/connecting-your-postgresql-
> instance-to-an-oracle-database/
> to install Oracle foreign data wrapper, oracle_fdw, on a PostgreSQL server.
>
> ---
> Oracle version: Orac
Thanks, Scott.
oracle_fdw version 1.5.0 from http://pgxn.org/dist/oracle_fdw/
Oracle client version: instantclient 12.1
/usr/lib/postgresql/9.4/lib# ldd oracle_fdw.so
linux-vdso.so.1 => (0x7fff50744000)
libclntsh.so.12.1 => /usr/lib/oracle/12.1/client64/lib/libclntsh.so.12.1
(0x7f44769f
Hi guys,
I got the test1 table with three columns:
id(BIGINT) - j_id(BIGINT) - comments(CHARACTER VARYING)
*This needs to be done 180 times:*
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123321,'test-1 -
> comments');
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123322,'te
On Thu, Sep 15, 2016 at 4:57 PM, Arun Rangarajan
wrote:
> Thanks, Scott.
>
> oracle_fdw version 1.5.0 from http://pgxn.org/dist/oracle_fdw/
>
> Oracle client version: instantclient 12.1
>
I've had problems using anything > instant client 10. Give it a shot.
--Scott
>
> /usr/lib/postgresql/9
On 16/09/16 07:45, Patrick B wrote:
> Hi guys,
>
>
> I got the test1 table with three columns:
>
> id(BIGINT) - j_id(BIGINT) - comments(CHARACTER VARYING)
>
>
> *This needs to be done 180 times:*
>
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123321,'test-1
> - comments'
>
>
>
> A select can make up columns too, not just what you've got in a table,
> so you can:
>
> select j_id, 'test-1 - comments' as comment from test2 where
> customer_id=88897;
>
> and then you can simply insert that into your other table (you don't
> need to specify the columns that are getting
2016-09-16 10:07 GMT+12:00 Patrick B :
>
>>
>> A select can make up columns too, not just what you've got in a table,
>> so you can:
>>
>> select j_id, 'test-1 - comments' as comment from test2 where
>> customer_id=88897;
>>
>> and then you can simply insert that into your other table (you don't
>
On 16/09/16 08:07, Patrick B wrote:
>
>
> A select can make up columns too, not just what you've got in a table,
> so you can:
>
> select j_id, 'test-1 - comments' as comment from test2 where
> customer_id=88897;
>
> and then you can simply insert that into your other table
>
>
>>
>>
>
> Please have a look on this example Patrick: http://sqlfiddle.com/#!15/
> 1773d/4
>
> Lucas
>
>
This helped a lot... it's working now :) Thanks guys!!!
Patrick
Thanks again, Scott. No success yet though.
I uninstalled Oracle instant client 12.1 using dpkg, downloaded RPMs for
instant client 10.2 and installed them with alien.
I also downloaded oracle_fdw 1.4 and installed it, since I was getting this
error with oracle_fdw 1.5:
---
postgres=# create exte
30 matches
Mail list logo
