On Tue, 08 Apr 2014 15:53:48 -0600
CS_DBA cs_...@consistentstate.com wrote:
Not sure yet (new client)... for now they simply want to force the
template column to be a valid cust_id, if it is not null...
It seems to be a different version of the textbook exercice involving
EMPLOYEE_ID and
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
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
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
On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil
franc...@teksol.info 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
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
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
using.
On 09/04/2014 03:42, Gaurav Jindal wrote:
Inline image 1
On Tue, Apr 8, 2014 at 5:21 PM, gaur...@gmail.com
mailto:gaur...@gmail.com 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.
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
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
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
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 are
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
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
franc...@teksol.info 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
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 that's
On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell
christofer.c.b...@gmail.com wrote:
On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil
franc...@teksol.info 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
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 exist
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 has a
Rob Richardson rdrichard...@rad-con.com 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
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
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-09 14:16:45
On Apr 9, 2014, at 1:33 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell
christofer.c.b...@gmail.com wrote:
On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil
franc...@teksol.info wrote:
Hi all!
Does PG perform that much better on
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,
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
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 while ago
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
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.
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
On Wed, Apr 9, 2014 at 2:56 PM, Steve Atkins st...@blighty.com wrote:
On Apr 9, 2014, at 1:33 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Wed, Apr 9, 2014 at 9:02 AM, Christofer C. Bell
christofer.c.b...@gmail.com wrote:
On Thu, Apr 3, 2014 at 11:03 PM, François Beausoleil
On Wed, Apr 9, 2014 at 2:32 PM, John R Pierce pie...@hogranch.com 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.
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 the
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?
encrypt the data
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.
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 able to
On Wed, 9 Apr 2014 14:41:46 +0100
MOHAMMED-BOUZIANE Ilyes i_mohammed_bouzi...@esi.dz 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
On Thu, Apr 10, 2014 at 1:02 AM, Raymond O'Donnell r...@iol.ie 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,
On Tue, Apr 8, 2014 at 6:32 PM, Tom Lane t...@sss.pgh.pa.us 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
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
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.
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
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
41 matches
Mail list logo