[GENERAL] What does "ERROR: failed to find parent tuple for heap-only tuple at (1192248,5) in table "fruits"" mean?

After being bitten by the bug mentioned in the release notes of 9.3.4, I have realized that a very small part of my data is corrupt, after doing a failover. The bug showed it self as duplicate rows, with the same primary key. Now I can easily afford to delete some data from my database if that’

[GENERAL] postgresql.conf question... CPU spikes

Hi all - We are running postgres 9.0 ( 32 bit ) + postgis 1.5.2 on Solaris Sparc M5000 with 64GB . Recently we are getting CPU utilitzation to 99% . In the config file shared_buffers=2GB. work_mem = 128MB effective_cache_size=48GB maintaince_work_mem= 500MB max_connections = 300 When t

[GENERAL] Help

Hi, My name is MOHAMMED BOUZIANE ILYES, i am an postgraduate student at the National high school of computing (ESI) algeirs- Algeria. my master thesis is "database replication based on snapshot isolation" I encounter somme difficulties to implement a middleware baesd replication with Libpq and c

Re: [GENERAL] Linux vs FreeBSD

On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil wrote: > Hi all! > > Does PG perform that much better on FreeBSD? I have some performance issues > on a Ubuntu 12.04 which I'd like to resolve. iowait varies a lot, between 5 > and 50%. Does FreeBSD better schedule I/O, which could alleviate s

[GENERAL] openssl heartbleed

Hi all, Our server is running Ubuntu Server 13.10 (we will soon upgrade to 14.04) and PostgreSQL 9.1. We use certificates for all client authentication on remote connections. The server certificate is self-signed. In light of the heartbleed bug, should we create a new server certificate an

Re: [GENERAL] openssl heartbleed

On Wed, Apr 09, 2014 at 11:54:43AM -0400, "Gabriel E. Sánchez Martínez" wrote: > self-signed. In light of the heartbleed bug, should we create a new > server certificate and replace all client certificates? My guess is > yes. This depends mostly on what version of openssl you were actually usin

Re: [GENERAL] import .sql file into PostgreSQL database

On 09/04/2014 03:42, Gaurav Jindal wrote: > Inline image 1 > > > On Tue, Apr 8, 2014 at 5:21 PM, > wrote: > > > - Your OS > Windows 7 > > - What version of PostgreSQL you have > 9.3.4 > > - What is in the SQL file you're trying to execute. > Tab

Re: [GENERAL] openssl heartbleed

On 04/09/2014 08:54 AM, "Gabriel E. Sánchez Martínez" wrote: Hi all, Our server is running Ubuntu Server 13.10 (we will soon upgrade to 14.04) and PostgreSQL 9.1. We use certificates for all client authentication on remote connections. The server certificate is self-signed. In light of the

Re: [GENERAL] openssl heartbleed

On Wed, Apr 9, 2014 at 10:54 AM, "Gabriel E. Sánchez Martínez" < gabrielesanc...@gmail.com> wrote: > Hi all, > > Our server is running Ubuntu Server 13.10 (we will soon upgrade to 14.04) > and PostgreSQL 9.1. We use certificates for all client authentication on > remote connections. The server c

[GENERAL] Refresh Postgres SSL certs?

Hello, In light of the "Heartbleed" OpenSSL bug[0,1], I'm wondering if I need to regenerate the SSL certs on my postgres installations[2] (at least the ones listening on more than localhost)? On Ubuntu it looks like there are symlinks at /var/lib/postgresql/9.1/main/server.{crt,key} pointing to /e

Re: [GENERAL] Refresh Postgres SSL certs?

On Wed, Apr 09, 2014 at 12:28:14PM -0700, Paul Jungwirth wrote: > Hello, > > In light of the "Heartbleed" OpenSSL bug[0,1], I'm wondering if I need > to regenerate the SSL certs on my postgres installations[2] (at least > the ones listening on more than localhost)? On Ubuntu it looks like > there

Re: [GENERAL] Refresh Postgres SSL certs?

> Have you read the Debian README? > /usr/share/doc/postgresql-*/README.Debian.gz Thank you for pointing me to that file. From /etc/share/doc/ssl-cert/README it sounds like the old snakeoil cert is already self-signed, so that's promising. So I take it that psql and the postgres client library won

Re: [GENERAL] Linux vs FreeBSD

On Wed, Apr 9, 2014 at 10:02:07AM -0500, Christofer C. Bell wrote: > On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil > wrote: > > Hi all! > > > > Does PG perform that much better on FreeBSD? I have some performance issues > > on a Ubuntu 12.04 which I'd like to resolve. iowait varies a lot,

Re: [GENERAL] Refresh Postgres SSL certs?

