You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi!
I have PostgreSQL, installed in jail. But zfs is at host system. Because of this, cant working command from lib/zfstools/snapshot.rb
I need one parameter in two places at line 74: cmd = %Q[(psql <<HERE!!!>> -c "#{sql_pre_query}" postgres ; #{zfs_cmd} ) ; psql <<AND_HERE!!!>> -c "#{sql_post_query}" postgres]
to put there something like -U postgres -h jail.host.local
But I not understand, how most correctly do this. May be someone can tell me some about?
And after some thought ...
I think, that good idea create parameter in zfs properties, whose value would be the name of the variable containing the necessary launch flags... Because now I have one jail with postgres, but very soon I will have second.
And in this case also good idea to put variable with launch flags in file at /usr/local/etc.
The text was updated successfully, but these errors were encountered:
ndruba
changed the title
Changes for Postgre in jail.
Changes for PostgreSQL in jail.
Dec 24, 2019
Hi!
I have PostgreSQL, installed in jail. But zfs is at host system. Because of this, cant working command from lib/zfstools/snapshot.rb
I need one parameter in two places at line 74:
cmd = %Q[(psql <<HERE!!!>> -c "#{sql_pre_query}" postgres ; #{zfs_cmd} ) ; psql <<AND_HERE!!!>> -c "#{sql_post_query}" postgres]
to put there something like
-U postgres -h jail.host.local
But I not understand, how most correctly do this. May be someone can tell me some about?
And after some thought ...
I think, that good idea create parameter in zfs properties, whose value would be the name of the variable containing the necessary launch flags... Because now I have one jail with postgres, but very soon I will have second.
And in this case also good idea to put variable with launch flags in file at /usr/local/etc.
The text was updated successfully, but these errors were encountered: