Bug 164273

Summary: databases/postgresql91-server don't creating /usr/local/pgsql
Product: Ports & Packages Reporter: yerenkow
Component: Individual Port(s)Assignee: Jason Helfman <jgh>
Status: Closed FIXED    
Severity: Affects Only Me    
Priority: Normal    
Version: Latest   
Hardware: Any   
OS: Any   
Attachments:
Description Flags
pgsql.patch
none
pgsql.patch none

Description yerenkow 2012-01-18 08:20:07 UTC
Not creating needed directory via port install.

Fix: 

mkdir
chown
How-To-Repeat: cd /usr/ports/databases/postgresql91-server 
make install

ls /usr/local/pgsql #no such dir/file

cat /var/db/ports/postgresql91/options 
# This file is auto-generated by 'make config'.
# No user-servicable parts inside!
# Options for postgresql-server-9.1.1_1
_OPTIONS_READ=postgresql-server-9.1.1_1
WITH_NLS=true
WITHOUT_DTRACE=true
WITHOUT_PAM=true
WITHOUT_LDAP=true
WITHOUT_MIT_KRB5=true
WITHOUT_HEIMDAL_KRB5=true
WITHOUT_OPTIMIZED_CFLAGS=true
WITH_XML=true
WITH_TZDATA=true
WITHOUT_DEBUG=true
WITHOUT_GSSAPI=true
WITHOUT_ICU=true
WITH_INTDATE=true
WITH_SSL=true
Comment 1 R.Mahmatkhanov 2012-01-18 08:30:49 UTC
Alexander Yerenkow wrote on 18.01.2012 12:15:

>> Description:
> Not creating needed directory via port install.

It shouldn't as far i know.
Please use `service postgresql initdb` or
`/usr/local/etc/rc.d/postgresql initdb` as stated in pkg-message-server.
Please tell if it solved your problem.

-- 
Regards,
Ruslan

Tinderboxing kills... the drives.
Comment 2 yerenkow 2012-01-18 09:14:32 UTC
2012/1/18 Ruslan Mahmatkhanov <cvs-src@yandex.ru>

> Alexander Yerenkow wrote on 18.01.2012 12:15:
>
>  Description:
>>>
>> Not creating needed directory via port install.
>>
>
> It shouldn't as far i know.
> Please use `service postgresql initdb` or
> `/usr/local/etc/rc.d/postgresql initdb` as stated in pkg-message-server.
> Please tell if it solved your problem.


No, problem remains;
 /usr/local/etc/rc.d/postgresql initdb
su: no directory

In past, there was
/usr/local/pgsql,
initdb created not this dir, but nested one:
/usr/local/pgsql/data

If I create /usr/local/pgsql and chown it to pgsql:pgsql, then initdb and
after that start goes well.



>
> --
> Regards,
> Ruslan
>
> Tinderboxing kills... the drives.
>



-- 
Regards,
Alexander Yerenkow
Comment 3 R.Mahmatkhanov 2012-01-18 09:21:02 UTC
Alexander Yerenkow wrote on 18.01.2012 13:14:
> 2012/1/18 Ruslan Mahmatkhanov<cvs-src@yandex.ru>
>
>> Alexander Yerenkow wrote on 18.01.2012 12:15:
>>
>>   Description:
>>>>
>>> Not creating needed directory via port install.
>>>
>>
>> It shouldn't as far i know.
>> Please use `service postgresql initdb` or
>> `/usr/local/etc/rc.d/postgresql initdb` as stated in pkg-message-server.
>> Please tell if it solved your problem.
>
>
> No, problem remains;
>   /usr/local/etc/rc.d/postgresql initdb
> su: no directory
>
> In past, there was
> /usr/local/pgsql,
> initdb created not this dir, but nested one:
> /usr/local/pgsql/data
>
> If I create /usr/local/pgsql and chown it to pgsql:pgsql, then initdb and
> after that start goes well.

Ah, understood. Ok, i'll check further and then add followup to this pr.

