Re: [ADMIN] Perl Libraries and Postgres

2011-02-15 Thread Sam Stearns
Thanks, Alex! I will take a look at your recommendations and keep you posted. Sam On Sat, Feb 12, 2011 at 3:28 AM, Alex Hunsaker wrote: > On Thu, Feb 10, 2011 at 03:24, Sam Stearns wrote: >> Thanks, Norbert! >> >> I'll run the perl 5.10 upgrade past the guys. >> >> Sam >> >> On Thu, Feb 10, 20

[ADMIN] cp1250 problem

2011-02-15 Thread Lukasz Brodziak
Hello, How can I set PostgreSQL locale and encoding to be pl_PL.cp1250 all I can do is pl_PL.UTF-8. I have PG 8.2.4 on Ubuntu 10.04 (polish version). -- Łukasz Brodziak "What if everyting around You isn't quite as it seems, What if all the world You think You know is an inelaborate dream When Yo

Re: [ADMIN] cp1250 problem

2011-02-15 Thread Achilleas Mantzios
Στις Tuesday 15 February 2011 12:44:31 ο/η Lukasz Brodziak έγραψε: > Hello, > > How can I set PostgreSQL locale and encoding to be pl_PL.cp1250 all I > can do is pl_PL.UTF-8. > I have PG 8.2.4 on Ubuntu 10.04 (polish version). > I had similar issues with the Greek ISO locale/encoding and the UTF

Re: [ADMIN] pg_dump not working

2011-02-15 Thread Kevin Grittner
Bineeta Guha wrote: > When I used pg_dump then after few minutes it shows error > > This probably means the server terminated abnormally > before or while processing the request. pg_dump: The command was: > FETCH 100 FROM _pg_dump_cursor > > Before 2 month backup running normal. But few

Re: [ADMIN] mapping libraries

2011-02-15 Thread Fabricio
no no no... is not about upgrade libraries, is about a super user failing to "create function ... language c" and with this avoid a super user gets a shell creating the function "system()" in the libc.so. In postgres 8.2 every library intented for use with postgres must carry a magic block

[ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
All, I am using Ubuntu 10.04 and Postgres 8.4, I have been trying to move my data dir to another device for the past couple of days but ran into a lot of problems. I did the following: 1. Copy the contents of /var/lib/postgresql/8.4/main to my folder. 2. Changed the data_directory in postgresql.

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Scott Mead
On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy wrote: > All, > > I am using Ubuntu 10.04 and Postgres 8.4, I have been trying to move > my data dir to another device for the past couple of days but ran into > a lot of problems. > > I did the following: > > 1. Copy the contents of /var/lib/p

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
None. The log is empty. Thanks, Sairam Krishnamurthy +1 612 859 8161 On Tue, Feb 15, 2011 at 3:45 PM, Scott Mead wrote: > > On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy > wrote: >> >> All, >> >> I am using Ubuntu 10.04 and Postgres 8.4, I have been trying to move >> my data dir to a

Re: [ADMIN] cp1250 problem

2011-02-15 Thread Jan-Peter Seifert
Hello, Am 15.02.2011 12:26, schrieb Achilleas Mantzios: > Στις Tuesday 15 February 2011 12:44:31 ο/η Lukasz Brodziak έγραψε: >> Hello, >> >> How can I set PostgreSQL locale and encoding to be pl_PL.cp1250 all I >> can do is pl_PL.UTF-8. >> I have PG 8.2.4 on Ubuntu 10.04 (polish version). There a

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Frederiko Costa
I would recommend to create the data area in the destination pgsql server and dump the source database into it, rather than copying the data directory. On Tue, Feb 15, 2011 at 1:41 PM, Sairam Krishnamurthy wrote: > All, > > I am using Ubuntu 10.04 and Postgres 8.4, I have been trying to move > my

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
Can you explain a bit? I dint get what you mean data area. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:09 PM, Frederiko Costa wrote: I would recommend to create the data area in the destination pgsql server and dump the source database into it, rather than copying the data di

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Scott Mead
On Tue, Feb 15, 2011 at 4:58 PM, Sairam Krishnamurthy wrote: > None. The log is empty. > Can you manually start the database as the postgres user: /usr/lib/postgresql/8.4/bin/pg_ctl start -D /media/extension/var/lib/postgresql/8.4/main/ -o config_file="/etc/postgresql/8.4/main/postgresql.conf"

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
Scott, I get this error. server starting krishnam@nipa-umh:/media/extension/var/lib$ postgres: invalid argument: "config_file=/etc/postgresql/8.4/main/postgresql.conf" tried with both -o and -c arguments. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:27 PM, Scott Mead wrote

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Scott Mead
On Tue, Feb 15, 2011 at 5:32 PM, Sairam Krishnamurthy wrote: > Scott, > > I get this error. > > server starting > krishnam@nipa-umh:/media/extension/var/lib$ postgres: invalid argument: > "config_file=/etc/postgresql/8.4/main/postgresql.conf" > > tried with both -o and -c arguments. > My mistake

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
Again, pg_ctl: could not open PID file "/media/extension/var/lib/postgresql/8.4/main/postmaster.pid": Permission denied Tried all the different ownership possible. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:37 PM, Scott Mead wrote: On Tue, Feb 15, 2011 at 5:32 PM, Sai

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Scott Mead
On Feb 15, 2011 5:44 PM, "Sairam Krishnamurthy" wrote: > > Again, > > pg_ctl: could not open PID file "/media/extension/var/lib/postgresql/8.4/main/postmaster.pid": Permission denied > > Tried all the different ownership possible. What about the permissions on your mountpoint? Are they too restr

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
Scott, I have 755 permission until "/media/extension/var/lib" and postgres owns the folder from postgresql. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:48 PM, Scott Mead wrote: On Feb 15, 2011 5:44 PM, "Sairam Krishnamurthy" > wrote: > > Agai

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Frederiko Costa
What I meant was that when you install postgresql, you initialize the area where your data directory will be. There you have the database, config files, logs, etc. Before you restore the DB into the new pgsql, as far as I'm aware, you have to create/init this area. On Tue, Feb 15, 2011 at 2:27 PM,

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
Frederiko, I will try that. I was hoping to have a better solution than to reinstall postgres. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:56 PM, Frederiko Costa wrote: What I meant was that when you install postgresql, you initialize the area where your data directory wil

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Frederiko Costa
You might find something in the documentation about migrating the data directory to another server. ~Fred Linkedin profile: http://www.linkedin.com/in/frederikocosta On Tue, Feb 15, 2011 at 2:58 PM, Sairam Krishnamurthy wrote: > Frederiko, > > I will try that. I was hoping to have a better sol

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
I followed the preferred way to migrate the data and ran into this problem. So i guess I am stuck here and cant get any help from the docs. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:59 PM, Frederiko Costa wrote: You might find something in the documentation about migrating

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Thomas Kellerer
Sairam Krishnamurthy, 15.02.2011 23:43: Again, pg_ctl: could not open PID file "/media/extension/var/lib/postgresql/8.4/main/postmaster.pid": Permission denied Tried all the different ownership possible. And you are sure you ran that as the postgres user? Thomas -- Sent via pgsql-admin ma