public inbox for gentoo-user@lists.gentoo.org
 help / color / mirror / Atom feed
Search results ordered by [date|relevance]  view[summary|nested|Atom feed]
thread overview below | download: 
* Re: [gentoo-user] pg_upgrade91 - You must have read and write access  in the current  directory
       [not found]       ` <i4xpD-34S-7@gated-at.bofh.it>
@ 2011-12-05 10:56 99%     ` Gregory Shearman
  0 siblings, 0 replies; 1+ results
From: Gregory Shearman @ 2011-12-05 10:56 UTC (permalink / raw
  To: gentoo-user

In linux.gentoo.user, you wrote:
> On 12/05/11 13:37, Gregory Shearman wrote:
>>In linux.gentoo.user, Joseph wrote:
>>> I'm upgrading form posgresql 9.0 to 9.1, it seem to the upgrade went OK but when try to transfer the data
>>> base:
>>> pg_upgrade91 -v --old-datadir=/var/lib/postgresql/9.0/data/ --new-datadir=/var/lib/postgresql/9.1/data
>>> --old-bindir=/usr/lib/postgresql-9.0/bin/ --new-bindir=/usr/lib/postgresql-9.1/bin/
>>> Running in verbose mode
>>> Performing Consistency Checks
>>> -----------------------------
>>> Checking current, bin, and data directories
>>> You must have read and write access in the current directory.
>>> Failure, exiting
>>>
>>> What am I doing wrong?
>>
>>Have you checked that you have read and write access in the current
>>directory before running the command?
>>
>>I did the upgrade as the "postgres" user and made sure that I ran the
>>command from a read/writable directory for that user.
>
> Yes, I did "su postgres"
> and ls -al /var/lib/postgresql/9.1/
> drwx------ 13 postgres postgres 4096 Dec  4 18:20 data
>
> so it should work.
>
> -- 
> Joseph

hmmm...

Which directory are you running the command from? I ran mine from
/var/lib/postgresql which has the properties:

drwxr-xr-x 4 postgres root

I don't recall using the command "pg_upgrade91", but I see that it is a
symlink to /usr/lib/postgresql-9.1/bin/pg_upgrade

This is the command that worked for me:

pg_upgrade -u postgres -d /var/lib/postgresql/9.0/data -D \\
/var/lib/postgresql/9.1/data -b /usr/lib/postgresql-9.0/bin -B \\
/usr/lib/postgresql-9.1/bin

For more information do (as postgres user)

$ pg_upgrade --help

-- 
Regards,
Gregory



^ permalink raw reply	[relevance 99%]

Results 1-1 of 1 | reverse | options above
-- pct% links below jump to the message on this page, permalinks otherwise --
     [not found]     <i4wMV-1QN-5@gated-at.bofh.it>
     [not found]     ` <i4wMV-1QN-3@gated-at.bofh.it>
     [not found]       ` <i4xpD-34S-7@gated-at.bofh.it>
2011-12-05 10:56 99%     ` [gentoo-user] pg_upgrade91 - You must have read and write access in the current directory Gregory Shearman

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox