[OpenIndiana-discuss] Moving PG_DATA to nonstandard location?

[Bryan N Iotti]

Hi,

Yes, it is version 9.2.2 out of SFE:
sfe/database/postgres-92	pkg:/database/postgres-92 at 9.2.2-0.151.1.7
sfe/service/database/postgres-92	pkg:/service/database/postgres-92 at 9.2.2-0.151.1.7

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 <alp at rsu.ru> 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
> OpenIndiana-discuss at openindiana.org
> http://openindiana.org/mailman/listinfo/openindiana-discuss


-- 
Bryan N Iotti

ironsides.medvet at runbox.com
+39 366 3708436