ery easy to compil with ubuntu (use package system to
>> get dependecies, then simply sudo ./autogen.sh, sudo ./configure, make , sudo
>> make install)
>
> Yes, that is the order I have head. You can upgrade postgis from 1.5 to
> 2.1 on the old server, then use pg_upgrade to upgrade
y tips on the procedure are greatly welcome :-)
Frank
- --
Frank BRONIEWSKI
METRICO s.à r.l.
géomètres
technologies d'information géographique
rue des Romains 36
L-5433 NIEDERDONVEN
tél.: +352 26 74 94 - 28
fax.: +352 26 74 94 99
http://www.metrico.lu
-BEGIN PGP SIGNATURE-
Ve
nting this? I never use this switch
and my .pgpass is used by shell scripts and other programs ...
Frank
--
Frank BRONIEWSKI
METRICO s.à r.l.
géomètres
technologies d'information géographique
rue des Romains 36
L-5433 NIEDERDONVEN
tél.: +352 26 74 94 - 28
fax.: +352 26 74 94 99
http://www.
FYI
http://freebsd.1045724.n5.nabble.com/Postgresql-related-memory-question-td5759467.html
Am 2012-11-07 10:28, schrieb Achilleas Mantzios:
On Τετ 07 Νοε 2012 09:42:47 Frank Broniewski wrote:
Hey, this is really cool. I directly tried the script and there's a line
from the output that c
schrieb Achilleas Mantzios:
Vick,
fantastic script, thanx! FreeBSD sysctl system is awesome!
On Τρι 06 Νοε 2012 14:33:43 Vick Khera wrote:
On Mon, Nov 5, 2012 at 10:11 AM, Frank Broniewski wrote:
and this is after a few hours of running:
Mem: 91M Active, 17G Inact, 3983M Wired, 1526M Cache, 3
postgresql processes?
Take note that shared mem should be recorded for each and every postmaster
running.
On Δευ 05 Νοε 2012 14:36:44 Frank Broniewski wrote:
Hi,
thank you for your feedback. I had a look at those commands and their
output, especially in conjunction with the SEGSZ value from icps -a
ght be the maintenance_work_mem, which is set to 4GB?
Many thanks,
Frank
Am 2012-11-05 12:14, schrieb Achilleas Mantzios:
ipcs in FreeBSD is a little ... tricky.
ipcs -M
ipcs -m
ipcs -am
could be your friends
On Δευ 05 Νοε 2012 11:22:46 Frank Broniewski wrote:
Hi,
I am running a PostgreSQL server
fers = 8GB # pgtune wizard 2012-04-04
max_connections = 100
synchronous_commit = off
So any help finding out why my system "looses" some RAM is greatly
appreciated :-) If more information is needed I will gladly provide it.
Frank
--
Frank BRONIEWSKI
METRICO s.à r.l.
géomètres
techno