pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
problem with initlocation
9+ messages / 5 participants
[nested] [flat]

* problem with initlocation
@ 2006-08-31 15:05 Josef J. Micka <postgres@maylo.cz>
  2006-08-31 15:53 ` Re: problem with initlocation Tom Lane <tgl@sss.pgh.pa.us>
  2006-08-31 16:02 ` Re: problem with initlocation Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 2 replies; 9+ messages in thread

From: Josef J. Micka @ 2006-08-31 15:05 UTC (permalink / raw)
  To: pgsql-admin

i want to make database in another place and i'm unable to use 
initlocation, and i don't know, what i'm doing wrong.

this is what i do, and i think it's correct.

www:/home/db/postgres$ su postgres
postgres@www:/home/db/postgres$ ls -l
total 12
drwx------  6 postgres postgres 4096 Aug 31 14:59 data
drwxr-xr-x  2 postgres postgres 4096 Aug 31 14:19 data-web
drwx------  3 postgres postgres 4096 Oct 15  2004 dumpall
postgres@www:/home/db/postgres$ /usr/lib/postgresql/bin/initlocation 
/home/db/postgres/data-web/
initlocation: cannot be run as root
Please log in (using, e.g., "su") as the (unprivileged) user that will
own the server process.
postgres@www:/home/db/postgres$

postgres server runs under user postgres
postgres@www:/home/web/holandsko# ps uxaw |grep post
postgres 11006  0.0  0.0 17088 1292 ?        S    Jun29   7:16 
/usr/lib/postgresql/bin/postmaster -D /var/lib/postgres/data
postgres 11012  0.0  0.1  7888 2668 ?        S    Jun29  11:22 postgres: 
stats buffer process
postgres 11013  0.0  0.1  7944 2500 ?        S    Jun29  10:09 postgres: 
stats collector process
postgres 11029  0.0  0.1 12780 3116 ?        Ss   Jun29  17:58 
/usr/lib/postgresql/bin/pg_autovacuum -D -p 5432 -L 
/var/log/postgresql/autovacuum_log

and info about system
Debian Sarge, kernel 2.4.32, postgresql version 7.4.7

thanks
Josef Micka



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problem with initlocation
  2006-08-31 15:05 problem with initlocation Josef J. Micka <postgres@maylo.cz>
@ 2006-08-31 15:53 ` Tom Lane <tgl@sss.pgh.pa.us>
  2006-09-01 07:22   ` Re: problem with initlocation Josef J. Micka <postgres@maylo.cz>
  1 sibling, 1 reply; 9+ messages in thread

From: Tom Lane @ 2006-08-31 15:53 UTC (permalink / raw)
  To: Josef J. Micka <postgres@maylo.cz>; +Cc: pgsql-admin

"Josef J. Micka" <postgres@maylo.cz> writes:
> i want to make database in another place and i'm unable to use 
> initlocation, and i don't know, what i'm doing wrong.

> this is what i do, and i think it's correct.

> www:/home/db/postgres$ su postgres

Try "su - postgres" ... plain su retains root's environment.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problem with initlocation
  2006-08-31 15:05 problem with initlocation Josef J. Micka <postgres@maylo.cz>
  2006-08-31 15:53 ` Re: problem with initlocation Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-09-01 07:22   ` Josef J. Micka <postgres@maylo.cz>
  0 siblings, 0 replies; 9+ messages in thread

From: Josef J. Micka @ 2006-09-01 07:22 UTC (permalink / raw)
  To: pgsql-admin

Tom Lane wrote:

>"Josef J. Micka" <postgres@maylo.cz> writes:
>  
>
>>i want to make database in another place and i'm unable to use 
>>initlocation, and i don't know, what i'm doing wrong.
>>    
>>
>
>  
>
>>this is what i do, and i think it's correct.
>>    
>>
>
>  
>
>>www:/home/db/postgres$ su postgres
>>    
>>
>
>Try "su - postgres" ... plain su retains root's environment.
>
>			regards, tom lane
>  
>
thanks, that works
i'm using su only sometimes, and don't know about this apearance. (never 
had problems with "su" becausy mostly i'm running it from non-privileged 
user, but because user postgres has no password and no shell, i must do 
that from root this time)

so thanks again.

regards,
Josef



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problem with initlocation
  2006-08-31 15:05 problem with initlocation Josef J. Micka <postgres@maylo.cz>
