Re: [GENERAL] Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6
By default the postgres user's group is 'daemon' on my Mac. This is probably true for you as well. Change occurrences of 'postgres:postgres' in your chown commands to 'postgres:daemon'. For what it's worth, here's the user groups and permissions I see on my Mac. I used the installer from EnterpriseDB.com for my Snow Leopard MacBook. Typing the 'id' command-line tool: id postgres Renders this: uid=502(postgres) gid=1(daemon) groups=1(daemon),403(com.apple.sharepoint.group.2),61(localaccounts),12(everyone),402(com.apple.sharepoint.group.1) So, daemon is the primary group, along with 4 other groups. /Library/PostgreSQL +--+-+ |system| Read Write | +--+-+ |admin |Read only| +--+-+ | everyone |Read only| +--+-+ /Library/PostgreSQL/9.0 /Library/PostgreSQL/9.1 /Library/PostgreSQL/9.1/bin /Library/PostgreSQL/9.1/lib /Library/PostgreSQL/9.1/pgAdmin3.app +--+-+ |system| Read Write | +--+-+ |daemon|Read only| +--+-+ | everyone |Read only| +--+-+ /Library/PostgreSQL/9.1/data +--+-+ | postgres | Read Write | +--+-+ | everyone |No Access| +--+-+ --Basil Bourque -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6
[…] --- Installing postgresql90-server @9.0.5_0 To create a database instance, after install do sudo mkdir -p /opt/local/var/db/postgresql90/defaultdb sudo chown postgres:postgres /opt/local/var/db/postgresql90/defaultdb sudo su postgres -c '/opt/local/lib/postgresql90/bin/initdb -D /opt/local/var/db/postgresql90/defaultdb' To tweak your DBMS, consider increasing kern.sysv.shmmax by adding an increased kern.sysv.shmmax .. to /etc/sysctl.conf --- Activating postgresql90-server @9.0.5_0 --- Cleaning postgresql90-server Sun Oct 23 12:45:49 -- server :: sudo mkdir -p /opt/local/var/db/postgresql90/defaultdb Sun Oct 23 12:48:41 -- server :: sudo chown postgres:postgres /opt/local/var/db/postgresql90/defaultdb chown: postgres: Invalid argument Sun Oct 23 12:48:51 -- server :: So, according to the above instructions (and the tutorials I've read), this should simply work. What am I missing? On a different note, I have a couple questions concerning PostgreSQL security: 1. My understanding is that making the defaultdb directory owned by the postgres user is for security. Correct? 2. Whenever starting psql, I have on my own machines had to specify psql -U postgres, because: Sun Oct 23 14:27:28 -- Frodo :: psql psql: FATAL: role rene does not exist So, I do I need to add a role/user for my OS X user name? Coming from MySQL, I find the devil is in the details. Just trying to figure things out… Thanks! …Rene -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6
By default the postgres user's group is 'daemon' on my Mac. This is probably true for you as well. Change occurrences of 'postgres:postgres' in your chown commands to 'postgres:daemon'. On 10/23/2011 8:16 PM, René Fournier wrote: […] --- Installing postgresql90-server @9.0.5_0 To create a database instance, after install do sudo mkdir -p /opt/local/var/db/postgresql90/defaultdb sudo chown postgres:postgres /opt/local/var/db/postgresql90/defaultdb sudo su postgres -c '/opt/local/lib/postgresql90/bin/initdb -D /opt/local/var/db/postgresql90/defaultdb' To tweak your DBMS, consider increasing kern.sysv.shmmax by adding an increased kern.sysv.shmmax .. to /etc/sysctl.conf --- Activating postgresql90-server @9.0.5_0 --- Cleaning postgresql90-server Sun Oct 23 12:45:49 -- server :: sudo mkdir -p /opt/local/var/db/postgresql90/defaultdb Sun Oct 23 12:48:41 -- server :: sudo chown postgres:postgres /opt/local/var/db/postgresql90/defaultdb chown: postgres: Invalid argument Sun Oct 23 12:48:51 -- server :: So, according to the above instructions (and the tutorials I've read), this should simply work. What am I missing? On a different note, I have a couple questions concerning PostgreSQL security: 1. My understanding is that making the defaultdb directory owned by the postgres user is for security. Correct? 2. Whenever starting psql, I have on my own machines had to specify psql -U postgres, because: Sun Oct 23 14:27:28 -- Frodo :: psql psql: FATAL: role rene does not exist So, I do I need to add a role/user for my OS X user name? Coming from MySQL, I find the devil is in the details. Just trying to figure things out… Thanks! …Rene -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Problem installing postgresql 7.3.6 on Redhat 7.3
Dear group, I would like to know where I could find rpms for Redhat 7.3. I have looked at the downloads page and I see only source rpms and rpms for Redhat 9 and FC1. I did download the src rpm and when I run the rpm -ba postgresql.spec I get the following error message: configure: error: could not find function 'krb5_encrypt' required for Kerberos 5 error: Bad exit status from /var/tmp/rpm-tmp.93268 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.93268 (%build) How do I get over this. Regards, Shan. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[GENERAL] Problem installing Postgresql
I am running OpenLinux 2.3 (Caldera) out of the box. Trying to install PostGreSQL I seem to be unable to get past the 'make' process. Errors I get at the end of the process are: make[3]: *** [pg_backup_custom.o] Error 1 make[3]: Leaving directory `/addon/postgresql-7.1/src/bin/pg_dump' make[2]: *** [all] Error 2 make[3]: Leaving directory `/addon/postgresql-7.1/src/bin/' make[1]: *** [all] Error 2 make[3]: Leaving directory `/addon/postgresql-7.1/src' make: *** [all] Error 2 Some examples of errors I see in the output are: pg_backup_custom.c: In function `_DoDeflate': pg_backup_custom.c:925:`z_streamp' undeclared (first use in this function) pg_backup_custom.c:925: parse error before `zp' pg_backup_custom.c:928: 'ctx' undecleared (first use in this function) Please note that I am fairly new to Linux so a lot of this isn't making sense. Any ideas? ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] Problem installing Postgresql
Hi, What package do you have downloaded ? You need the full install not just the base package. Regards, Gilles Al wrote: I am running OpenLinux 2.3 (Caldera) out of the box. Trying to install PostGreSQL I seem to be unable to get past the 'make' process. Errors I get at the end of the process are: make[3]: *** [pg_backup_custom.o] Error 1 make[3]: Leaving directory `/addon/postgresql-7.1/src/bin/pg_dump' make[2]: *** [all] Error 2 make[3]: Leaving directory `/addon/postgresql-7.1/src/bin/' make[1]: *** [all] Error 2 make[3]: Leaving directory `/addon/postgresql-7.1/src' make: *** [all] Error 2 Some examples of errors I see in the output are: pg_backup_custom.c: In function `_DoDeflate': pg_backup_custom.c:925:`z_streamp' undeclared (first use in this function) pg_backup_custom.c:925: parse error before `zp' pg_backup_custom.c:928: 'ctx' undecleared (first use in this function) Please note that I am fairly new to Linux so a lot of this isn't making sense. Any ideas? ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]