Hi, Yes, it is version 9.2.2 out of SFE: sfe/database/postgres-92 pkg:/database/[email protected] sfe/service/database/postgres-92 pkg:/service/database/[email protected]
Thank you for the testing, I wonder though if moving it to a completely different ZFS pool makes a difference... Also, /hipster has version 9.3, so maybe I just hit a bug in the SMF descriptors for 9.2... I'll investigate this further using the files from my laptop (/hipster, 9.3) vs this machine (151a9, 9.2). I'll probably also try 9.2 on /hipster, if it's still available, to rule out version-specific issues. Again, thank you for your reply. Bryan On Sat, 03 May 2014 12:05:37 +0400 Alexander Pyhalov <[email protected]> wrote: > Hi. > > I know it can be of little help, but I've checked that these issues > doesn't affect /hipster. > > $ pfexec cp -a /var/postgres/9.3/data_64 /var/data_64 > $ pfexec svccfg -s svc:/application/database/postgresql_93:default_64bit > svc:/application/database/postgresql_93:default_64bit> setprop > postgresql_93/data = astring: /var/data_64 > $ pfexec svcadm refresh > svc:/application/database/postgresql_93:default_64bit > $ svcprop svc:/application/database/postgresql_93:default_64bit |grep > postgresql_93/data > postgresql_93/data astring /var/data_64 > $ pfexec svcadm enable > svc:/application/database/postgresql_93:default_64bit > $ svcs svc:/application/database/postgresql_93:default_64bit > STATE STIME FMRI > online 12:00:09 > svc:/application/database/postgresql_93:default_64bit > $ ps ax |grep post > 25578 ? S 0:00 /usr/postgres/9.3/bin/amd64/postgres -D > /var/data_64 > 25580 ? S 0:00 /usr/postgres/9.3/bin/amd64/postgres -D > /var/data_64 > 25581 ? S 0:00 /usr/postgres/9.3/bin/amd64/postgres -D > /var/data_64 > 25582 ? S 0:00 /usr/postgres/9.3/bin/amd64/postgres -D > /var/data_64 > 25583 ? S 0:00 /usr/postgres/9.3/bin/amd64/postgres -D > /var/data_64 > 25584 ? S 0:00 /usr/postgres/9.3/bin/amd64/postgres -D > /var/data_64 > 25585 ? S 0:00 /usr/postgres/9.3/bin/amd64/postgres -D > /var/data_64 > > shared buffers is set to 1GB: > > template1=# select name,unit,setting from pg_settings where > name='shared_buffers'; > name | unit | setting > ----------------+------+--------- > shared_buffers | 8kB | 131072 > > template1=# select 8*131072/1024; > ?column? > ---------- > 1024 > > > Where is your PostgreSQL coming from ? SFE? > It seems the latest PostgreSQL available from OpenIndiana /dev > repository is 8.4. > > > Bryan N Iotti ????? 03.05.2014 02:37: > > Hi all, > > > > I'm experimenting with Postgres on OI 151a9 and I ran into a curious > > issue. > > > > I'm using the version from the OI pkg repo, 9.2 > > > > It works fine as long as I don't try to move the PG_DATA directory > > somewhere else. > > > > Basically, I'd like to move it to another ZFS filesystem to see the > > effects of logbias=latency and take advantage of more IOPS on that > > pool. > > > > I create a zfs filesystem called tank/postgres. > > I change the ownership of the directory to postgres:postgres. > > As the postgres user I run initdb with that dir as target. > > I change the SMF property for postgresql_92/data to that dir. > > I can start the DB manually as postgres, but via SMF it will kill the > > service as 'restarting too quickly'. > > I did a svcadm disable/refresh/enable, tried a reboot... nothing. As > > soon as I change that dir it freaks out and I can't start the service. > > > > Any pointers on that? > > > > Also, I'm using the 64 bit version, but I can't set the shared_memory > > config to more than 512MB or it complains that it overflows size_t, > > even with the default 100 connections. > > > > The machine has 32GB of RAM and I have 18GB at least free. > > > > What could I do to affect that limit? > > --- > System Administrator of Southern Federal University Computer Center > > > _______________________________________________ > OpenIndiana-discuss mailing list > [email protected] > http://openindiana.org/mailman/listinfo/openindiana-discuss -- Bryan N Iotti [email protected] +39 366 3708436 _______________________________________________ OpenIndiana-discuss mailing list [email protected] http://openindiana.org/mailman/listinfo/openindiana-discuss
