Re: [ADMIN] Socket & TCP connections

2010-03-29 Thread Guillaume Lelarge
Le 29/03/2010 04:04, Nilesh Govindarajan a écrit : > Hi, it seems to be working now. Can somebody explain to me how ? See > this pg_hba.conf - > > # "local" is for Unix domain socket connections only > local all root trust > local all all md5 > # IPv4 local connections: > #host all root 127.0.0.1/

Re: [ADMIN] Socket & TCP connections

2010-03-29 Thread Nilesh Govindarajan
On 03/29/2010 12:50 PM, Guillaume Lelarge wrote: Le 29/03/2010 04:04, Nilesh Govindarajan a écrit : Hi, it seems to be working now. Can somebody explain to me how ? See this pg_hba.conf - # "local" is for Unix domain socket connections only local all root trust local all all md5 # IPv4 local co

[ADMIN] Migration of PGDATA

2010-03-29 Thread Martin Münstermann
Hi, is it safe to move the PGDATA directory from one system to another when migrating from one operating system to another? For example: migrating from Debian to RHEL, or from RHEL4 to RHEL5? The database is of course shutdown properly, and the PG major versions match. Or is a dump/restore neces

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Guillaume Lelarge
Le 29/03/2010 11:31, "Martin Münstermann" a écrit : > [...] > is it safe to move the PGDATA directory from one system to another when > migrating from one operating system to another? > For example: migrating from Debian to RHEL, or from RHEL4 to RHEL5? > The database is of course shutdown properl

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Robert Joosten
Hi, > is it safe to move the PGDATA directory from one system to another when > migrating from one operating system to another? > For example: migrating from Debian to RHEL, or from RHEL4 to RHEL5? > The database is of course shutdown properly, and the PG major versions match. > Or is a dump/rest

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Martin Münstermann
Hi, > > is it safe to move the PGDATA directory from one system to another when > migrating from one operating system to another? > > For example: migrating from Debian to RHEL, or from RHEL4 to RHEL5? > > The database is of course shutdown properly, and the PG major versions > match. > > Or is a

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Renato Oliveira
Only out of curiosity, is your current server 32 bit or 64? Are you migrating 32 to 32 or 64 to 64? Thank you Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 http://www.grant.co.uk/ Grant Instruments (Cambridge)

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Martin Münstermann
Hi, > > is it safe to move the PGDATA directory from one system to another when > migrating from one operating system to another? > > For example: migrating from Debian to RHEL, or from RHEL4 to RHEL5? > > The database is of course shutdown properly, and the PG major versions > match. > > > > Or

Re: [ADMIN] ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory

2010-03-29 Thread ALEXANDER JOSE
Good morning You have to revise the base folder to create postgres when you perform the initial installation and verify the relation fallanado that I spend And it turned out he had a folder in C: \ Program Files \ PostgreSQL \ 8.2 \ data \ base folder exists the number 1, this is where the

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Tom Lane
=?iso-8859-1?Q?=22Martin_M=FCnstermann=22?= writes: > In case it does not work great, what kind of problems would we experience? In theory pg_control contains enough information to detect such compatibility problems, so that you'd get a refusal to start. In practice, maybe not, and the consequenc

[ADMIN] Virtualization vs. sharing a server

2010-03-29 Thread Ramiro Barreca
At this moment we are considering a plan for upgrading many servers in our datacenter. As this is a very heterogeneous platform (from Oracle 10g, SQL Server 2008, Firebird 2.1, Mysql 5, Postgre 8.4 up to Informix 5 and even COBOL apps) whe are evaluating Virtualization or just sharing a server amon

Re: [ADMIN] Virtualization vs. sharing a server

2010-03-29 Thread Michael Gould
Ramiro, I don't know why virtualization is considered a no-no.  We use VMware ESX.  On some smaller applications we run both the application and database on the virutal machine.  We've not had a issue with this combination in 5+ years.  We also have 6 images that run on 2 machines just for th

Re: [ADMIN] Virtualization vs. sharing a server

2010-03-29 Thread Greg Smith
Michael Gould wrote: I don't know why virtualization is considered a no-no...Since these are all quad core with 32 gig running Windows 2003 64 bit, we can run about 100 users concurrently on each application server before we start to see a strain. You answered your own question here. Ram

Re: [ADMIN] Virtualization vs. sharing a server

2010-03-29 Thread Greg Smith
Ramiro Barreca wrote: 1. Is there a configuration option we need to consider to share this server? The two main configuration options that impact how much RAM PostgreSQL uses are shared_buffers and work_mem. If the server is shared, you just need to avoid tuning those upwards as f

Re: [ADMIN] ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory

2010-03-29 Thread Alex Hunsaker
On Sun, Mar 28, 2010 at 16:27, Mike Williams wrote: > Test are para-virt VMs with "regular" kernels, production are real > machines with hardened kernels (grsec+pax). Ive seen this error on a few boxes around here, using a non grsec kernel fixes it. I never bothered to report it because I cant r