@ 2006-08-31 16:02 ` Scott Marlowe <smarlowe@g2switchworks.com>
  2006-08-31 17:14   ` Re: problem with initlocation Joshua D. Drake <jd@commandprompt.com>
  1 sibling, 1 reply; 9+ messages in thread

From: Scott Marlowe @ 2006-08-31 16:02 UTC (permalink / raw)
  To: Josef J. Micka <postgres@maylo.cz>; +Cc: pgsql-admin

On Thu, 2006-08-31 at 10:05, Josef J. Micka wrote:
> i want to make database in another place and i'm unable to use 
> initlocation, and i don't know, what i'm doing wrong.
> 
> this is what i do, and i think it's correct.
> 
> www:/home/db/postgres$ su postgres
> postgres@www:/home/db/postgres$ ls -l
> total 12
> drwx------  6 postgres postgres 4096 Aug 31 14:59 data
> drwxr-xr-x  2 postgres postgres 4096 Aug 31 14:19 data-web
> drwx------  3 postgres postgres 4096 Oct 15  2004 dumpall
> postgres@www:/home/db/postgres$ /usr/lib/postgresql/bin/initlocation 
> /home/db/postgres/data-web/
> initlocation: cannot be run as root

What does the command whoami say right before you would run the
initlocation?



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problem with initlocation
  2006-08-31 15:05 problem with initlocation Josef J. Micka <postgres@maylo.cz>
  2006-08-31 16:02 ` Re: problem with initlocation Scott Marlowe <smarlowe@g2switchworks.com>
@ 2006-08-31 17:14   ` Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Joshua D. Drake @ 2006-08-31 17:14 UTC (permalink / raw)
  To: Scott Marlowe <smarlowe@g2switchworks.com>; +Cc: Josef J. Micka <postgres@maylo.cz>; pgsql-admin

Scott Marlowe wrote:
> On Thu, 2006-08-31 at 10:05, Josef J. Micka wrote:
>> i want to make database in another place and i'm unable to use 
>> initlocation, and i don't know, what i'm doing wrong.
>>
>> this is what i do, and i think it's correct.
>>
>> www:/home/db/postgres$ su postgres
>> postgres@www:/home/db/postgres$ ls -l
>> total 12
>> drwx------  6 postgres postgres 4096 Aug 31 14:59 data
>> drwxr-xr-x  2 postgres postgres 4096 Aug 31 14:19 data-web
>> drwx------  3 postgres postgres 4096 Oct 15  2004 dumpall
>> postgres@www:/home/db/postgres$ /usr/lib/postgresql/bin/initlocation 
>> /home/db/postgres/data-web/
>> initlocation: cannot be run as root
> 
> What does the command whoami say right before you would run the
> initlocation?

I think a more appropriate question would be why is he running a version 
of PostgreSQL that still has initlocation?

Sincerely,

Joshua D. Drake


> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 


-- 

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problem with initlocation
@ 2006-09-01 15:14 Josef J. Micka <postgres@maylo.cz>
  2006-09-01 16:42 ` Re: problem with initlocation Scott Marlowe <smarlowe@g2switchworks.com>
  2006-09-01 17:47 ` Re: problem with initlocation Joshua D. Drake <jd@commandprompt.com>
  2006-09-01 17:48 ` Re: problem with initlocation Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
  0 siblings, 3 replies; 9+ messages in thread

From: Josef J. Micka @ 2006-09-01 15:14 UTC (permalink / raw)
  To: pgsql-admin


Joshua D. Drake wrote:

> Scott Marlowe wrote:
>
>> On Thu, 2006-08-31 at 10:05, Josef J. Micka wrote:
>>
>>> i want to make database in another place and i'm unable to use 
>>> initlocation, and i don't know, what i'm doing wrong.
>>>
>>> this is what i do, and i think it's correct.
>>>
>>> www:/home/db/postgres$ su postgres
>>> postgres@www:/home/db/postgres$ ls -l
>>> total 12
>>> drwx------  6 postgres postgres 4096 Aug 31 14:59 data
>>> drwxr-xr-x  2 postgres postgres 4096 Aug 31 14:19 data-web
>>> drwx------  3 postgres postgres 4096 Oct 15  2004 dumpall
>>> postgres@www:/home/db/postgres$ /usr/lib/postgresql/bin/initlocation 
>>> /home/db/postgres/data-web/
>>> initlocation: cannot be run as root
>>
>>
>>
>> What does the command whoami say right before you would run the
>> initlocation?
>
>
>
> I think a more appropriate question would be why is he running a 
> version of PostgreSQL that still has initlocation?
>
> Sincerely,
>
> Joshua D. Drake
>
>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: don't forget to increase your free space map settings
>>
>
because it's latest stable version for debian sarge.
and i rather use possibly "older but stable" software, then "unstable" 
or "development" software on production server.
also i don't need features of new version, in fact, i may stay on 6.5, 
but from my point of view is 7.4 faster, and as i said, it's "stable" 
for debian.

regards
Josef J. Micka



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problem with initlocation
  2006-09-01 15:14 Re: problem with initlocation Josef J. Micka <postgres@maylo.cz>
@ 2006-09-01 16:42 ` Scott Marlowe <smarlowe@g2switchworks.com>
  2 siblings, 0 replies; 9+ messages in thread

