public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162018-11-09T21:47:09Zpublic.commandprompt.com
Redmine PL/php - Bug #5350 (New): Fwd: Telcel redhttps://public.commandprompt.com/issues/53502018-11-09T21:47:09Zbriana26c -briana26c@gmail.com
<p>-------- Mensaje original --------De: briana26c <<a class="email" href="mailto:briana26c@gmail.com">briana26c@gmail.com</a>> Fecha: 4/11/18 1:05 PM (GMT-06:00) A: <a class="email" href="mailto:plphp-tickets@lists.commandprompt.com">plphp-tickets@lists.commandprompt.com</a> Asunto: Telcel red</p> PL/php - Bug #5349 (New): Telcel redhttps://public.commandprompt.com/issues/53492018-11-04T11:06:10Zbriana26c -briana26c@gmail.compostgres_fdw - Bug #5345 (New): Follow-uphttps://public.commandprompt.com/issues/53452017-11-28T15:16:48ZKaren Edwardskaren.edwards@blockchaintechdb.com
<p>Hello ,</p>
<p>Hope all is well!</p>
<p>I was trying to reach you today in regards to an email I sent you last<br />quarter. I understand with so many database offers these days it's very<br />difficult to know who has the right contact data. So let's get some relevant<br />samples in-line with your target markets & some of the references from our<br />top clients before you could decide on your database vendor.</p>
<p>Please let me know your specific target demographics below, I will get back<br />to you with relevant counts & a sample for your review.</p>
<p>Industry:</p>
<p>Geography:</p>
<p>Titles:</p>
<p>If there is some else I need to talk to please let me know.</p>
<p>I really look forward to hearing from you.</p>
<p>Regards</p>
<p>Karen Edwards</p>
<p>1060 Capp St,</p>
<p>San Francisco, CA 94110,</p>
<p>USA</p>
<p>If you don't wish to receive emails from us reply back with "Leave Out" and<br />we will make sure you don't receive any more email from us.</p>
<p>----------------------------------------------------------------------------<br />----------------------------------------------------------------------------<br />------------------------------</p>
<p>From: Karen Edwards <<a class="email" href="mailto:karen.edwards@blockchaintechdb.com">karen.edwards@blockchaintechdb.com</a>><br />Sent: Wednesday, August 16 2:12 PM<br />To: <a class="email" href="mailto:postgres_fdw@commandprompt.com">postgres_fdw@commandprompt.com</a></p>
<p>Subject: RE: Schedule Call</p>
<p>Hello</p>
<p>Good day to you.</p>
<p>Would you be interested in highly potential and responsive business Database<br />for your business marketing, events, exhibitions and conferences?</p>
<p>We are the leading database solution provider and can certainly assist you<br />by providing permission based contacts from any B2B industries across the<br />globe.</p>
<p>INDUSTRY: (Any INDUSTRY you prefer)</p>
<p>01-09 Agriculture, Forestry, Fishing</p>
<p>10-14 Mining</p>
<p>15-17 Construction</p>
<p>20-39 Manufacturing</p>
<p>40-49 Transportation & Public Utilities</p>
<p>50-51 Wholesale Trade</p>
<p>52-59 Retail Trade</p>
<p>60-67 Finance, Insurance, Real Estate</p>
<p>70-89 Services</p>
<p>91-99 Public Administration</p>
<p>TITLE: Owner, Founders, CEO, CTO, CFO, CMO, VP, Directors, Heads, Managers,<br />Executives, from any department</p>
<p>GEOGRAPHY: Any country/region you prefer across the Globe</p>
<p>Let me know your target requirement like: Industries : ?, Job Titles : ?,<br />Geography : ?</p>
<p>Looking forward to hearing from you.</p>
<p>Karen Edwards</p>
<p>1060 Capp St,</p>
<p>San Francisco, CA 94110,</p>
<p>USA</p>
<p>If you don't wish to receive emails from us reply back with "Leave Out" and<br />we will make sure you don't receive any more email from us.</p> 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> 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> pitrtools - 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 #5225 (New): Unable to build PL/php on OS X (PHP 5.3)https://public.commandprompt.com/issues/52252010-06-29T05:25:59ZAlexey Klyukinalexk@commandprompt.com
<p>On OS X embed is built as a bundle instead of a library, making it impossible to link against it.</p>
<p>I've submitted the problem to the PHP project:<br /><a class="external" href="http://bugs.php.net/bug.php?id=48318">http://bugs.php.net/bug.php?id=48318</a></p>
<p>Still, it's not possible to build PL/php at the moment on this platform.</p> Pggraph - Bug #4943 (New): Future Planning and Ideashttps://public.commandprompt.com/issues/49432008-07-14T11:32:17ZAurynn Shawashaw@commandprompt.com
<ul>
<li>Javascript+SVG-based graphs, based on example code Darcy showed off a while back. This would allow us to do offset-based graphs (clicking an offset of, say, 5 days scrolls it back in time that far), as well as the ability to do click & drag ala the Google Maps interface.</li>
</ul> Pggraph - Feature #4933 (New): Feature requests, pggraphhttps://public.commandprompt.com/issues/49332008-03-12T12:44:15ZAurynn Shawashaw@commandprompt.com
<p>From cashnet:</p>
<pre>
Should at least display timezone on graphs (would be better if this was configurable).
Unused indexes is too strict, assuming that it's just looking for 0 idxscans (since it's not showing that, I don't know... :) ). It should show index usage stats, and also include indexes that have low usage, perhaps compared to other indexes on the table, or to table stats.
It'd also be good to have a report of tables that could use indexes. I'll typically use a metric like tablescans * relpages, with a cap of say 100 or 200. If this was done with stats over time the metric would essentially be "here's tables that we're doing more than X sequential pages per $unit_time".
</pre> Pggraph - Feature #4932 (New): Have pggraph directly access Wiki passwordshttps://public.commandprompt.com/issues/49322007-12-31T10:28:34ZAurynn Shawashaw@commandprompt.com
<p>Should we have pggraph be on its own, independent password auth, or link it directly to the wiki pw auth?</p> Pggraph - Feature #4931 (New): Develop a nagios plugin for pggraph checkshttps://public.commandprompt.com/issues/49312007-12-18T19:24:29ZDevrim Gunduzdevrim@commandprompt.com
<p>Develop a nagios plugin for pggraph checks</p> Pggraph - Feature #4926 (New): insert/update/deletehttps://public.commandprompt.com/issues/49262007-08-20T16:15:10Zbford -bford@foo.bar
<p>We have the ability to see which relations did what type of dml for a given interval. However we don't have the ability to see that data database wide. What I would to see is on the database graph to have the option to select DML which would sum the n_tup_ins, n_tup_del and n_tup_update for all relations on the particular database and graph it based on the interval.</p> Pggraph - Feature #4925 (New): Allow graphing specific intervalshttps://public.commandprompt.com/issues/49252007-07-03T08:28:32ZDarcy Buskermolendarcyb@foo.bar
<p>Add the ability to graph a specific block of time.</p>
<p>IE I'd like to see the 10 minute graph from 2 weeks ago, so that I can inspect Foo. and corilate it with information provided by a customer.</p>