public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162012-09-17T04:13:45Zpublic.commandprompt.com
Redmine 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 #4960 (New): pg error of pggraph_2_2https://public.commandprompt.com/issues/49602008-12-30T09:09:04ZDevrim Gunduzdevrim@commandprompt.com
<pre>
pggraph_2_2 2008-12-30 09:15:22 PST 24681 ERROR: permission denied to set parameter "log_duration"
</pre> Pggraph - Bug #4959 (New): Upgrade all present pggraph clients to pggraph_2_2https://public.commandprompt.com/issues/49592008-07-28T08:07:29ZAurynn Shawashaw@commandprompt.com
<p>As description. This should be doable with a simple upgrade script. I'd think about 4 hours to throw the script together.</p> Pggraph - Bug #4954 (New): pggraph_clientshttps://public.commandprompt.com/issues/49542008-07-25T07:59:35ZAurynn Shawashaw@commandprompt.com
<p>for pggraph 2.2, the create_owner_tables function in the installer needs to create a pggraph_clients table that stores data about pggraph client installs for the rollup/averaging function.</p>
<p>This is not presently created by the installer.</p> Pggraph - Bug #4950 (New): Write unit testshttps://public.commandprompt.com/issues/49502008-07-17T17:02:20ZAurynn Shawashaw@commandprompt.com
<p>This is pretty obvious</p> Pggraph - Bug #4940 (New): Remove prefixeshttps://public.commandprompt.com/issues/49402008-07-14T11:05:46ZAurynn Shawashaw@commandprompt.com
<p>As we are moving to a schema'd design, remove the prefix additions from the code and all new installations.</p>
<p>This involves a plpgsql function signature change.</p> Pggraph - Bug #4936 (New): Modify averaging functionshttps://public.commandprompt.com/issues/49362008-07-14T10:11:55ZAurynn Shawashaw@commandprompt.com
<p>All plpgsql functions will need two new arguments, and one removed argument:</p>
<p>start DATE, end DATE, and removal of offset INT.</p>
<p>The functions will be altered in the following ways:</p>
<ul>
<li>Determining the length of the WHILE loop from the date ranges, if present, instead of using the interval to calculate it.</li>
<li>Alter the queries to use the start DATE parameter to position the start of the set, and then utilize the WHILE loop to offset from that point, ie, WHERE date = date_start + (interval * iterations)::interval</li>
</ul> Pggraph - Feature #4915 (In Progress): insert_time should be timestamptzhttps://public.commandprompt.com/issues/49152007-03-21T06:35:32ZDarcy Buskermolendarcyb@foo.bar
<p>We should be providing all date logging with timestamps, so that it's easier to work in our clients respective timezones</p> Pggraph - Feature #4914 (In Progress): customer feedbackhttps://public.commandprompt.com/issues/49142007-03-19T20:54:29Zbford -bford@foo.bar
<p>(08:53:42 PM) linuxpoet: oh you mean like a custom repot?<br />(08:53:51 PM) Crad: Something like <a class="external" href="http://server12.uac.ehpg.net/rtg/view.php?rid=1">http://server12.uac.ehpg.net/rtg/view.php?rid=1</a> would be awesome<br />(08:54:00 PM) Crad: even if I had to pick the tables to show.<br />(08:54:34 PM) linuxpoet: yeah we could probably do something like that<br />(08:54:41 PM) linuxpoet: let me make a ticket so we don't loose it</p> Pggraph - Feature #4908 (In Progress): Table statistics tablenamehttps://public.commandprompt.com/issues/49082007-01-07T19:26:28Zbford -bford@foo.bar
<p>We need to consider drawing this during initial load or reworking the menu set so that the user selects their relation which then loads the table name that they can graph off if.</p> Pggraph - Feature #4901 (New): pggraph_table doesn't list tableshttps://public.commandprompt.com/issues/49012006-12-29T17:18:15Zbford -bford@foo.bar
<p>If you go to the table graphing, it will not list the tables until you click show at least once. It would make sense to grab the table names on display of the page.</p> Pggraph - Feature #4890 (In Progress): new report(s)https://public.commandprompt.com/issues/48902006-09-25T22:36:40ZDarcy Buskermolendarcyb@foo.bar
<p>Create a new report that compares the relation size to the number of tuples in the relation, this can be used to help show relation bloat over time. This report(s) should contain indexes as well as tables.</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>