On 4 April 2014 11:03, 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 some of the
Steve Crawford wrote:
> 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 certificat
On 4/10/2014 1:01 AM, Albe Laurenz wrote:
If you are in a totally trusted environment, why would you use SSL?
Belt, and suspenders.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-genera
On Mon, 07 Apr 2014 11:04:23 +0100
"howardn...@selestial.com" wrote:
> Hi,
>
> just as I thought I had postgres mastered :) the ordering of strings is
> causing me some confusion.
>
> Can someone explain how the database orders strings in the ORDER BY command.
>
> My example:
>
> My databas
I would like to rename schemas without breaking the stored procedures in
them. Currently, this does not work if the stored procedure definition
contains a schema self-reference because that does not get renamed. I
tried "SET search_path FROM CURRENT", but that seems to expand the
search path
And it also tells you how to stop it --bibtex iirc
Sent from my iPhone
> On Apr 9, 2014, at 8:41 PM, Amit Langote wrote:
>
> 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 .
Code for db functions should be a repository. Easy edit and rerun
Sent from my iPhone
> On Apr 10, 2014, at 6:19 AM, Florian Weimer wrote:
>
> I would like to rename schemas without breaking the stored procedures in
> them. Currently, this does not work if the stored procedure definition
> c
On Apr 9, 2014, at 3: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?
Does there happen to be a Postgresql proxy, such as a modified pgbou
John R Pierce wrote:
> On 4/10/2014 1:01 AM, Albe Laurenz wrote:
>> If you are in a totally trusted environment, why would you use SSL?
> Belt, and suspenders.
I guess what I wanted to say was:
If you are concerned enough to use SSL, you should be concerned enough
to change your certificates.
To
i accept multiple "city, country" from users on-the-fly, and want to
dynamically map them.
i could create a table where i insert their multiple entries, and then
geocode that table for display.
but i also want to avoid giving write permission to the web user.
i could create a schema and restrict
On Wed, Apr 9, 2014 at 3:36 PM, François Beausoleil
wrote:
>
> 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
On 04/10/14 17:25, Christofer C. Bell wrote:
I'm not wanting to get after anyone here, but I want it on the record
that I am not the source of the above quote discouraging the use of
Ubuntu in a server role. That would be Bruce Momjian. While Bruce is
entitled to his opinion, it's not one I agre
Hi All;
We're setting up a HOT standby on Windows 2000 server and PostgreSQL 9.2
We do this:
1) stop both servers
2) copy the master data directory to the slave
3) edit the master postgresql.conf file as follows:
Modify the following listen_address = ‘*’
wal_level = hot_standby
max_wal_sender
On 04/10/2014 01:01 AM, Albe Laurenz wrote:
Steve Crawford wrote:
If you aren't and weren't running a vulnerable version or if the
vulnerable systems were entirely within a trusted network space with no
direct external access then you are probably at low to no risk and need
to evaluate the cos
On Fri, Apr 11, 2014 at 8:15 AM, CS_DBA wrote:
> Hi All;
>
> We're setting up a HOT standby on Windows 2000 server and PostgreSQL 9.2
>
> We do this:
> I've also tried this approach:
>
>
> 1) Master postgresql.conf file
> Modify the following settings:
> listen_address = '*'
> wal_level = hot_stan
On Thu, Apr 10, 2014 at 10:25 PM, Rob Sargent wrote:
> And it also tells you how to stop it --bibtex iirc
>
Yeah, it's a caution against a potentially harmful usage anyway. Users
should not use it at all.
I was just wondering if the description of the behavior, that is,
potential disappearance o
Amit Langote wrote:
> On Thu, Apr 10, 2014 at 10:25 PM, Rob Sargent wrote:
> > And it also tells you how to stop it --bibtex iirc
>
> Yeah, it's a caution against a potentially harmful usage anyway. Users
> should not use it at all.
>
> I was just wondering if the description of the behavior, th
On Fri, Apr 11, 2014 at 11:52 AM, Alvaro Herrera
wrote:
> Amit Langote wrote:
>> On Thu, Apr 10, 2014 at 10:25 PM, Rob Sargent wrote:
>> > And it also tells you how to stop it --bibtex iirc
>>
>> Yeah, it's a caution against a potentially harmful usage anyway. Users
>> should not use it at all.
>
On Thu, Apr 10, 2014 at 12: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
Basically it goes beyond what ppl would describe as OS holly wars.
If one chooses to go by FreeBSD, then he better be prepared to handle the
burden, both the part that is
imposed by the OS administration itself, as well as the part that is a side
effect of the different base system.
Example of
20 matches
Mail list logo
