pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMoving the data directory
18+ messages / 6 participants
[nested] [flat]
* Moving the data directory
@ 2011-02-15 21:41 Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 21:45 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 22:09 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
2011-02-16 12:51 ` Re: Moving the data directory Greg Smith <greg@2ndquadrant.com>
0 siblings, 3 replies; 18+ messages in thread
From: Sairam Krishnamurthy @ 2011-02-15 21:41 UTC (permalink / raw)
To: pgsql-admin
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.conf.
When I start postgres using /etc/init.d script I get the following error,
* Starting PostgreSQL 8.4 database server
* Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
/usr/lib/postgresql/8.4/bin/pg_ctl start -D
/media/extension/var/lib/postgresql/8.4/main/ -l
/var/log/postgresql/postgresql-8.4-main.log -s -o -c
config_file="/etc/postgresql/8.4/main/postgresql.conf" :
I tried changing the ownership of the
/media/extension/var/lib/postgresql dir to <myusername>, postgres and
root. Now of them worked and I keep getting the same error message.
I found a lot of similar problems online but none had a solution.
Can someone help me with this?
TIA
Thanks,
Sairam Krishnamurthy
+1 612 859 8161
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
@ 2011-02-15 21:45 ` Scott Mead <scottm@openscg.com>
2011-02-15 21:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2 siblings, 1 reply; 18+ messages in thread
From: Scott Mead @ 2011-02-15 21:45 UTC (permalink / raw)
To: Sairam Krishnamurthy <kmsram420@gmail.com>; +Cc: pgsql-admin
On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy
<kmsram420@gmail.com>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/postgresql/8.4/main to my folder.
> 2. Changed the data_directory in postgresql.conf.
>
> When I start postgres using /etc/init.d script I get the following error,
>
> * Starting PostgreSQL 8.4 database server
> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> /media/extension/var/lib/postgresql/8.4/main/ -l
> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>
>
> I tried changing the ownership of the
> /media/extension/var/lib/postgresql dir to <myusername>, postgres and
> root. Now of them worked and I keep getting the same error message.
>
> I found a lot of similar problems online but none had a solution.
>
> Can someone help me with this?
>
Do you have any useful information in the logs?
/var/log/postgresql/postgresql-8.4-main.log
--Scott
>
> TIA
>
> Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 21:45 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
@ 2011-02-15 21:58 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
0 siblings, 1 reply; 18+ messages in thread
From: Sairam Krishnamurthy @ 2011-02-15 21:58 UTC (permalink / raw)
To: Scott Mead <scottm@openscg.com>; +Cc: pgsql-admin
None. The log is empty.
Thanks,
Sairam Krishnamurthy
+1 612 859 8161
On Tue, Feb 15, 2011 at 3:45 PM, Scott Mead <scottm@openscg.com> wrote:
>
> On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy <kmsram420@gmail.com>
> 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/postgresql/8.4/main to my folder.
>> 2. Changed the data_directory in postgresql.conf.
>>
>> When I start postgres using /etc/init.d script I get the following error,
>>
>> * Starting PostgreSQL 8.4 database server
>> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
>> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
>> /media/extension/var/lib/postgresql/8.4/main/ -l
>> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
>> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>>
>>
>> I tried changing the ownership of the
>> /media/extension/var/lib/postgresql dir to <myusername>, postgres and
>> root. Now of them worked and I keep getting the same error message.
>>
>> I found a lot of similar problems online but none had a solution.
>>
>> Can someone help me with this?
>
> Do you have any useful information in the logs?
>
> /var/log/postgresql/postgresql-8.4-main.log
>
> --Scott
>
>
>
>>
>> TIA
>>
>> Thanks,
>> Sairam Krishnamurthy
>> +1 612 859 8161
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 21:45 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 21:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
@ 2011-02-15 22:27 ` Scott Mead <scottm@openscg.com>
2011-02-15 22:32 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Scott Mead @ 2011-02-15 22:27 UTC (permalink / raw)
To: Sairam Krishnamurthy <kmsram420@gmail.com>; +Cc: pgsql-admin
On Tue, Feb 15, 2011 at 4:58 PM, Sairam Krishnamurthy
<kmsram420@gmail.com>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"
--Scott
>
> Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
>
>
> On Tue, Feb 15, 2011 at 3:45 PM, Scott Mead <scottm@openscg.com> wrote:
> >
> > On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy <
> kmsram420@gmail.com>
> > 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/postgresql/8.4/main to my folder.
> >> 2. Changed the data_directory in postgresql.conf.
> >>
> >> When I start postgres using /etc/init.d script I get the following
> error,
> >>
> >> * Starting PostgreSQL 8.4 database server
> >> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
> >> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> >> /media/extension/var/lib/postgresql/8.4/main/ -l
> >> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
> >> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
> >>
> >>
> >> I tried changing the ownership of the
> >> /media/extension/var/lib/postgresql dir to <myusername>, postgres and
> >> root. Now of them worked and I keep getting the same error message.
> >>
> >> I found a lot of similar problems online but none had a solution.
> >>
> >> Can someone help me with this?
> >
> > Do you have any useful information in the logs?
> >
> > /var/log/postgresql/postgresql-8.4-main.log
> >
> > --Scott
> >
> >
> >
> >>
> >> TIA
> >>
> >> Thanks,
> >> Sairam Krishnamurthy
> >> +1 612 859 8161
> >>
> >> --
> >> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> >> To make changes to your subscription:
> >> http://www.postgresql.org/mailpref/pgsql-admin
> >
> >
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 21:45 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 21:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
@ 2011-02-15 22:32 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:37 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
0 siblings, 1 reply; 18+ messages in thread
From: Sairam Krishnamurthy @ 2011-02-15 22:32 UTC (permalink / raw)
To: Scott Mead <scottm@openscg.com>; +Cc: pgsql-admin
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:
> /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
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 21:45 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 21:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 22:32 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
@ 2011-02-15 22:37 ` Scott Mead <scottm@openscg.com>
2011-02-15 22:43 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Scott Mead @ 2011-02-15 22:37 UTC (permalink / raw)
To: Sairam Krishnamurthy <kmsram420@gmail.com>; +Cc: pgsql-admin
On Tue, Feb 15, 2011 at 5:32 PM, Sairam Krishnamurthy
<kmsram420@gmail.com>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, I screwed up!
/usr/lib/postgresql/8.4/bin/pg_ctl start -D
/media/extension/var/lib/postgresql/8.4/main/ -o "-c
config_file="/etc/postgresql/8.4/main/postgresql.conf"
(-c inside the quotes)
--Scott
Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
>
> On 02/15/2011 04:27 PM, Scott Mead wrote:
>
> /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
>
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 21:45 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 21:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 22:32 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:37 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
@ 2011-02-15 22:43 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:48 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 23:25 ` Re: Moving the data directory Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 2 replies; 18+ messages in thread
From: Sairam Krishnamurthy @ 2011-02-15 22:43 UTC (permalink / raw)
To: Scott Mead <scottm@openscg.com>; +Cc: pgsql-admin
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, Sairam Krishnamurthy
> <kmsram420@gmail.com <mailto:kmsram420@gmail.com>> 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, I screwed up!
>
> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> /media/extension/var/lib/postgresql/8.4/main/ -o "-c
> config_file="/etc/postgresql/8.4/main/postgresql.conf"
>
> (-c inside the quotes)
>
> --Scott
>
> Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
>
> On 02/15/2011 04:27 PM, Scott Mead wrote:
>> /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
>
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 21:45 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 21:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 22:32 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:37 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 22:43 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
@ 2011-02-15 22:48 ` Scott Mead <scottm@openscg.com>
2011-02-15 22:54 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
1 sibling, 1 reply; 18+ messages in thread
From: Scott Mead @ 2011-02-15 22:48 UTC (permalink / raw)
To: Sairam Krishnamurthy <kmsram420@gmail.com>; +Cc: pgsql-admin
On Feb 15, 2011 5:44 PM, "Sairam Krishnamurthy" <kmsram420@gmail.com> 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 restrictive for
the postgres user? ( or any of the higher level dirs)
>
> 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, Sairam Krishnamurthy <
kmsram420@gmail.com> 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, I screwed up!
>>
>> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
/media/extension/var/lib/postgresql/8.4/main/ -o "-c
config_file="/etc/postgresql/8.4/main/postgresql.conf"
>>
>> (-c inside the quotes)
>>
>> --Scott
>>
>>> Thanks,
>>> Sairam Krishnamurthy
>>> +1 612 859 8161
>>>
>>>
>>> On 02/15/2011 04:27 PM, Scott Mead wrote:
>>>>
>>>> /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
>>
>>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 21:45 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 21:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 22:32 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:37 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 22:43 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:48 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
@ 2011-02-15 22:54 ` Sairam Krishnamurthy <kmsram420@gmail.com>
0 siblings, 0 replies; 18+ messages in thread
From: Sairam Krishnamurthy @ 2011-02-15 22:54 UTC (permalink / raw)
To: Scott Mead <scottm@openscg.com>; +Cc: pgsql-admin
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" <kmsram420@gmail.com
> <mailto:kmsram420@gmail.com>> 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
> restrictive for the postgres user? ( or any of the higher level dirs)
> >
> > 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, Sairam Krishnamurthy
> <kmsram420@gmail.com <mailto:kmsram420@gmail.com>> 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, I screwed up!
> >>
> >> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> /media/extension/var/lib/postgresql/8.4/main/ -o "-c
> config_file="/etc/postgresql/8.4/main/postgresql.conf"
> >>
> >> (-c inside the quotes)
> >>
> >> --Scott
> >>
> >>> Thanks,
> >>> Sairam Krishnamurthy
> >>> +1 612 859 8161
> >>>
> >>>
> >>> On 02/15/2011 04:27 PM, Scott Mead wrote:
> >>>>
> >>>> /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
> >>
> >>
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 21:45 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 21:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 22:32 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:37 ` Re: Moving the data directory Scott Mead <scottm@openscg.com>
2011-02-15 22:43 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
@ 2011-02-15 23:25 ` Thomas Kellerer <spam_eater@gmx.net>
1 sibling, 0 replies; 18+ messages in thread
From: Thomas Kellerer @ 2011-02-15 23:25 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
@ 2011-02-15 22:09 ` Frederiko Costa <frederiko@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2 siblings, 1 reply; 18+ messages in thread
From: Frederiko Costa @ 2011-02-15 22:09 UTC (permalink / raw)
To: Sairam Krishnamurthy <kmsram420@gmail.com>; +Cc: pgsql-admin
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
<kmsram420@gmail.com> 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/postgresql/8.4/main to my folder.
> 2. Changed the data_directory in postgresql.conf.
>
> When I start postgres using /etc/init.d script I get the following error,
>
> * Starting PostgreSQL 8.4 database server
> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> /media/extension/var/lib/postgresql/8.4/main/ -l
> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>
>
> I tried changing the ownership of the
> /media/extension/var/lib/postgresql dir to <myusername>, postgres and
> root. Now of them worked and I keep getting the same error message.
>
> I found a lot of similar problems online but none had a solution.
>
> Can someone help me with this?
>
> TIA
>
> Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:09 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
@ 2011-02-15 22:27 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:56 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Sairam Krishnamurthy @ 2011-02-15 22:27 UTC (permalink / raw)
To: Frederiko Costa <frederiko@gmail.com>; +Cc: pgsql-admin
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 directory.
>
> On Tue, Feb 15, 2011 at 1:41 PM, Sairam Krishnamurthy
> <kmsram420@gmail.com> 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/postgresql/8.4/main to my folder.
>> 2. Changed the data_directory in postgresql.conf.
>>
>> When I start postgres using /etc/init.d script I get the following error,
>>
>> * Starting PostgreSQL 8.4 database server
>> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
>> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
>> /media/extension/var/lib/postgresql/8.4/main/ -l
>> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
>> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>>
>>
>> I tried changing the ownership of the
>> /media/extension/var/lib/postgresql dir to<myusername>, postgres and
>> root. Now of them worked and I keep getting the same error message.
>>
>> I found a lot of similar problems online but none had a solution.
>>
>> Can someone help me with this?
>>
>> TIA
>>
>> Thanks,
>> Sairam Krishnamurthy
>> +1 612 859 8161
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:09 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
@ 2011-02-15 22:56 ` Frederiko Costa <frederiko@gmail.com>
2011-02-15 22:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Frederiko Costa @ 2011-02-15 22:56 UTC (permalink / raw)
To: Sairam Krishnamurthy <kmsram420@gmail.com>; +Cc: pgsql-admin
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, Sairam Krishnamurthy
<kmsram420@gmail.com> wrote:
> 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 directory.
>
> On Tue, Feb 15, 2011 at 1:41 PM, Sairam Krishnamurthy
> <kmsram420@gmail.com> 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/postgresql/8.4/main to my folder.
> 2. Changed the data_directory in postgresql.conf.
>
> When I start postgres using /etc/init.d script I get the following error,
>
> * Starting PostgreSQL 8.4 database server
> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> /media/extension/var/lib/postgresql/8.4/main/ -l
> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>
>
> I tried changing the ownership of the
> /media/extension/var/lib/postgresql dir to <myusername>, postgres and
> root. Now of them worked and I keep getting the same error message.
>
> I found a lot of similar problems online but none had a solution.
>
> Can someone help me with this?
>
> TIA
>
> Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:09 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:56 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
@ 2011-02-15 22:58 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:59 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Sairam Krishnamurthy @ 2011-02-15 22:58 UTC (permalink / raw)
To: Frederiko Costa <frederiko@gmail.com>; +Cc: pgsql-admin
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 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, Sairam Krishnamurthy
> <kmsram420@gmail.com> wrote:
>> 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 directory.
>>
>> On Tue, Feb 15, 2011 at 1:41 PM, Sairam Krishnamurthy
>> <kmsram420@gmail.com> 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/postgresql/8.4/main to my folder.
>> 2. Changed the data_directory in postgresql.conf.
>>
>> When I start postgres using /etc/init.d script I get the following error,
>>
>> * Starting PostgreSQL 8.4 database server
>> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
>> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
>> /media/extension/var/lib/postgresql/8.4/main/ -l
>> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
>> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>>
>>
>> I tried changing the ownership of the
>> /media/extension/var/lib/postgresql dir to<myusername>, postgres and
>> root. Now of them worked and I keep getting the same error message.
>>
>> I found a lot of similar problems online but none had a solution.
>>
>> Can someone help me with this?
>>
>> TIA
>>
>> Thanks,
>> Sairam Krishnamurthy
>> +1 612 859 8161
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:09 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:56 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
2011-02-15 22:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
@ 2011-02-15 22:59 ` Frederiko Costa <frederiko@gmail.com>
2011-02-15 23:01 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
0 siblings, 1 reply; 18+ messages in thread
From: Frederiko Costa @ 2011-02-15 22:59 UTC (permalink / raw)
To: Sairam Krishnamurthy <kmsram420@gmail.com>; +Cc: pgsql-admin
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
<kmsram420@gmail.com> wrote:
> 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 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, Sairam Krishnamurthy
> <kmsram420@gmail.com> wrote:
>
> 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 directory.
>
> On Tue, Feb 15, 2011 at 1:41 PM, Sairam Krishnamurthy
> <kmsram420@gmail.com> 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/postgresql/8.4/main to my folder.
> 2. Changed the data_directory in postgresql.conf.
>
> When I start postgres using /etc/init.d script I get the following error,
>
> * Starting PostgreSQL 8.4 database server
> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> /media/extension/var/lib/postgresql/8.4/main/ -l
> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>
>
> I tried changing the ownership of the
> /media/extension/var/lib/postgresql dir to <myusername>, postgres and
> root. Now of them worked and I keep getting the same error message.
>
> I found a lot of similar problems online but none had a solution.
>
> Can someone help me with this?
>
> TIA
>
> Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:09 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
2011-02-15 22:27 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:56 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
2011-02-15 22:58 ` Re: Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:59 ` Re: Moving the data directory Frederiko Costa <frederiko@gmail.com>
@ 2011-02-15 23:01 ` Sairam Krishnamurthy <kmsram420@gmail.com>
0 siblings, 0 replies; 18+ messages in thread
From: Sairam Krishnamurthy @ 2011-02-15 23:01 UTC (permalink / raw)
To: Frederiko Costa <frederiko@gmail.com>; +Cc: pgsql-admin
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 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
> <kmsram420@gmail.com> wrote:
>> 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 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, Sairam Krishnamurthy
>> <kmsram420@gmail.com> wrote:
>>
>> 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 directory.
>>
>> On Tue, Feb 15, 2011 at 1:41 PM, Sairam Krishnamurthy
>> <kmsram420@gmail.com> 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/postgresql/8.4/main to my folder.
>> 2. Changed the data_directory in postgresql.conf.
>>
>> When I start postgres using /etc/init.d script I get the following error,
>>
>> * Starting PostgreSQL 8.4 database server
>> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
>> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
>> /media/extension/var/lib/postgresql/8.4/main/ -l
>> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
>> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>>
>>
>> I tried changing the ownership of the
>> /media/extension/var/lib/postgresql dir to<myusername>, postgres and
>> root. Now of them worked and I keep getting the same error message.
>>
>> I found a lot of similar problems online but none had a solution.
>>
>> Can someone help me with this?
>>
>> TIA
>>
>> Thanks,
>> Sairam Krishnamurthy
>> +1 612 859 8161
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>>
>>
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
@ 2011-02-16 12:51 ` Greg Smith <greg@2ndquadrant.com>
2011-02-16 18:01 ` Re: Moving the data directory Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
2 siblings, 1 reply; 18+ messages in thread
From: Greg Smith @ 2011-02-16 12:51 UTC (permalink / raw)
To: Sairam Krishnamurthy <kmsram420@gmail.com>; +Cc: pgsql-admin
Sairam Krishnamurthy wrote:
> 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.conf.
>
> When I start postgres using /etc/init.d script I get the following error,
>
> * Starting PostgreSQL 8.4 database server
> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> /media/extension/var/lib/postgresql/8.4/main/ -l
> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>
Debian and Ubuntu installations have a unique feature where you can have
multiple PostgreSQL installations installed at the same time.
Accordingly, the standard ways of managing the database described in the
regular PostgreSQL documentation don't always work. See
http://www.stuartellis.eu/articles/postgresql-setup/ for a quick intro
to this, specifically the "Using Multiple PostgreSQL Clusters" section.
What you may need to change here is not the database's postgresql.conf,
but instead the database cluster list you see when running pg_lsclusters.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: Moving the data directory
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-16 12:51 ` Re: Moving the data directory Greg Smith <greg@2ndquadrant.com>
@ 2011-02-16 18:01 ` Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
0 siblings, 0 replies; 18+ messages in thread
From: Dean Gibson (DB Administrator) @ 2011-02-16 18:01 UTC (permalink / raw)
To: pgsql-admin
On 2011-02-16 04:51, Greg Smith wrote:
>
> Debian and Ubuntu installations have a unique feature where you can
> have multiple PostgreSQL installations installed at the same time.
That's pretty easy to do with any Linux distribution.
--
Mail to my list address MUST be sent via the mailing list.
All other mail to my list address will bounce.
^ permalink raw reply [nested|flat] 18+ messages in thread
end of thread, other threads:[~2011-02-16 18:01 UTC | newest]
Thread overview: 18+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-02-15 21:41 Moving the data directory Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 21:45 ` Scott Mead <scottm@openscg.com>
2011-02-15 21:58 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:27 ` Scott Mead <scottm@openscg.com>
2011-02-15 22:32 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:37 ` Scott Mead <scottm@openscg.com>
2011-02-15 22:43 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:48 ` Scott Mead <scottm@openscg.com>
2011-02-15 22:54 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 23:25 ` Thomas Kellerer <spam_eater@gmx.net>
2011-02-15 22:09 ` Frederiko Costa <frederiko@gmail.com>
2011-02-15 22:27 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:56 ` Frederiko Costa <frederiko@gmail.com>
2011-02-15 22:58 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-15 22:59 ` Frederiko Costa <frederiko@gmail.com>
2011-02-15 23:01 ` Sairam Krishnamurthy <kmsram420@gmail.com>
2011-02-16 12:51 ` Greg Smith <greg@2ndquadrant.com>
2011-02-16 18:01 ` Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox