public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162018-11-04T11:06:10Zpublic.commandprompt.com
Redmine PL/php - Bug #5349 (New): Telcel redhttps://public.commandprompt.com/issues/53492018-11-04T11:06:10Zbriana26c -briana26c@gmail.compostgresql-snap - Bug #5331 (New): PgBackResthttps://public.commandprompt.com/issues/53312017-02-10T09:56:05ZJoshua Drake
<p>It is time to add PgBackRest to the repository.</p>
<p>JD<br />-- <br />Command Prompt, Inc. <a class="external" href="http://the.postgres.company/">http://the.postgres.company/</a><br /> +1-503-667-4564<br />PostgreSQL Centered full stack support, consulting and development.<br />Everyone appreciates your honesty, until you are honest with them.<br />Unless otherwise stated, opinions are my own.</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 #5316 (New): (no subject)https://public.commandprompt.com/issues/53162016-01-18T04:11:29ZJulieta Clubbjulv4xclubb@inbox.ru
<p>Get dressed for success here<br /><a class="external" href="http://rhcosnjpscdn.%73%70%65%63%69%61%6c%72%65%70%67%69%66%74%2e%72%75">http://rhcosnjpscdn.%73%70%65%63%69%61%6c%72%65%70%67%69%66%74%2e%72%75</a></p> pitrtools - Feature #5306 (Feedback): Reimplementation of queuehttps://public.commandprompt.com/issues/53062014-05-13T12:58:27ZJoshua A. Drakezam@commandprompt.com
<p>Reimplementation of PITRTools queue<br />The current queue system possesses the following limitations:<br />1. No job control - If we are generating xlogs faster than we can ship them, rsync processes will be spawned uncontrollably.<br />2. A continuous stream of transaction logs must be generated for correct operation of the archiver. If there are no new logs <br />coming in, logs still in the queues will not get shipped.</p>
<p>Suggested solution:<br /><pre>
Queue management daemon - Have cmd_archiver only queue logs, with a separate daemon shipping them.
* cmd_queue daemon
- write PID to a file
- In worker thread
] Ship logs in queue with subprocess calls when self to-do list is not empty
} If successful, remove paths from self to-do list and log appropriate output
} Else, log which queues failed
] Wait a few seconds [configurable]
] Repeat
- In main thread
] Wait for data [absolute paths to queued logs] on a pipe or UNIX socket
] On data, parse and extract paths, append paths to self to-do list
] Repeat
* When cmd_archiver is called with a new archive, copy the archive to slave queues and write paths to cmd_queue via pipe/socket
</pre></p> postgres_fdw - Bug #5303 (New): [SPAM] Good shoes good priceshttps://public.commandprompt.com/issues/53032014-05-11T09:24:00ZAlvherre -dntnmh@dng.vnn.vnpostgres_fdw - Bug #5292 (New): [SPAM] Good shoes good priceshttps://public.commandprompt.com/issues/52922014-04-11T14:06:06ZLadyregina -apei@cat-atelierduchateau.compitrtools - 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 #5255 (New): support TRUNCATE triggershttps://public.commandprompt.com/issues/52552011-05-21T16:29:20ZÁlvaro Herreraalvherre@commandprompt.com
<p>$SUBJECT</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> 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 #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> PL/php - Feature #4967 (In Progress): Redesign memory handlinghttps://public.commandprompt.com/issues/49672005-11-16T17:31:06ZÁlvaro Herreraalvherre@commandprompt.com
<p>Currently memory is not handled very well. It would be nice if we had one MemoryContext for each function that could be automatically reset or deleted when the function is recompiled. Additionally we would need a compilation context, and maybe an execution context as well.</p>