Most of the installations I have seen reach out to the Internet during the
process. How hard is it to build a Postgres installation in a completely
isolated environment? I have an internal network with not Internet
connectivity that I would like to set up Postgres on.
Joey
Wow, thank-you (sometimes the answer is right there in front of you... very
new to Postgres, had wondered what the difference was between the run query
and run as PGS script, but hadn't looked into it yet).
So, here's the critical question(s) right now (for me)...
With the way I launched it,
console =)
Cheers,
RĂ©mi-C
2013/11/27 Albe Laurenz laurenz.a...@wien.gv.at
John R Pierce wrote:
On 11/26/2013 9:24 AM, Joey Quinn wrote:
When I ran that command (select * from pg_stat_activity), it returned
the first six lines of the scripts. I'm fairly sure it has gotten a
bit beyond
-C
2013/11/27 Joey Quinn bjquinn...@gmail.com
Wow, thank-you (sometimes the answer is right there in front of you...
very new to Postgres, had wondered what the difference was between the run
query and run as PGS script, but hadn't looked into it yet).
So, here's the critical question(s
In this case, I'm updating one column. Wouldn't the swap part of that
still have to be an update?
On Wed, Nov 27, 2013 at 9:50 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Wed, Nov 27, 2013 at 8:35 AM, Joey Quinn bjquinn...@gmail.com wrote:
So, no cancel... keeping my fingers crossed
I have a fairly large table (4.3 billion rows) that I am running an update
script on (a bit over 127 thousand individual update queries). I am using
the gui. It has been running for about 24 hours now. Is there any good way
to gauge progress (as in, how many of the individual update queries have
Joey Quinn bjquinn...@gmail.com
I have a fairly large table (4.3 billion rows) that I am running an
update script on (a bit over 127 thousand individual update queries). I am
using the gui. It has been running for about 24 hours now. Is there any
good way to gauge progress (as in, how many
, 2013 at 10:28 AM, Joey Quinn bjquinn...@gmail.com wrote:
I have a fairly large table (4.3 billion rows) that I am running an
update script on (a bit over 127 thousand individual update queries). I am
using the gui. It has been running for about 24 hours now. Is there any
good way to gauge
The ipv4 column is of type inet. It is the primary key (btree access) and
access times for queries on individual ip addresses have been around 10-15
ms.
On Tue, Nov 26, 2013 at 12:13 PM, Vick Khera vi...@khera.org wrote:
On Tue, Nov 26, 2013 at 12:11 PM, Joey Quinn bjquinn...@gmail.com wrote
Pierce pie...@hogranch.com wrote:
On 11/26/2013 9:24 AM, Joey Quinn wrote:
When I ran that command (select * from pg_stat_activity), it returned
the first six lines of the scripts. I'm fairly sure it has gotten a bit
beyond that (been running over 24 hours now, and the size has increased
count on the county field... hate to throw queries at it while it's
busy updating though...
On Tue, Nov 26, 2013 at 1:43 PM, Vick Khera vi...@khera.org wrote:
On Tue, Nov 26, 2013 at 12:24 PM, Joey Quinn bjquinn...@gmail.com wrote:
When I ran that command (select * from pg_stat_activity
nope, that appears to be being blocked by the updates...
tried select * from ipv4_table where country='gb' limit 1;
it just sat there...
On Tue, Nov 26, 2013 at 3:00 PM, Vick Khera vi...@khera.org wrote:
On Tue, Nov 26, 2013 at 2:48 PM, Joey Quinn bjquinn...@gmail.com wrote:
The ranges
yeah, unlikely that it is already in the path (I certainly didn't add it
yet).
Thanks for the command (new version).
On Tue, Nov 26, 2013 at 3:13 PM, John R Pierce pie...@hogranch.com wrote:
On 11/26/2013 11:45 AM, Joey Quinn wrote:
Would that command be from within the psql SQL Shell
yep, that worked... thanks again.
On Thu, Nov 21, 2013 at 4:38 PM, Joey Quinn bjquinn...@gmail.com wrote:
Ahhh, that's what I was missing... thank-you. (just launched, we'll see
how that one goes).
On Thu, Nov 21, 2013 at 3:48 PM, Elliot yields.falseh...@gmail.comwrote:
On 2013-11-21 15
I have a table (5 columns) with approximately 670 million rows. It has had
an index (unique) on an inet column from the beginning. Today I added a
primary key constraint based on the same column thinking that since it
already had an index, this would be a relatively quick operation. That does
not
Ahhh, that's what I was missing... thank-you. (just launched, we'll see how
that one goes).
On Thu, Nov 21, 2013 at 3:48 PM, Elliot yields.falseh...@gmail.com wrote:
On 2013-11-21 15:40, Joey Quinn wrote:
I have a table (5 columns) with approximately 670 million rows. It has
had an index
From the way the table was filled, I knew there were no nulls. It succeeded.
On Thu, Nov 21, 2013 at 8:15 PM, Joshua D. Drake j...@commandprompt.comwrote:
On 11/21/2013 12:40 PM, Joey Quinn wrote:
I have a table (5 columns) with approximately 670 million rows. It has
had an index (unique
I'm using 9.3 (Windows 64 bit) and would like to use an hstore field in new
table but it does not appear to be available. How do I add the correct
module?
Joey
Thank-you all... create extension hstore; was exactly what I needed (I'm
new to PostgreSQL and was unfamiliar with the terminology... was searching
unsuccessfully for things like install hstore module).
Joey
On Wed, Nov 20, 2013 at 4:12 PM, Joey Quinn bjquinn...@gmail.com wrote:
I'm using
19 matches
Mail list logo