Solved Cannot start postgresql, get "function: not found"

Hi all,

Install from own Poudriere postgresql93. When I start the PostgreSQL server I get this error message.

Code:
[root@erp /usr/local/etc/rc.d]# service postgresql initdb
postgresql is located in /usr/local/etc/rc.d
function: not found
portsnap: Directory does not exist or is not writable: /var/db/portsnap
/tmp/d-74094-index/INDEX-10.bz2               100% of 1698 kB  339 kBps 00m05s
install: /usr/ports/INDEX-10: Permission denied
install: /usr/ports/INDEX-10.bz2: Permission denied
New version available: libtool-2.4.2.418
1 has a new version available
portaudit: not found
pkg_updating: not found
Syntax error: "}" unexpected
Any help here?
Thanks.

Stefan
 
Re: Can not start postgresql, get error "function: not found

Can you run and post the output of sh -x /usr/local/etc/rc.d/postgresql initdb?
 
Re: Can not start postgresql, get error "function: not found

Hi @SirDice,
Here is the output:

Code:
[root@erp /usr/local/etc/rc.d]# sh -x /usr/local/etc/rc.d/postgresql initdb
+ command=/usr/local/bin/pg_ctl
+ . /etc/rc.subr
+ : 75286
+ export RC_PID
+ [ -z '' ]
+ _rc_subr_loaded=YES
+ SYSCTL=/sbin/sysctl
+ SYSCTL_N='/sbin/sysctl -n'
+ SYSCTL_W=/sbin/sysctl
+ ID=/usr/bin/id
+ IDCMD='if [ -x /usr/bin/id ]; then /usr/bin/id -un; fi'
+ PS='/bin/ps -ww'
+ /bin/ps -ww -p 75286 -o jid=
+ JID=0
+ _rc_namevarlist='program chroot chdir flags fib nice user group groups'
+ _rc_subr_loaded=:
+ load_rc_config postgresql
+ local _name _rcvar_val _var _defval _v _msg _new
+ _name=postgresql
+ [ -z postgresql ]
+ false
+ [ -r /etc/defaults/rc.conf ]
+ debug 'Sourcing /etc/defaults/rc.conf'
+ . /etc/defaults/rc.conf
+ rc_debug=NO
+ rc_info=NO
+ rc_startmsgs=YES
+ rcshutdown_timeout=90
+ early_late_divider=FILESYSTEMS
+ always_force_depends=NO
+ apm_enable=NO
+ apmd_enable=NO
+ apmd_flags=''
+ ddb_enable=NO
+ ddb_config=/etc/ddb.conf
+ devd_enable=YES
+ devd_flags=''
+ kldxref_enable=NO
+ kldxref_clobber=NO
+ kldxref_module_path=''
+ powerd_enable=NO
+ powerd_flags=''
+ tmpmfs=AUTO
+ tmpsize=20m
+ tmpmfs_flags=-S
+ varmfs=AUTO
+ varsize=32m
+ varmfs_flags=-S
+ populate_var=AUTO
+ cleanvar_enable=YES
+ local_startup=/usr/local/etc/rc.d
+ script_name_sep=' '
+ rc_conf_files='/etc/rc.conf /etc/rc.conf.local'
+ zfs_enable=NO
+ gptboot_enable=YES
+ gbde_autoattach_all=NO
+ gbde_devices=NO
+ gbde_attach_attempts=3
+ gbde_lockdir=/etc
+ geli_devices=''
+ geli_tries=''
+ geli_default_flags=''
+ geli_autodetach=YES
+ root_rw_mount=YES
+ fsck_y_enable=NO
+ fsck_y_flags=''
+ background_fsck=YES
+ background_fsck_delay=60
+ netfs_types='nfs:NFS oldnfs:OLDNFS smbfs:SMB'
+ extra_netfs_types=NO
+ hostname=''
+ hostid_enable=YES
+ hostid_file=/etc/hostid
+ nisdomainname=NO
+ dhclient_program=/sbin/dhclient
+ dhclient_flags=''
+ background_dhclient=NO
+ synchronous_dhclient=NO
+ defaultroute_delay=30
+ defaultroute_carrier_delay=5
+ wpa_supplicant_program=/usr/sbin/wpa_supplicant
+ wpa_supplicant_flags=-s
+ wpa_supplicant_conf_file=/etc/wpa_supplicant.conf
+ firewall_enable=NO
+ firewall_script=/etc/rc.firewall
+ firewall_type=UNKNOWN
+ firewall_quiet=NO
+ firewall_logging=NO
+ firewall_logif=NO
+ firewall_flags=''
+ firewall_coscripts=''
+ firewall_client_net=192.0.2.0/24
+ firewall_simple_iif=ed1
+ firewall_simple_inet=192.0.2.16/28
+ firewall_simple_oif=ed0
+ firewall_simple_onet=192.0.2.0/28
+ firewall_myservices=''
+ firewall_allowservices=''
+ firewall_trusted=''
+ firewall_logdeny=NO
+ firewall_nologports='135-139,445 1026,1027 1433,1434'
+ firewall_nat_enable=NO
+ firewall_nat_interface=''
+ firewall_nat_flags=''
+ dummynet_enable=NO
+ ip_portrange_first=NO
+ ip_portrange_last=NO
+ ike_enable=NO
+ ike_program=/usr/local/sbin/isakmpd
+ ike_flags=''
+ ipsec_enable=NO
+ ipsec_file=/etc/ipsec.conf
+ natd_program=/sbin/natd
+ natd_enable=NO
+ natd_interface=''
+ natd_flags=''
+ ipfilter_enable=NO
+ ipfilter_program=/sbin/ipf
+ ipfilter_rules=/etc/ipf.rules
+ ipfilter_flags=''
+ ipnat_enable=NO
+ ipnat_program=/sbin/ipnat
+ ipnat_rules=/etc/ipnat.rules
+ ipnat_flags=''
+ ipmon_enable=NO
+ ipmon_program=/sbin/ipmon
+ ipmon_flags=-Ds
+ ipfs_enable=NO
+ ipfs_program=/sbin/ipfs
+ ipfs_flags=''
+ pf_enable=NO
+ pf_rules=/etc/pf.conf
+ pf_program=/sbin/pfctl
+ pf_flags=''
+ pflog_enable=NO
+ pflog_logfile=/var/log/pflog
+ pflog_program=/sbin/pflogd
+ pflog_flags=''
+ ftpproxy_enable=NO
+ ftpproxy_flags=''
+ pfsync_enable=NO
+ pfsync_syncdev=''
+ pfsync_syncpeer=''
+ pfsync_ifconfig=''
+ tcp_extensions=YES
+ log_in_vain=0
+ tcp_keepalive=YES
+ tcp_drop_synfin=NO
+ icmp_drop_redirect=NO
+ icmp_log_redirect=NO
+ network_interfaces=auto
+ cloned_interfaces=''
+ sppp_interfaces=''
+ gif_interfaces=''
+ fec_interfaces=''
+ ppp_enable=NO
+ ppp_program=/usr/sbin/ppp
+ ppp_mode=auto
+ ppp_nat=YES
+ ppp_profile=papchap
+ ppp_user=root
+ hostapd_enable=NO
+ syslogd_enable=YES
+ syslogd_program=/usr/sbin/syslogd
+ syslogd_flags=-s
+ altlog_proglist=''
+ inetd_enable=NO
+ inetd_program=/usr/sbin/inetd
+ inetd_flags='-wW -C 60'
+ iscsid_enable=NO
+ iscsictl_enable=NO
+ iscsictl_flags=-Aa
+ hastd_enable=NO
+ hastd_program=/sbin/hastd
+ hastd_flags=''
+ ctld_enable=NO
+ local_unbound_enable=NO
+ kerberos5_server_enable=NO
+ kerberos5_server=/usr/libexec/kdc
+ kerberos5_server_flags=--detach
+ kadmind5_server_enable=NO
+ kadmind5_server=/usr/libexec/kadmind
+ kpasswdd_server_enable=NO
+ kpasswdd_server=/usr/libexec/kpasswdd
+ kfd_enable=NO
+ kfd_program=/usr/libexec/kfd
+ gssd_enable=NO
+ gssd_flags=''
+ rwhod_enable=NO
+ rwhod_flags=''
+ rarpd_enable=NO
+ rarpd_flags=-a
+ bootparamd_enable=NO
+ bootparamd_flags=''
+ pppoed_enable=NO
+ pppoed_provider='*'
+ pppoed_flags='-P /var/run/pppoed.pid'
+ pppoed_interface=fxp0
+ sshd_enable=NO
+ sshd_program=/usr/sbin/sshd
+ sshd_flags=''
+ ftpd_enable=NO
+ ftpd_program=/usr/libexec/ftpd
+ ftpd_flags=''
+ amd_enable=NO
+ amd_program=/usr/sbin/amd
+ amd_flags='-a /.amd_mnt -l syslog /host /etc/amd.map /net /etc/amd.map'
+ amd_map_program=NO
+ nfs_client_enable=NO
+ nfs_access_cache=60
+ nfs_server_enable=NO
+ oldnfs_server_enable=NO
+ nfs_server_flags='-u -t -n 4'
+ mountd_enable=NO
+ mountd_flags=-r
+ weak_mountd_authentication=NO
+ nfs_reserved_port_only=NO
+ nfs_bufpackets=''
+ rpc_lockd_enable=NO
+ rpc_lockd_flags=''
+ rpc_statd_enable=NO
+ rpc_statd_flags=''
+ rpcbind_enable=NO
+ rpcbind_program=/usr/sbin/rpcbind
+ rpcbind_flags=''
+ rpc_ypupdated_enable=NO
+ keyserv_enable=NO
+ keyserv_flags=''
+ nfsv4_server_enable=NO
+ nfscbd_enable=NO
+ nfscbd_flags=''
+ nfsuserd_enable=NO
+ nfsuserd_flags=''
+ timed_enable=NO
+ timed_flags=''
+ ntpdate_enable=NO
+ ntpdate_program=/usr/sbin/ntpdate
+ ntpdate_flags=-b
+ ntpdate_config=/etc/ntp.conf
+ ntpdate_hosts=''
+ ntpd_enable=NO
+ ntpd_program=/usr/sbin/ntpd
+ ntpd_config=/etc/ntp.conf
+ ntpd_sync_on_start=NO
+ ntpd_flags='-p /var/run/ntpd.pid -f /var/db/ntpd.drift'
+ nis_client_enable=NO
+ nis_client_flags=''
+ nis_ypset_enable=NO
+ nis_ypset_flags=''
+ nis_server_enable=NO
+ nis_server_flags=''
+ nis_ypxfrd_enable=NO
+ nis_ypxfrd_flags=''
+ nis_yppasswdd_enable=NO
+ nis_yppasswdd_flags=''
+ bsnmpd_enable=NO
+ bsnmpd_flags=''
+ defaultrouter=NO
+ static_arp_pairs=''
+ static_ndp_pairs=''
+ static_routes=''
+ natm_static_routes=''
+ gateway_enable=NO
+ routed_enable=NO
+ routed_program=/sbin/routed
+ routed_flags=-q
+ mrouted_enable=NO
+ mrouted_program=/usr/local/sbin/mrouted
+ mrouted_flags=''
+ ipxgateway_enable=NO
+ ipxrouted_enable=NO
+ ipxrouted_flags=''
+ arpproxy_all=NO
+ forward_sourceroute=NO
+ accept_sourceroute=NO
+ atm_enable=NO
+ atm_pvcs=''
+ atm_arps=''
+ hcsecd_enable=NO
+ hcsecd_config=/etc/bluetooth/hcsecd.conf
+ sdpd_enable=NO
+ sdpd_control=/var/run/sdp
+ sdpd_groupname=nobody
+ sdpd_username=nobody
+ bthidd_enable=NO
+ bthidd_config=/etc/bluetooth/bthidd.conf
+ bthidd_hids=/var/db/bthidd.hids
+ rfcomm_pppd_server_enable=NO
+ rfcomm_pppd_server_profile='one two'
+ rfcomm_pppd_server_one_channel=1
+ rfcomm_pppd_server_two_channel=3
+ ubthidhci_enable=NO
+ netwait_enable=NO
+ netwait_timeout=60
+ netwait_if_timeout=30
+ icmp_bmcastecho=NO
+ ipv6_network_interfaces=auto
+ ipv6_activate_all_interfaces=NO
+ ipv6_defaultrouter=NO
+ ipv6_static_routes=''
+ ipv6_gateway_enable=NO
+ ipv6_cpe_wanif=NO
+ ipv6_privacy=NO
+ route6d_enable=NO
+ route6d_program=/usr/sbin/route6d
+ route6d_flags=''
+ ipv6_default_interface=NO
+ rtsol_flags=''
+ rtsold_enable=NO
+ rtsold_flags=-a
+ rtadvd_enable=NO
+ rtadvd_interfaces=''
+ mroute6d_enable=NO
+ mroute6d_program=/usr/local/sbin/pim6dd
+ mroute6d_flags=''
+ stf_interface_ipv4addr=''
+ stf_interface_ipv4plen=0
+ stf_interface_ipv6_ifid=0:0:0:1
+ stf_interface_ipv6_slaid=0000
+ ipv6_faith_prefix=NO
+ ipv6_ipv4mapping=NO
+ ipv6_ipfilter_rules=/etc/ipf6.rules
+ ip6addrctl_enable=YES
+ ip6addrctl_verbose=NO
+ ip6addrctl_policy=AUTO
+ keyboard=''
+ keymap=NO
+ keyrate=NO
+ keybell=NO
+ keychange=NO
+ cursor=NO
+ scrnmap=NO
+ font8x16=NO
+ font8x14=NO
+ font8x8=NO
+ blanktime=300
+ saver=NO
+ moused_nondefault_enable=YES
+ moused_enable=NO
+ moused_type=auto
+ moused_port=/dev/psm0
+ moused_flags=''
+ mousechar_start=NO
+ allscreens_flags=''
+ allscreens_kbdflags=''
+ mta_start_script=/etc/rc.sendmail
+ sendmail_enable=NO
+ sendmail_pidfile=/var/run/sendmail.pid
+ sendmail_procname=/usr/sbin/sendmail
+ sendmail_flags='-L sm-mta -bd -q30m'
+ sendmail_cert_create=YES
+ sendmail_submit_enable=YES
+ sendmail_submit_flags='-L sm-mta -bd -q30m -ODaemonPortOptions=Addr=localhost'
+ sendmail_outbound_enable=YES
+ sendmail_outbound_flags='-L sm-queue -q30m'
+ sendmail_msp_queue_enable=YES
+ sendmail_msp_queue_flags='-L sm-msp-queue -Ac -q30m'
+ sendmail_rebuild_aliases=NO
+ auditd_enable=NO
+ auditd_program=/usr/sbin/auditd
+ auditd_flags=''
+ auditdistd_enable=NO
+ auditdistd_program=/usr/sbin/auditdistd
+ auditdistd_flags=''
+ cron_enable=YES
+ cron_program=/usr/sbin/cron
+ cron_dst=YES
+ cron_flags=''
+ lpd_enable=NO
+ lpd_program=/usr/sbin/lpd
+ lpd_flags=''
+ nscd_enable=NO
+ chkprintcap_enable=NO
+ chkprintcap_flags=-d
+ dumpdev=NO
+ dumpdir=/var/crash
+ savecore_flags='-m 10'
+ crashinfo_enable=YES
+ crashinfo_program=/usr/sbin/crashinfo
+ quota_enable=NO
+ check_quotas=YES
+ quotaon_flags=-a
+ quotaoff_flags=-a
+ quotacheck_flags=-a
+ accounting_enable=NO
+ ibcs2_enable=NO
+ ibcs2_loaders=coff
+ firstboot_sentinel=/firstboot
+ sysvipc_enable=NO
+ linux_enable=NO
+ svr4_enable=NO
+ clear_tmp_enable=NO
+ clear_tmp_X=YES
+ ldconfig_insecure=NO
+ ldconfig_paths='/usr/lib/compat /usr/local/lib /usr/local/lib/compat/pkg'
+ ldconfig32_paths=/usr/lib32
+ ldconfig_paths_aout='/usr/lib/compat/aout /usr/local/lib/aout'
+ ldconfig_local_dirs=/usr/local/libdata/ldconfig
+ ldconfig_local32_dirs=/usr/local/libdata/ldconfig32
+ kern_securelevel_enable=NO
+ kern_securelevel=-1
+ update_motd=YES
+ entropy_file=/entropy
+ entropy_dir=/var/db/entropy
+ entropy_save_sz=2048
+ entropy_save_num=8
+ harvest_interrupt=YES
+ harvest_ethernet=YES
+ harvest_p_to_p=YES
+ harvest_swi=YES
+ dmesg_enable=YES
+ watchdogd_enable=NO
+ watchdogd_flags=''
+ devfs_rulesets='/etc/defaults/devfs.rules /etc/devfs.rules'
+ devfs_system_ruleset=''
+ devfs_set_rulesets=''
+ devfs_load_rulesets=YES
+ performance_cx_lowest=HIGH
+ performance_cpu_freq=NONE
+ economy_cx_lowest=HIGH
+ economy_cpu_freq=NONE
+ virecover_enable=YES
+ ugidfw_enable=NO
+ bsdextended_script=/etc/rc.bsdextended
+ newsyslog_enable=YES
+ newsyslog_flags=-CN
+ mixer_enable=YES
+ opensm_enable=NO
+ jail_enable=NO
+ jail_parallel_start=NO
+ jail_list=''
+ [ -z '' ]
+ source_rc_confs_defined=yes
+ source_rc_confs
+ local i sourced_files
+ sourced_files=:/etc/rc.conf:
+ [ -r /etc/rc.conf ]
+ . /etc/rc.conf
+ defaultrouter=192.168.1.50
+ gateway_enable=YES
+ hostname=erp.felten-group.com
+ ifconfig_em0='inet 192.168.1.14  netmask 255.255.255.0'
+ inetd_enable=YES
+ keymap=german.iso
+ font8x16=iso15-8x16
+ font8x8=iso15-8x8
+ sshd_enable=YES
+ webmin_enable=YES
+ vmware_guest_vmblock_enable=YES
+ vmware_guest_vmhgfs_enable=YES
+ vmware_guest_vmmemctl_enable=YES
+ vmware_guest_vmxnet_enable=YES
+ vmware_guestd_enable=YES
+ apache24_enable=YES
+ pf_enable=YES
+ pf_rules=/etc/pf.conf
+ pflog_enable=YES
+ pflog_logfile=/var/log/pflog
+ zabbix_agentd_enable=YES
+ openerpd_enable=YES
+ openerpweb_enable=YES
+ openerpweb_user=openerpd
+ postgresql_enable=YES
+ sourced_files=:/etc/rc.conf::/etc/rc.conf.local:
+ [ -r /etc/rc.conf.local ]
+ _rc_conf_loaded=true
+ [ -f /etc/rc.conf.d/postgresql ]
+ postgresql_enable=YES
+ postgresql_flags='-w -s -m fast'
+ postgresql_user=pgsql
+ eval 'postgresql_data=~pgsql/data'
+ postgresql_data=/usr/local/pgsql/data
+ postgresql_class=default
+ postgresql_initdb_flags='--encoding=utf-8 --lc-collate=C'
+ name=postgresql
+ rcvar=postgresql_enable
+ extra_commands='reload initdb'
+ start_cmd='postgresql_command start'
+ stop_cmd='postgresql_command stop'
+ restart_cmd='postgresql_command restart'
+ reload_cmd='postgresql_command reload'
+ status_cmd='postgresql_command status'
+ initdb_cmd=postgresql_initdb
+ [ -n '' ]
+ [ x != x -a xinitdb != x ]
+ command_args='-D /usr/local/pgsql/data -w -s -m fast'
+ run_rc_command initdb
+ _return=0
+ rc_arg=initdb
+ [ -z postgresql ]
+ shift 1
+ rc_extra_args=''
+ _rc_prefix=''
+ eval '_override_command=$postgresql_program'
+ _override_command=''
+ command=/usr/local/bin/pg_ctl
+ _keywords='start stop restart rcvar enabled reload initdb'
+ rc_pid=''
+ _pidcmd=''
+ _procname=/usr/local/bin/pg_ctl
+ [ -n /usr/local/bin/pg_ctl ]
+ [ -n '' ]
+ _pidcmd='rc_pid=$(check_process /usr/local/bin/pg_ctl )'
+ [ -n 'rc_pid=$(check_process /usr/local/bin/pg_ctl )' ]
+ _keywords='start stop restart rcvar enabled reload initdb status poll'
+ [ -z initdb ]
+ [ initdb = enabled ]
+ [ -n '' ]
+ eval 'rc_flags=$postgresql_flags'
+ rc_flags='-w -s -m fast'
+ eval '_chdir=$postgresql_chdir' '_chroot=$postgresql_chroot' '_nice=$postgresql_nice' '_user=$postgresql_user' '_group=$postgresql_group' '_groups=$postgresql_groups' '_fib=$postgresql_fib'
+ _chdir='' _chroot='' _nice='' _user=pgsql _group='' _groups='' _fib=''
+ [ -n pgsql ]
+ eval if [ -x /usr/bin/id '];' then /usr/bin/id '-un;' fi
+ [ -x /usr/bin/id ]
+ /usr/bin/id -un
+ [ pgsql = root ]
+ [ -z '' ]
+ eval 'rc_pid=$(check_process' /usr/local/bin/pg_ctl ')'
+ check_process /usr/local/bin/pg_ctl
+ _procname=/usr/local/bin/pg_ctl
+ _interpreter=''
+ [ -z /usr/local/bin/pg_ctl ]
+ _find_processes /usr/local/bin/pg_ctl . -ax
+ [ 3 -ne 3 ]
+ _procname=/usr/local/bin/pg_ctl
+ _interpreter=.
+ _psargs=-ax
+ _pref=''
+ [ . != . ]
+ _procnamebn=pg_ctl
+ _fp_args='_arg0 _argv'
+ _fp_match='case "$_arg0" in
		    $_procname|$_procnamebn|${_procnamebn}:|"(${_procnamebn})"|"[${_procnamebn}]")'