From: Scott Marlowe @ 2006-09-01 16:42 UTC (permalink / raw)
  To: Josef J. Micka <postgres@maylo.cz>; +Cc: pgsql-admin

On Fri, 2006-09-01 at 10:14, Josef J. Micka wrote:
> Joshua D. Drake wrote:
> 
> > Scott Marlowe wrote:
> >>
> >> What does the command whoami say right before you would run the
> >> initlocation?
> >
> >
> >
> > I think a more appropriate question would be why is he running a 
> > version of PostgreSQL that still has initlocation?
> >
> because it's latest stable version for debian sarge.
> and i rather use possibly "older but stable" software, then "unstable" 
> or "development" software on production server.
> also i don't need features of new version, in fact, i may stay on 6.5, 
> but from my point of view is 7.4 faster, and as i said, it's "stable" 
> for debian.

As someone else who is running 7.4, I can say that while I'd love to
push 8.0 or 8.1 into production, it often takes a year or more from the
time something is released until it can be used.

But I don't think I'd run any version of PostgreSQL older than 7.3 in
production.  There were major, data losing bugs in versions before that
version that make them unsuitable for production, like transaction ID
wrap around.



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problem with initlocation
  2006-09-01 15:14 Re: problem with initlocation Josef J. Micka <postgres@maylo.cz>
@ 2006-09-01 17:47 ` Joshua D. Drake <jd@commandprompt.com>
  2 siblings, 0 replies; 9+ messages in thread

From: Joshua D. Drake @ 2006-09-01 17:47 UTC (permalink / raw)
  To: Josef J. Micka <postgres@maylo.cz>; +Cc: pgsql-admin


>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 5: don't forget to increase your free space map settings
>>>
>>
> because it's latest stable version for debian sarge.
> and i rather use possibly "older but stable" software, then "unstable" 
> or "development" software on production server.

I firmly agree with you. The latest STABLE version of PostgreSQL is 8.1.4.

Sincerely,

Joshua D. Drake



-- 

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: problem with initlocation
  2006-09-01 15:14 Re: problem with initlocation Josef J. Micka <postgres@maylo.cz>
@ 2006-09-01 17:48 ` Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
  2 siblings, 0 replies; 9+ messages in thread

From: Andy Shellam @ 2006-09-01 17:48 UTC (permalink / raw)
  To: pgsql-admin

Compile it from source - 8.1.4 is the latest stable version.
The 6.5 series is not just old, it's ancient.  It hasn't been updated 
since 1999.

There are some serious bugs in the earlier versions, even in the early 
7.x series that do and have resulted in data loss.

At least get and test out an 8.x series install, you might be surprised, 
and it may just save your data.

---

Josef J. Micka wrote:
> because it's latest stable version for debian sarge.
> and i rather use possibly "older but stable" software, then "unstable" 
> or "development" software on production server.
> also i don't need features of new version, in fact, i may stay on 6.5, 
> but from my point of view is 7.4 faster, and as i said, it's "stable" 
> for debian.
>
> regards
> Josef J. Micka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
> !DSPAM:37,44f861db143291722221284!
>
>




^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2006-09-01 17:48 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-31 15:05 problem with initlocation Josef J. Micka <postgres@maylo.cz>
2006-08-31 15:53 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-09-01 07:22   ` Josef J. Micka <postgres@maylo.cz>
2006-08-31 16:02 ` Scott Marlowe <smarlowe@g2switchworks.com>
2006-08-31 17:14   ` Joshua D. Drake <jd@commandprompt.com>
2006-09-01 15:14 Re: problem with initlocation Josef J. Micka <postgres@maylo.cz>
2006-09-01 16:42 ` Scott Marlowe <smarlowe@g2switchworks.com>
2006-09-01 17:47 ` Joshua D. Drake <jd@commandprompt.com>
2006-09-01 17:48 ` Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>

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