<div dir="ltr">MySQL has a option --password to provide the password on command line. postgres however does not. but here is some refs how you can accomplish what you would like. <a href="http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html">http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html</a> </div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 21, 2015 at 4:26 PM, Satish Patel <span dir="ltr"><<a href="mailto:satish.txt@gmail.com" target="_blank">satish.txt@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">can't we make password less? just like MySQL? </div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 21, 2015 at 1:56 PM, Podrigal, Aron <span dir="ltr"><<a href="mailto:aronp@guaranteedplus.com" target="_blank">aronp@guaranteedplus.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">It executes a series of sql files ( I don't remember the dir location where its stored I think somewhere in the share dir) for each file it asks for the password.</div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel <span dir="ltr"><<a href="mailto:satish.txt@gmail.com" target="_blank">satish.txt@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">I am installing opensips 1.11.3 with postgress DB but i don't know what is going on here<div><br></div><div><br></div><div><div>root@dopensips:/etc/opensips# opensipsdbctl create</div><div>INFO: creating database opensips ...</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "version_t_name_idx" for table "version"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "acc_id_seq" for serial column "<a href="http://acc.id" target="_blank">acc.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "acc_pkey" for table "acc"</div><div>NOTICE: CREATE TABLE will create implicit sequence "missed_calls_id_seq" for serial column "<a href="http://missed_calls.id" target="_blank">missed_calls.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "missed_calls_pkey" for table "missed_calls"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "domain_id_seq" for serial column "<a href="http://domain.id" target="_blank">domain.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "domain_pkey" for table "domain"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "domain_domain_idx" for table "domain"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "grp_id_seq" for serial column "<a href="http://grp.id" target="_blank">grp.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "grp_pkey" for table "grp"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "grp_account_group_idx" for table "grp"</div><div>NOTICE: CREATE TABLE will create implicit sequence "re_grp_id_seq" for serial column "<a href="http://re_grp.id" target="_blank">re_grp.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "re_grp_pkey" for table "re_grp"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "address_id_seq" for serial column "<a href="http://address.id" target="_blank">address.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "address_pkey" for table "address"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "aliases_id_seq" for serial column "<a href="http://aliases.id" target="_blank">aliases.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "aliases_pkey" for table "aliases"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "aliases_alias_idx" for table "aliases"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "location_id_seq" for serial column "<a href="http://location.id" target="_blank">location.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "location_pkey" for table "location"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "location_account_contact_idx" for table "location"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "silo_id_seq" for serial column "<a href="http://silo.id" target="_blank">silo.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "silo_pkey" for table "silo"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "dbaliases_id_seq" for serial column "<a href="http://dbaliases.id" target="_blank">dbaliases.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dbaliases_pkey" for table "dbaliases"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "dbaliases_alias_idx" for table "dbaliases"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "uri_id_seq" for serial column "<a href="http://uri.id" target="_blank">uri.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "uri_pkey" for table "uri"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "uri_account_idx" for table "uri"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "rtpproxy_sockets_id_seq" for serial column "<a href="http://rtpproxy_sockets.id" target="_blank">rtpproxy_sockets.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rtpproxy_sockets_pkey" for table "rtpproxy_sockets"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "speed_dial_id_seq" for serial column "<a href="http://speed_dial.id" target="_blank">speed_dial.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "speed_dial_pkey" for table "speed_dial"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "speed_dial_speed_dial_idx" for table "speed_dial"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "usr_preferences_id_seq" for serial column "<a href="http://usr_preferences.id" target="_blank">usr_preferences.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "usr_preferences_pkey" for table "usr_preferences"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "subscriber_id_seq" for serial column "<a href="http://subscriber.id" target="_blank">subscriber.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "subscriber_pkey" for table "subscriber"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "subscriber_account_idx" for table "subscriber"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "pdt_id_seq" for serial column "<a href="http://pdt.id" target="_blank">pdt.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pdt_pkey" for table "pdt"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "pdt_sdomain_prefix_idx" for table "pdt"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dialog_pkey" for table "dialog"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "dispatcher_id_seq" for serial column "<a href="http://dispatcher.id" target="_blank">dispatcher.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dispatcher_pkey" for table "dispatcher"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "dialplan_id_seq" for serial column "<a href="http://dialplan.id" target="_blank">dialplan.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dialplan_pkey" for table "dialplan"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "dr_gateways_id_seq" for serial column "<a href="http://dr_gateways.id" target="_blank">dr_gateways.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dr_gateways_pkey" for table "dr_gateways"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "dr_gateways_dr_gw_idx" for table "dr_gateways"</div><div>NOTICE: CREATE TABLE will create implicit sequence "dr_rules_ruleid_seq" for serial column "dr_rules.ruleid"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dr_rules_pkey" for table "dr_rules"</div><div>NOTICE: CREATE TABLE will create implicit sequence "dr_carriers_id_seq" for serial column "<a href="http://dr_carriers.id" target="_blank">dr_carriers.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dr_carriers_pkey" for table "dr_carriers"</div><div>NOTICE: CREATE TABLE / UNIQUE will create implicit index "dr_carriers_dr_carrier_idx" for table "dr_carriers"</div><div>NOTICE: CREATE TABLE will create implicit sequence "dr_groups_id_seq" for serial column "<a href="http://dr_groups.id" target="_blank">dr_groups.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dr_groups_pkey" for table "dr_groups"</div><div>Password for user postgres:</div><div>NOTICE: CREATE TABLE will create implicit sequence "load_balancer_id_seq" for serial column "<a href="http://load_balancer.id" target="_blank">load_balancer.id</a>"</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "load_balancer_pkey" for table "load_balancer"</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div><div>Password for user postgres:</div></div><div><br></div></div>
<br></div></div>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div><div dir="ltr">Aron Podrigal<div>-</div><div>//Be happy :-)</div></div></div>
</font></span></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr">Aron Podrigal<div>-</div><div>//Be happy :-)</div></div></div>
</div>