On Wed, Apr 09, 2014 at 12:59:53PM -0700, Paul Jungwirth wrote: > > Have you read the Debian README? > > /usr/share/doc/postgresql-*/README.Debian.gz > > Thank you for pointing me to that file. From > /etc/share/doc/ssl-cert/README it sounds like the old snakeoil cert is > already self-signed, so

Re: [GENERAL] Linux vs FreeBSD

On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell wrote: > On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil > wrote: >> Hi all! >> >> Does PG perform that much better on FreeBSD? I have some performance issues >> on a Ubuntu 12.04 which I'd like to resolve. iowait varies a lot, between 5 >

[GENERAL] How do I find out where this warning is coming from?

I've get several processes running that use the same database. My database log file is filled with these: 2014-04-09 14:16:45 EDT WARNING: invalid value for parameter "search_path": "public, operationsplanning, cooling_stands" 2014-04-09 14:16:45 EDT DETAIL: schema "cooling_stands" does not ex

Re: [GENERAL] Linux vs FreeBSD

Le 2014-04-09 à 16:20, Bruce Momjian a écrit : > On Wed, Apr 9, 2014 at 10:02:07AM -0500, Christofer C. Bell wrote: > > This highlights a more fundamental problem of the difference between a > workstation-based on OS like Ubuntu and a server-based one like Debian > or FreeBSD. I know Ubuntu ha

Re: [GENERAL] How do I find out where this warning is coming from?

Rob Richardson writes: > I've get several processes running that use the same database. My database > log file is filled with these: > 2014-04-09 14:16:45 EDT WARNING: invalid value for parameter "search_path": > "public, operationsplanning, cooling_stands" > 2014-04-09 14:16:45 EDT DETAIL: s

[GENERAL] encrypting data stored in PostgreSQL

Hi All; We have a client with this requirement: At rest data must be encrypted with a unique client key Any thoughts on how to pull this off for PostgreSQL stored data? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] How do I find out where this warning is coming from?

On 04/09/2014 10:34 PM, Rob Richardson wrote: > > I’ve get several processes running that use the same database. My > database log file is filled with these: > > 2014-04-09 14:16:45 EDT WARNING: invalid value for parameter > "search_path": "public, operationsplanning, cooling_stands" > > 2014-04-

Re: [GENERAL] Linux vs FreeBSD

On Apr 9, 2014, at 1:33 PM, Scott Marlowe wrote: > On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell > wrote: >> On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil >> wrote: >>> Hi all! >>> >>> Does PG perform that much better on FreeBSD? I have some performance issues >>> on a Ubuntu 12.

Re: [GENERAL] encrypting data stored in PostgreSQL

On 4/9/2014 1:40 PM, CS_DBA wrote: Hi All; We have a client with this requirement: At rest data must be encrypted with a unique client key Any thoughts on how to pull this off for PostgreSQL stored data? encrypt the data in the client application before sending it to the database server, de

Re: [GENERAL] encrypting data stored in PostgreSQL

On 04/09/2014 02:52 PM, John R Pierce wrote: On 4/9/2014 1:40 PM, CS_DBA wrote: Hi All; We have a client with this requirement: At rest data must be encrypted with a unique client key Any thoughts on how to pull this off for PostgreSQL stored data? encrypt the data in the client application

Re: [GENERAL] encrypting data stored in PostgreSQL

> > On 04/09/2014 02:52 PM, John R Pierce wrote: > > On 4/9/2014 1:40 PM, CS_DBA wrote: > > Hi All; > > We have a client with this requirement: > > At rest data must be encrypted with a unique client key > > Any thoughts on how to pull this off for PostgreSQL stored data? > > I looked at this a whi

Re: [GENERAL] encrypting data stored in PostgreSQL

On Wed, Apr 09, 2014 at 02:16:34PM -0700, Ken Tanzer wrote: > > Any thoughts on how to pull this off for PostgreSQL stored data? > > > > I looked at this a while ago because I have clients who might require this > in the future. ISTM you should be able to have your PG data directory > stored on an

Re: [GENERAL] encrypting data stored in PostgreSQL

On 4/9/2014 2:16 PM, Ken Tanzer wrote: I looked at this a while ago because I have clients who might require this in the future. ISTM you should be able to have your PG data directory stored on an encrypted filesystem. I believe this will decrease performance, but I have no idea by how much.

Re: [GENERAL] encrypting data stored in PostgreSQL

On 4/9/2014 2:07 PM, Rob Sargent wrote: encrypt the data in the client application before sending it to the database server, decrypt it in the client when you need it back. How does that affect backend sql reporting?\ does this backend sql reporting system need access to the contents of t

Re: [GENERAL] Linux vs FreeBSD

On Wed, Apr 9, 2014 at 2:56 PM, Steve Atkins wrote: > > On Apr 9, 2014, at 1:33 PM, Scott Marlowe wrote: > >> On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell >> wrote: >>> On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil >>> wrote: Hi all! Does PG perform that much better

Re: [GENERAL] encrypting data stored in PostgreSQL

On Wed, Apr 9, 2014 at 2:32 PM, John R Pierce wrote: > On 4/9/2014 2:16 PM, Ken Tanzer wrote: > >> I looked at this a while ago because I have clients who might require >> this in the future. ISTM you should be able to have your PG data directory >> stored on an encrypted filesystem. I believe

Re: [GENERAL] Linux vs FreeBSD

On 04/09/14 14:46, Scott Marlowe wrote: > > I'm not deploying any new distro version that soon. :) I know folks > just putting 12.04 into prod to replace etch and lenny. :) You can easily get the 3.11.0 kernel on 12.04.4 LTS by installing the linux-generic-lts-saucy package. IIRC, the fix for th

Re: [GENERAL] encrypting data stored in PostgreSQL

On Wed, Apr 9, 2014 at 01:52:51PM -0700, John R Pierce wrote: > On 4/9/2014 1:40 PM, CS_DBA wrote: > >Hi All; > > > >We have a client with this requirement: > > > >At rest data must be encrypted with a unique client key > > > >Any thoughts on how to pull this off for PostgreSQL stored data? > > e

Re: [GENERAL] After paying PG Associate Cert. Exam what's the next step?

Well, at the end i received my code and a link to access to the certification exam portal and the dummy exam, after half a day or something like that. Regards. *** Oscar Calderon Analista de Sistemas Soluciones Aplicativas S.A. de C.V. www.solucionesaplicativas.com Cel. (5

Re: [GENERAL] encrypting data stored in PostgreSQL

On 9.4.2014 23:28, Martijn van Oosterhout wrote: > On Wed, Apr 09, 2014 at 02:16:34PM -0700, Ken Tanzer wrote: >>> Any thoughts on how to pull this off for PostgreSQL stored data? >>> >>> I looked at this a while ago because I have clients who might >> require this in the future. ISTM you should be

[GENERAL] Capture the SQL statement text with libpq [was: Re: Help]

On Wed, 9 Apr 2014 14:41:46 +0100 MOHAMMED-BOUZIANE Ilyes wrote: > my master thesis is "database replication based on snapshot isolation" > I encounter somme difficulties to implement a middleware baesd > replication with Libpq and c language, for that, I need somme hints to > achieve this work,

Re: [GENERAL] import .sql file into PostgreSQL database

On Thu, Apr 10, 2014 at 1:02 AM, Raymond O'Donnell wrote: > I think that message is coming from the OS; messages from Postgres are > usual more specific, for example, "Permission denied for relation". > > It looks as if you haven't the OS permissions to read the SQL file. On Windows, you need

Re: [GENERAL] is there a way to firmly cap postgres worker memory consumption?

On Tue, Apr 8, 2014 at 6:32 PM, Tom Lane wrote: > Well, here's the problem: > > ExprContext: 812638208 total in 108 blocks; 183520 free (171 > > chunks); 812454688 used > > So something involved in expression evaluation is eating memory. > Looking at the query itself, I'd have to bet on t

[GENERAL] About upgrading a (tuple?) lock in a rollback'd sub-transaction

Hi, Currently there is a warning against the following in manual: BEGIN; SELECT * FROM mytable WHERE key = 1 FOR UPDATE; SAVEPOINT s; UPDATE mytable SET ... WHERE key = 1; ROLLBACK TO s; here: http://www.postgresql.org/docs/9.2/static/sql-select.html IIUC, it says if the lock-upgrading sub-tran

Re: [GENERAL] Linux vs FreeBSD

Not a great help with which Linux to run, nor Postgres focused, but may be of interest, & very relevant to the subject line.. Given the likely respective numbers of each OS actually out there, I'd suggests BSD is very over-represented in the high uptime list which is suggestive. http://uptime.n

Re: [GENERAL] postgresql.conf question... CPU spikes

On 04/09/2014 09:43 AM, Bala Venkat wrote: Hi all - We are running postgres 9.0 ( 32 bit ) + postgis 1.5.2 on Solaris Sparc M5000 with 64GB . Recently we are getting CPU utilitzation to 99% . In the config file shared_buffers=2GB. work_mem = 128MB effective_cache_size=48GB maintainc

Re: [GENERAL] Linux vs FreeBSD

On Wednesday, April 09, 2014 09:02:02 PM Brent Wood wrote: > Given the likely respective numbers of each OS actually out there, I'd > suggests BSD is very over-represented in the high uptime list which is > suggestive. Suggestive of ... sysadmins who don't do kernel updates? -- Sent via pgsql-