public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162017-08-02T23:44:00Zpublic.commandprompt.com
Redmine postgresql-snap - Task #5340 (New): Change package namehttps://public.commandprompt.com/issues/53402017-08-02T23:44:00ZIvan Lezhnjov
<p>We need to change the name of the snap packages from Postgresql to Postgres.</p> postgresql-snap - Task #5339 (New): Explore tracks featurehttps://public.commandprompt.com/issues/53392017-06-09T03:47:00ZIvan Lezhnjov
<p>While working on <a class="issue tracker-4 status-3 priority-4 priority-default closed" title="Task: Explore app alias functionality (Resolved)" href="https://public.commandprompt.com/issues/5338">#5338</a> (Explore app alias functionality), I was asked in snapcraft forum if we had any plans to support tracks instead of using version number in a package name.</p>
<p>On a quick look, tracks seems like a central feature of snap's package management design and we most likely will have to start using it.</p>
<p>Essentially, it is a way to catalog software using the following scheme track/risk/branch.</p>
<p>E.g. 9.3/stable/psql-freeze-fix</p>
<p>I will make some tests to get a good idea about how it works, how we could transition from the current approach and start using tracks.</p>
<p>Ivan</p> postgres_fdw - Bug #5326 (New): Ubuntu Users Email Listhttps://public.commandprompt.com/issues/53262016-11-15T07:03:50ZMelony Scheidmelonyscheid526@gmail.com
<p>Hi,</p>
<p>Would you keep on Ubuntu users Email List for your organizations<br />requirement?</p>
<p><strong>Data Fields:</strong> Name, Title, Email Address, Fax Number, Company Name,<br />Current Address, Country Name, State/Province, City Name, Zip Code, Contact<br />Number, Employee size, SIC Code, Industry, NAICS and Web Address.</p>
<p><strong>Information Source:</strong> Trade shows, Seminars, Surveys, Trade Magazines,<br />Technology Directories, Online Subscriptions, Business Directories,<br />Webinar, Exhibition and more.</p>
<p>Please get back to us with your targeted geography and job titles you are<br />looking to target for to provide you with counts and more information.</p>
<p>Await your response!</p>
<p>Thanks,</p>
<p>Melony Scheid</p>
<p>If you are not interested, reply back with the same in subject line.</p> postgres_fdw - Bug #5318 (New): C-Level, VP-Level, Directors and Manager Contactshttps://public.commandprompt.com/issues/53182016-06-08T07:52:53ZTatum LauTatum.Lau@SoftwareDetail.biz
<p>Hi,</p>
<p>Would you be interested in highly responsive B2B Mailing List for your<br />business marketing, events and projects?</p>
<p>We provide contacts from all the industries like Oil and Gas, Payroll,<br />Technology, Healthcare, Hospitality, Telecom, e-commerce and many more.</p>
<p>We can provide you with titles like:</p>
<p>CIO, CEO, CFO, CTO and COO</p>
<p>IT Directors, VP of IT and IT Managers</p>
<p>VP of Finance, Director of Finance and Finance Manager</p>
<p>HR Manager, HR Director and VP of HR</p>
<p>Marketing Manager, Marketing Director and VP of Marketing</p>
<p>Sales Manager, Director of Sales and VP of Sales</p>
<p>And many more from job functions and industries.</p>
<p>Let me know the titles and industry you are looking for your campaign so I<br />can provide you with further information for the same.</p>
<p>Await your response!</p>
<p>Regards,</p>
<p>Tatum Lau</p>
<p>Information Analyst </p>
<pre><code>To Opt Out, please respond "Leave Out" in<br />the Subject line.</code></pre> pitrtools - Feature #5315 (New): cmd_standby: Data Directory vs. Configuration Directory?https://public.commandprompt.com/issues/53152015-05-14T15:57:15ZMichael Vitalemichael@commandprompt.com
<p>Normally on most distros except Ubuntu, you can run pg_ctl command to start, stop, init the cluster, etc. On Ubuntu, (it is much more elaborate, to my liking I must say), where pg_ctl is enclosed within the wrapper, pg_ctlcluster. Not only that, but there is a separation between the data directory and the configuration directory:<br />configuration directory: /etc/postgresql/<version>/main<br />data directory : /var/lib/postgresql/<version>/main</p>
<p>Now to the point and how it relates to PITR TOOLS. By default, PITR TOOLs uses pg_ctl. It offers the option to either copy your configuration files specified in cmd_standby.conf to the data directory, or just start pg_ctl with the confs specified on the command line:</p>
<p>no_copy_conf: true --> command line specification of confs<br />no_copy_conf: false--> confs are copied to data directory</p>
<p>It would be nice if we had another parameter defined right under pgdata in cmd_standby.ini:<br />pgdata: /var/lib/postgresql/9.3/main</p>
<p>-- new proposed attribute<br />pgconf: /etc/postgresql/9.3/main</p>
<p>one implementation solution of many:<br />The cmd_standby executable could be modified slightly so that whenever pg_ctl is invoked and if no_copy_conf is false, and pgconf is not empty, then copy the specified conf files to the pgconf directory instead of the default action: copying them to the data directory. Furthermore, when pg_ctl is invoked in these cases pass to it as the -D parameter, the conf directory, not the data directory.</p> postgres_fdw - Bug #5301 (New): My husband loves Jacob & Cohttps://public.commandprompt.com/issues/53012014-05-08T03:17:20ZPostgres fdwgettu@fenwickkeats.compostgres_fdw - Bug #5292 (New): [SPAM] Good shoes good priceshttps://public.commandprompt.com/issues/52922014-04-11T14:06:06ZLadyregina -apei@cat-atelierduchateau.compitrtools - Feature #5265 (New): Avoid the need to manually edit postgresql.conf fileshttps://public.commandprompt.com/issues/52652012-09-17T04:13:45ZAlexey Klyukinalexk@commandprompt.com
<p>Right now, we have a bizarre combination of running cmd_archiver from the command line and plugging it in postgresql.conf manually. Given that we already know the location of postgresql.conf, we can edit it to set all necessary options (wal_level, max_wal_senders, archive_mode, archive_command) automatically, leaving only database restart as a task that should be performed manually.</p> pitrtools - Discussion #5263 (New): PITRTools ini configuration files are too complexhttps://public.commandprompt.com/issues/52632012-09-17T04:03:52ZAlexey Klyukinalexk@commandprompt.com
<p>Since we position PITRTools as a tool to simplify WAL-shipping and replication setup, I though I'd count the number of options once needs to set in PIRTools, against pristine PostgresSQL:</p>
<p>PITRTools:<br />Archiver: 15<br />Standby: 31.</p>
<p>Comparing to the pristine PostgreSQL:<br />primary: (wal_level, archive_mode, archive_command, max_wal_senders) - 4.</p>
<p>standby (most of them belong to recovery.conf): (hot_standby, standby_mode, primary_conninfo, restore_command, archive_cleanup_command): 5</p>
<p>We need to rethink PITRTools configuration options. I've made the first step by splitting them into required and uncommon, and put reasonable defaults for the second ones (i.e. assumed ssh and rsync path is fixed, and there is no need to tweak rsync options or set ssh_debug), but to make the tool easier than pristine PostgreSQL we need to put some code to autodetect some of the parameters (i.e. autodetect things like PostgreSQL version, checkpoint_segments value for 8.2 and below, rsync_version, etc.)</p> PL/php - Bug #5260 (New): The function could not return varchar string -- When there is function ...https://public.commandprompt.com/issues/52602011-11-02T23:16:35Zanthony chenzhihong.chen.cn@gmail.com
<p>There is pl/php definition as attached plsimple.sql. Which include other files blank.php.</p>
<p>Run first time:<br />test=# select plsimple();<br /> plsimple<br />----------</p>
<p>(1 row)</p>
<p>test=#<br />Run second time:<br />test=# select plsimple();<br /> plsimple<br />--------------<br /> Hello world!<br />(1 row)</p>
<p>When remove the definition of function test() in the blank.php, the issue disppears.</p> postgres.js - Support #5257 (New): method to catch error on connection?https://public.commandprompt.com/issues/52572011-05-26T09:15:50ZRick Hardingrharding@mitechie.com
<p>I'm trying to figure out how to properly catch an exception such as when the db server is unavailable. I've tried binding to a connection.on('error') event, but it doesn't look like it emits one. I see 'error' emitted when a query fails, but nothing on the actual connection attempt. Am I missing the proper way to handle that?</p>
<p>Thanks</p> PL/php - Feature #5236 (New): pg_raise to PHP Objecthttps://public.commandprompt.com/issues/52362010-07-29T11:07:09ZMoisés P. Senamoisespsena@gmail.com
<p>pg_raise to PHP Object</p>
<pre>
PGRaise::note('Note');
PGRaise::error('Error MSG');
// or
throw new PGException('error');
try {
PGRaise::error('MSG');
// or
throw new PGRaiseError('error');
}
catch(PGRaiseError $e)
{
PGRaise::note('ERROR IS Code: ' . $e->getCode() . ' - MSG: ' . $e->getMessage());
}
</pre> PL/php - Feature #5235 (New): SPI Object and not functionhttps://public.commandprompt.com/issues/52352010-07-29T10:48:04ZMoisés P. Senamoisespsena@gmail.com
<p>Today it uses the functions "SPI_ *" to perform query on database. It would be interesting if there was an object with methods to this question, style "PDO".</p>
<p>For example:</p>
<pre>
// of "SELECT PG_get_exp('x','y','z')" to
$fnResult = PG::fn->pg_get_exp('x','y','z')
$status = PG::status()
$chages = PG::exec()
$res = PG::query()
$res->count()
$res->next()
$res->rewind()
$item = $res->fetchRow()
$item = $res->fetchObject()
$item = $res->fetchArray()
or
while(($item = $res->fetchObject('ns\Class'))!=null)
</pre> Simpycity - Bug #5000 (New): Automatic Rollback Fix.https://public.commandprompt.com/issues/50002009-04-29T11:22:37ZLacey Powerslacey.powers@commandprompt.com
<p>Simpycity doesn't always issue a rollback for some transactions, such as failed functions.</p>
<p>This should be fixed, and an appropriate test case created to verify the fix and test in future releases.</p> PL/php - Feature #4979 (In Progress): Add support for IN/OUT parametershttps://public.commandprompt.com/issues/49792005-12-05T07:37:14ZÁlvaro Herreraalvherre@commandprompt.com
<p>Add support for OUT parameters so that the user can skip specifying a return type explicitely.</p>