-- 
Regards,
Ruslan

Tinderboxing kills... the drives.
Comment 4 Mark Linimon freebsd_committer freebsd_triage 2012-01-18 14:57:00 UTC
Responsible Changed
From-To: freebsd-ports-bugs->girgen

Fix synopsis and assign.
Comment 5 Jason Helfman freebsd_committer freebsd_triage 2012-01-18 16:33:49 UTC
Responsible Changed
From-To: girgen->jgh

stealing this...
Comment 6 Jason Helfman freebsd_committer freebsd_triage 2012-01-18 17:44:29 UTC
Please try the following patch and let me know if this solves the issue.
Thanks!

-jgh

-- 
Jason Helfman         | FreeBSD Committer
jgh@FreeBSD.org       | http://people.freebsd.org/~jgh
Comment 7 Jason Helfman freebsd_committer freebsd_triage 2012-01-18 18:18:45 UTC
Working on new patch now regarding chown bit.
-jgh

-- 
Jason Helfman         | FreeBSD Committer
jgh@FreeBSD.org       | http://people.freebsd.org/~jgh
Comment 8 Jason Helfman freebsd_committer freebsd_triage 2012-01-18 18:39:59 UTC
Here is an updated patch that should take care of it in the port and
package.
-jgh

-- 
Jason Helfman         | FreeBSD Committer
jgh@FreeBSD.org       | http://people.freebsd.org/~jgh
Comment 9 dfilter service freebsd_committer freebsd_triage 2012-01-18 21:35:25 UTC
jgh         2012-01-18 21:35:11 UTC

  FreeBSD ports repository

  Modified files:
    databases/postgresql82-server Makefile pkg-plist-server 
    databases/postgresql84-server Makefile pkg-plist-server 
    databases/postgresql90-server Makefile pkg-plist-server 
    databases/postgresql91-server Makefile pkg-plist-server 
  Log:
  Fix plist to create directory with proper ownerships PostgreSQL database
  may start.
  
  PR:     ports/164273 (critical)
  Submitted by: Alexander Yerenkow <yerenkow at gmail.com>
  Approved by:    maintainer-timeout: girgen (1 day), portmgr (linimon)
  
  Revision  Changes    Path
  1.207     +2 -1      ports/databases/postgresql82-server/Makefile
  1.23      +2 -0      ports/databases/postgresql82-server/pkg-plist-server
  1.240     +2 -0      ports/databases/postgresql84-server/Makefile
  1.37      +2 -0      ports/databases/postgresql84-server/pkg-plist-server
  1.233     +2 -0      ports/databases/postgresql90-server/Makefile
  1.37      +2 -0      ports/databases/postgresql90-server/pkg-plist-server
  1.235     +2 -0      ports/databases/postgresql91-server/Makefile
  1.40      +2 -0      ports/databases/postgresql91-server/pkg-plist-server
_______________________________________________
cvs-all@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/cvs-all
To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
Comment 10 dfilter service freebsd_committer freebsd_triage 2012-01-18 21:52:52 UTC
jgh         2012-01-18 21:52:36 UTC

  FreeBSD ports repository

  Modified files:
    databases/postgresql83-server Makefile pkg-plist-server 
  Log:
  Fix plist to create directory with proper ownerships so PostgreSQL database
  may start.
  
  PR:     ports/164273 (critical)
  Submitted by: Alexander Yerenkow <yerenkow at gmail.com>
  Approved by:    maintainer-timeout: girgen (1 day), portmgr (linimon)
  
  Revision  Changes    Path
  1.220     +2 -1      ports/databases/postgresql83-server/Makefile
  1.30      +2 -0      ports/databases/postgresql83-server/pkg-plist-server
_______________________________________________
cvs-all@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/cvs-all
To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
Comment 11 Jason Helfman freebsd_committer freebsd_triage 2012-01-18 21:53:49 UTC
State Changed
From-To: open->closed

Committed fix. Thanks!