+ _proccheck='		/bin/ps -ww 2>/dev/null -o pid= -o jid= -o command= -ax |
		while read _npid _jid _arg0 _argv; do
			case "$_arg0" in
		    $_procname|$_procnamebn|${_procnamebn}:|"(${_procnamebn})"|"[${_procnamebn}]")
				if [ "$JID" -eq "$_jid" ];
				then echo -n "$_pref$_npid";
				_pref=" ";
				fi
				;;
			esac
		done'
+ eval /bin/ps -ww '2>/dev/null' -o pid= -o jid= -o command= -ax '|' while read _npid _jid _arg0 '_argv;' do case '"$_arg0"' in '$_procname|$_procnamebn|${_procnamebn}:|"(${_procnamebn})"|"[${_procnamebn}]")' if [ '"$JID"' -eq '"$_jid"' '];' then echo -n '"$_pref$_npid";' '_pref="' '";' fi ';;' esac done
+ /bin/ps -ww -o pid= -o jid= -o command= -ax
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ read _npid _jid _arg0 _argv
+ rc_pid=''
+ [ start != initdb ]
+ continue
+ [ stop != initdb ]
+ continue
+ [ restart != initdb ]
+ continue
+ [ rcvar != initdb ]
+ continue
+ [ enabled != initdb ]
+ continue
+ [ reload != initdb ]
+ continue
+ [ initdb != initdb ]
+ [ -n postgresql_enable -a initdb != rcvar -a initdb != stop ]
+ checkyesno postgresql_enable
+ eval '_value=$postgresql_enable'
+ _value=YES
+ debug 'checkyesno: postgresql_enable is set to YES.'
+ return 0
+ eval '_cmd=$initdb_cmd' '_precmd=$initdb_precmd' '_postcmd=$initdb_postcmd'
+ _cmd=postgresql_initdb _precmd='' _postcmd=''
+ [ -n postgresql_initdb ]
+ _run_rc_precmd
+ check_required_before initdb
+ local _f
+ return 0
+ [ -n '' ]
+ check_required_after initdb
+ local _f _args
+ return 0
+ return 0
+ _run_rc_doit 'postgresql_initdb '
+ debug 'run_rc_command: doit: postgresql_initdb '
+ eval 'postgresql_initdb '
+ postgresql_initdb
+ su -l -c default pgsql -c 'exec /usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /usr/local/pgsql/data'
function: not found
portsnap: Directory does not exist or is not writable: /var/db/portsnap
/tmp/d-75324-index/INDEX-10.bz2               100% of 1698 kB  259 kBps 00m06s
install: /usr/ports/INDEX-10: Permission denied
install: /usr/ports/INDEX-10.bz2: Permission denied
New version available: libtool-2.4.2.418
1 has a new version available
portaudit: not found
pkg_updating: not found
Syntax error: "}" unexpected
+ _return=2
+ [ 2 -ne 0 ]
+ [ -z '' ]
+ return 1
+ return 1
 
Last edited by a moderator:
Re: Can not start postgresql, get error "function: not found

This command gives this error:
Code:
[root@erp /usr/local/etc/rc.d]# su -l -c default pgsql -c 'exec /usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /usr/local/pgsql/data'
function: not found
portsnap: Directory does not exist or is not writable: /var/db/portsnap
/tmp/d-76532-index/INDEX-10.bz2               100% of 1698 kB  319 kBps 00m05s
install: /usr/ports/INDEX-10: Permission denied
install: /usr/ports/INDEX-10.bz2: Permission denied
New version available: libtool-2.4.2.418
1 has a new version available
portaudit: not found
pkg_updating: not found
Syntax error: "}" unexpected
 
Re: Can not start postgresql, get error "function: not found

Looks like a port update script has been pasted into the postgresql script.
 
Re: Can not start postgresql, get error "function: not found

There appears to be a couple of errors in the rc script.

Code:
su -l -c ${postgresql_class} ${postgresql_user} -c "exec /usr/local/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data}"

This should be
Code:
su -l -c ${postgresql_class} ${postgresql_user} "exec /usr/local/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data}"

There's also an error here:
Code:
su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
This should be
Code:
su -l ${postgresql_user} "exec ${command} ${command_args} ${rc_arg}"

I have no idea why it's executing those commands though, it might be some weird side effect of using su -c incorrectly.
 
Re: Can not start postgresql, get error "function: not found

My initial solution doesn't appear to be correct. The -c should be passed to the shell of the user. This seems to be the correct way:
Code:
su -l -c ${postgresql_class} ${postgresql_user} "-c exec /usr/local/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data}"

I still have no idea why portsnap(8) and all gets executed. But perhaps they're in @root's startup scripts.
 
Last edited by a moderator:
Re: Can not start postgresql, get error "function: not found

I have found the cause but not the solution.
By default, PostgreSQL uses the pseudo-user shell as /bin/sh.
After i change to /usr/local/bin/bash, the problem is solved but i do not know why.
 
Re: Can not start postgresql, get error "function: not found

OK and i found the cause.
I found this in /etc/profile

Code:
function ports-check {
  # FETCH LATEST PORTS TREE
    portsnap fetch update

     # CHECK WHAT NEW VERSIONS EXIST
    portmaster -L --index-only | awk '/ [Nn]ew / {print substr($0,9,9999)}'

     # CHECK SECURITY ISSUES
    portaudit -Fda

    # CHECK /usr/ports/UPDATING MESSAGES
    pkg_updating -d $( ls -ltr -D '%Y%m%d' /var/db/pkg | awk 'END{print $6}' )
}

function ports-update {
  # UPDATE ALL PACKAGES OR ONLY A SINGLE ONE USING STABLE PATH ON FTP
  case ${#} in
    (0) pkg_upgrade -C -a 2>&1 | grep --color=none --line-buffered -E "^(=+>|/usr/ports|/var/db)" ;;
    (*) pkg_upgrade -C $@ 2>&1 | grep --color=none --line-buffered -E "^(=+>|/usr/ports|/var/db)" ;;
  esac

    # FIX DEPENDENCIES AS NEEDED
    portmaster --check-depends
}

function ports-build {
  # REBUILD SINGLE, SEVERAL OR ALL PORTS
 case ${#} in
    (0) portmaster -y --no-confirm -m 'BATCH=yes' -d -a ;;
    (*) portmaster -y --no-confirm -m 'BATCH=yes' -d $@ ;;
  esac

 # FIX DEPENDENCIES AS NEEDED
  portmaster --check-depends
}

after remove this "function" in /etc/profile, now works without any problems
 
Back
Top