Wow, thanks for all the feedback. The question about whether a superuser could
do something like this came up at the office today in the context of security
issues and handing out superuser to the application users (not necessarily to
the accounts/roles that would be used from the applications
Is it possible to execute command in on system the is hosting postgresql
remotely using psql or other mechanism? I know I can use \! in psql but that
executes the commands on the host where I am running psql from. Also, is it
possible for a postgres login/user to stop or restart a running
of A and load that logical dump into B which would then replicate the data to C.
Dennis
> On Dec 2, 2015, at 7:24 PM, Florin Andrei <flo...@andrei.myip.org> wrote:
>
> I have an old production instance, let's call it A, that I need to
> decommission soon.
>
> I've created a
Is there a way to specify a wild card in a json path?
For example I have the following json doc:
[ {“a”:1,”b”: [ { “x”: 7,”y”:8,”z”:9} ] }, {“a”:2,”b”: [ { “x”: 4,”y”:5,”z”:6}
] }, … ]
How do I write a select clause that can return the values for all b x values
something like [{b:x}] that
jsd;
Note: In my real world problem I have WHERE clause in the CTW statement using
the @> operator so the CTE can be more selective against the entire set of
jsonb doc’s in the containing table.
>
> On Nov 23, 2015, at 10:39 PM, Dennis <denn...@visi.com> wrote:
>
> Is there a wa
On Fri, May 22, 2015 at 10:02 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Alban Hertroys haram...@gmail.com writes:
On 22 May 2015 at 04:46, Bill Moran wmo...@potentialtech.com wrote:
With all that being said, if I were to build a patch, would it be likely
to be accepted into core?
How
. Is that correct?
On May 15, 2015, at 8:07 AM, Dennis denn...@visi.com wrote:
On node1:
apimgtdb=# SELECT * FROM bdr.bdr_nodes
apimgtdb-# ;
node_sysid | node_timeline | node_dboid | node_status | node_name |
node_local_dsn
On node1:
apimgtdb=# SELECT * FROM bdr.bdr_nodes
apimgtdb-# ;
node_sysid | node_timeline | node_dboid | node_status | node_name |
node_local_dsn
| node_init_from_dsn
Hello,
I am trying to setup table level replication with BDR 0.9.0 but I am running
into some errors. I believe I must be missing a step or two in the process.
I currently have a two node group that I want to build.
1) On node1 I have a database built with the tables I want to replicate;
node, and figure
out a way to send that status back to the VIP manager in a way it can act on
it.
Any suggestions on how to accomplish that would be appreciated.
Dennis
On Apr 20, 2015, at 7:25 AM, Craig Ringer cr...@2ndquadrant.com wrote:
On 16 April 2015 at 23:58, Dennis denn...@visi.com
I need some clarification on how to monitor BDR nodes. In particular
determining replication lag. As an example, I have a two node cluster with
nodes ‘A’ and ‘B’.I need to be able to look at node ‘B’ and determine if it
is lagging behind node ‘A’, by interrogating node ‘B’ only.
From
Apologies for the typo of your name in my last post, Tom.
On Mon, Apr 13, 2015 at 12:16 PM, Dennis Jenkins
dennis.jenkins...@gmail.com wrote:
Doh. I found my answer. Tome posted it years ago..
http://www.postgresql.org/message-id/18994.1325874...@sss.pgh.pa.us
I have to connect
, 2015 at 12:05 PM, Dennis Jenkins
dennis.jenkins...@gmail.com wrote:
I am attempting to remove a role from Postgresql-9.3.6. I've already
reassigned ownership for the role's tables, functions, sequences, types,
views, etc... However, I am still unable to remove the role. Postgresql
reports
I am attempting to remove a role from Postgresql-9.3.6. I've already
reassigned ownership for the role's tables, functions, sequences, types,
views, etc... However, I am still unable to remove the role. Postgresql
reports that 8 objects in the database 'postgres' depend on this role.
How do I
Can a server instance that has a db in one existing bdr group add that same db
to a different/new bdr group so that the db belongs to two different bdr groups
at the same time?
e.g.
node 1, db_x, bdr_group (node 1, node 2)
node 2, db_x, bdr_group (node 1, node 2) AND bdr_group(node 2, node 3)
I need to make a correct to the status of the removed node. The removed node’s
status is ‘k’ not ‘r’ in the bdr.bdr_nodes table.
On Apr 8, 2015, at 10:05 AM, Dennis denn...@visi.com wrote:
I have removed a node from a three node bdr cluster using
bdr.bdr_part_by_node_names() however I am
I have removed a node from a three node bdr cluster using
bdr.bdr_part_by_node_names() however I am still seeing the removed node in the
bdr.bdr_nodes table (it’s status is ‘r’.) Will the removed node entry in the
bdr.bdr_nodes table be automatically removed eventually or should I delete the
Hi, a little off the general topic but I am just wondering if the “tar -cf -
pgdata | wc -c” trick can be used as general trick to pre-warm the cache?
Thanks.
On Oct 9, 2014, at 10:55 AM, Jeff Janes jeff.ja...@gmail.com wrote:
On Thu, Oct 9, 2014 at 3:52 AM, pinker pin...@onet.eu wrote:
Hi, I am having bad luck with a query that should return zero rows but actually
never returns (completes execution.)
When I broaden the ‘between’ clause range from period.orderno between 1447
and 1450 to period.orderno between 1446 and 1450” the query plan changes and
the query never
adrian.kla...@aklaver.com wrote:
On 08/27/2014 11:02 AM, Dennis wrote:
Hi, I am having bad luck with a query that should return zero rows but
actually never returns (completes execution.)
And the query is :) ?
--
Adrian Klaver
adrian.kla...@aklaver.com
On Fri, Jul 18, 2014 at 10:16 AM, Andrew Pennebaker
andrew.penneba...@gmail.com wrote:
Could we please have the PostgreSQL lexer treat #!... on the first line of
a file as a comment? This would enable .psql scripts to be run with
dot-slash notation preferred by many unix users:
I having trouble with correct syntax to get this trigger function to compile.
I have tried every combination of removing the ‘;’ characters but the function
will not compile. Can someone tell me what I am doing wrong, I am stumped. I
will be adding addition when clauses the case statement
What does the shell command: pwd show when run immediately after you issue
a su postgres command?
You may want to try su - postgres to ensure you are in the postgres users
home directory.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of
1)
Run both psql and perl under strace and search the output for which
sockets it connects to.
eg, strace -o /tmp/psql.log psql -Upgsql -dmydatabase -cselect
version();
2)
Add a query into your perl script to perform the following SQL and print
the results:
select current_database();
tcpdump and/or wireshark will help with detecting network issues.
Wireshark is a little easier to grok if you are not used to doing packet
dumps. http://www.wireshark.org/
Dennis
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jayadevan M
Stuart,
I'm simply curious - did you resolve your issue? What NAS
(vendor/model/config) are you using?
On Fri, Jul 5, 2013 at 11:31 AM, Dennis Jenkins dennis.jenkins...@gmail.com
wrote:
On Fri, Jul 5, 2013 at 8:58 AM, Stuart Ford stuart.f...@glide.uk.comwrote:
On Fri, Jul 5, 2013 at 7
On Fri, Jul 5, 2013 at 7:00 AM, Stuart Ford stuart.f...@glide.uk.comwrote:
Dear community
Twice today our PG 9.1 server has caused a soft lockup, with a kernel
message like this:
[1813775.496127] BUG: soft lockup - CPU#3 stuck for 73s! [postgres:18723]
Full dmesg output -
On Fri, Jul 5, 2013 at 8:58 AM, Stuart Ford stuart.f...@glide.uk.comwrote:
On Fri, Jul 5, 2013 at 7:00 AM, Dennis Jenkins wrpte
No. iSCSI traffic between the VMWare hosts and the SAN uses completely
separate NICs and different switches to the production LAN.
I've had a look at the task
, so to make it easier to
go
between versions, I use a text backup.
Hope that answers your questions.
Dennis Gearon
Never, ever approach a computer saying or even thinking I will just do this
quickly.
From: Adrian Klaver adrian.kla...@gmail.com
To: Dennis
Not needed if you are logged in as user postgres in your OS when you enter
psql.
At least, with the hba_conf file the way it is stock.
But a good point, though. I wonder if I would then have to know the DATABASE
password for postgres if I wasn't user postgres in the OS?
Dennis Gearon
Never
The only thing that I can offer is that it works from inside psql as user
postgre but NOT from invoking postgres using -f filename from the commas line
as user postgre. I have to admit that I did not use -U as OS user postgres, but
that shouldn't be necessary with a stock gnarled_conf file.
database_name
-f the_file.sql
I get errors on \N and various other problems. I've tried dividing the file up
into:
table creation
one 'copy' of a table at a time.
One, a 35 mbyte seems to have errors on semi colons.
Dennis Gearon
Never, ever approach a computer saying or even thinking I will just
It turns out that I had made the export from psql, a text based export.
So I read that it was actually needing to be imported using '\i
filename_in_local_directory'
Dennis Gearon
Never, ever approach a computer saying or even thinking I will just do this
quickly.
On Thu, Apr 26, 2012 at 1:59 PM, Kenneth Tilton ktil...@mcna.net wrote:
On Thu, Apr 26, 2012 at 2:24 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Can you produce a self-contained test case?
I doubt it. Every test iteration I run includes a lot of redefining of
functions and triggers all over
On Tue, Mar 20, 2012 at 8:27 PM, Jeff Davis pg...@j-davis.com wrote:
On Tue, 2012-03-20 at 22:21 +0100, Henk Bronk wrote:
actually rsync works fine on file level and is good for manual syncing.
it check really the files with the stat command, so a bit change will
trigger the copy
in
On Fri, Mar 16, 2012 at 2:20 PM, Aleksey Tsalolikhin
atsaloli.t...@gmail.com wrote:
On Thu, Mar 15, 2012 at 6:43 AM, Aleksey Tsalolikhin
atsaloli.t...@gmail.com wrote:
Our database is about 200 GB - over a WAN link, last time it took 8
hours to do a full sync, I expect it'll be
more like 9
On Thu, Mar 15, 2012 at 4:12 PM, Jeff Davis pg...@j-davis.com wrote:
On Fri, 2012-03-16 at 01:57 +0530, alexander.bager...@cognizant.com
wrote:
Hi,
We are looking to use Postgres 9 for the document storing and would
like to take advantage of the full text search capabilities. We have
hard
I've also looked at the Fusion-IO products. They are not standard
flash drives. They don't appear as SATA devices. They contains an
FPGA that maps the flash directly to the PCI bus. The kernel-mode
drivers blits data to/from them via DMA, not a SATA or SAS drive (that
would limit transfer
Now I have the burden to look for a cool project... Any ideas?
-Stefan
How about one of:
1) on disk page level compression (maybe with LZF or snappy) (maybe not page
level, any level really)
I know toast compresses, but I believe its only one row. page level would
compress better
On Wed, Mar 7, 2012 at 6:34 AM, David Johnston pol...@yahoo.com wrote:
I know there is currently work ongoing regarding normalizing SQL statements
for logging purposes but has anyone considered given us the ability to name
our statements.
SELECT
FROM ...
WHERE
NAMEAS 'Name to
On Tue, Mar 6, 2012 at 10:11 AM, Thom Brown t...@linux.com wrote:
On 6 March 2012 16:04, Adrian Klaver adrian.kla...@gmail.com wrote:
The postmaster.pid is located outside the data directory, but points back to
the
data directory. Not sure where Debian, though at a guess somewhere in /var.
On Wed, Feb 29, 2012 at 8:54 AM, Adam Bruss abr...@awrcorp.com wrote:
I ran process explorer and looked at the handles for the System process. The
vast majority of the handles are of type Key. I can find them in the
registry. I took two at random from process explorer and exported the
On Tue, Feb 28, 2012 at 8:48 AM, Adam Bruss abr...@awrcorp.com wrote:
The handles persist through restarting the postgresql service and restarting
the IIS server. The handles are accumulating on the System process. I think
the handles are created when the web service is accessed but that
On Wed, Feb 15, 2012 at 9:18 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Magnus Hagander mag...@hagander.net writes:
On Wed, Feb 15, 2012 at 06:40, dennis jenkins
dennis.jenkins...@gmail.com wrote:
I recently updated my Gentoo Linux development system from postgresql
9.0.4 to 9.0.6-r1 (9.0.6 plus
djenkins@ostara ~/code/capybara $ psql -U$someuser -dpostgres -c
select version();
version
--
PostgreSQL
I am wondering what the best way is to force character data to a specific
case, like upper case for example. Is a trigger or rule the only option?
Would a check constraint be better or faster than using rules or triggers,
knowing that a check constraint puts the onus back on the client code to
also run on 8.4 at
the end.
Best Regards,
Dennis
Is there a way to list the installed pl languages for a database and/or
server cluster?
thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
: Thursday, November 10, 2011 7:07 AM
To: Dennis Ryan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to list installed pl languages
On Wed, Nov 09, 2011 at 10:58:01PM -0600, Dennis Ryan wrote:
Is there a way to list the installed pl languages for a database
and/or server cluster?
\dL
On Thu, Sep 29, 2011 at 12:08 PM, dennis jenkins
dennis.jenkins...@gmail.com wrote:
(root@failed: /db) # psql -Upgsql -dmy_db -ccreate or replace function
parse_micr(text) returns micr_struct
as '/db/pgsql_micr_parser_64.so', 'pgsql_micr_parser' language c volatile
cost 1;
ERROR: could
Hello Postgresql Community Members,
I am stumped trying to install a few 'c' language functions
on a particular Solaris server (64-bit, amd cpu arch (not sparc)). I
actually
have 5 Postgresql servers, and the .so loads fine into 4 of them, but
refuses to load into the 5th. I've quintuple
On Tue, Jul 19, 2011 at 5:41 AM, Antonio Vieiro anto...@antonioshome.netwrote:
Hi all,
I'm building a small C application that uses libpq and I was wondering
if there's an easy way to detect memory leaks in my code.
I think I'm calling PQclear and friends correctly, but I'd like to
On Tue, Jun 28, 2011 at 8:43 AM, Merlin Moncure mmonc...@gmail.com wrote:
The rebuttal to the above points is that the problem with not quoting
is that your identifiers are folded to lower case on the server which
can make them difficult to read in psql, pgadmin, etc. when outputted.
This
Try using this, even on a windows system:
\i /psql/loaddata.sql
psql likes *nix path names
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sukuchha Shrestha
Sent: Friday, April 29, 2011 5:40 AM
To:
On Sun, Apr 24, 2011 at 4:16 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Phil Couling coul...@gmail.com writes:
I'm looking for a way to extract the data from a PostgreSQL 8.3.14
database (cluster) that was built using an an ARM/Linux server. The
...
Are there any tools for recovering data
On Wed, Mar 23, 2011 at 5:08 AM, Adrian Schreyer ams...@cam.ac.uk wrote:
you are right, it returns a char *.
The prototype:
char *function(bytea *b);
The actual C++ function looks roughly like this
extern C
char *function(bytea *b)
{
string ism;
[...]
return ism.c_str();
}
I'm working on a project to convert a large database form SQL_ASCII to
UTF-8. I am using this procedure:
1) pg_dump the SQL_ASCII database to an SQL text file.
2) Run through a small (efficient) C program that logs each line that
contains ANY unclean ASCII text.
3) Parse that log with a small
On Thu, Feb 10, 2011 at 1:02 PM, Scott Ribe scott_r...@elevated-dev.com wrote:
I know that I have at least one instance of a varchar that is not valid
UTF-8, imported from a source with errors (AMA CPT files, actually) before
PG's checking was as stringent as it is today. Can anybody suggest
If you are interested, I can email to you the C and Perl source.
It runs like this:
# time pg_restore /db-dumps/some_ascii_pgdump.bin | ./ascii-tester |
./bad-ascii-report.pl unclean-ascii.rpt
http://www.ecoligames.com/~djenkins/pgsql/
Disclaimer: I offer NO warranty. Use at your own
On Fri, Jan 28, 2011 at 1:19 PM, dennis jenkins
dennis.jenkins...@gmail.com wrote:
Hello Everyone,
My goal is to install a 64-bit build of the latest Postgresql 8.4
(not ready for 9.0 yet) onto a Solaris 10u9 server (Intel chips,
X4270), with dtrace support.
.../no-dtrace-postgresql
Hello Everyone,
My goal is to install a 64-bit build of the latest Postgresql 8.4
(not ready for 9.0 yet) onto a Solaris 10u9 server (Intel chips,
X4270), with dtrace support. Postgresql compiles just fine when
configured with --disable-dtrace. Attempting to compile when
configured with
make the tech world a better place with some of the most
reliable, best supported OSS out there.' And you guys and gals ARE that
description.
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better
idea to learn from
before I'd
consider THAT. And there's 'flavors' of Postgres that will do that, anyway.
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better
idea to learn from others’ mistakes, so you do not have to make them
On Wed, Jan 5, 2011 at 1:03 PM, Bill Moran wmo...@potentialtech.com wrote:
But the point (that you are trying to sidestep) is that the UUID namespace
is finite, so therefore you WILL hit a problem with conflicts at some point.
Just because that point is larger than most people have to concern
, but never explicitly
says that's how it's stored. Nor does it use one of the nice, blue headered
tables for UUID (or ENUM) showing storage and other attributes as it does for
numeric, character,boolean, date/time, binary, monetary, geometric, or network
types.
Dennis Gearon
Signature Warning
-498e87a3e4d4
/sample values
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better
idea to learn from others’ mistakes, so you do not have to make them yourself.
from 'http://blogs.techrepublic.com.com/security/?p=4501tag
Good catch! The article is:
http://www.informit.com/articles/printerfriendly.aspx?p=25862
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better
idea to learn from others’ mistakes, so you do not have to make them
that database types are conservative by nature, almost as much as
accountants. But a little change is good now and then ;-)
Dennis Gearon
From: Guillaume Lelarge guilla...@lelarge.info
To: r...@iol.ie
Cc: Elliot Chance elliotcha...@gmail.com, pgsql-general@postgresql.org
Subject: Re: The first
;
/from article
Wouldn't something like this need row-locking (SELECT for UPDATE) in order to
serialize the execution of all triggers?
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better idea to learn from others
otherwise). Is this still true?
Is there any architectural way to speed it up? I'd actually like to run it
every 2-60 seconds to update a counter on a page for the marketing guy, (which
for once, is me :-)
Dennis Gearon
Signature Warning
It is always a good idea to learn
by GCC gcc-4.4.real (Ubuntu
4.4.3-4ubuntu5) 4.4.3, 64-bit
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better idea to learn from others’ mistakes, so you do not have to make them
yourself. from 'http
almost never need to write the postgres group . . . because it just
works. It's only using postgres that I ever even read the digest that I
receive.
Soon I will have to write more to get performance tips. You guys are great on
this list and seem to always have answers, Thx.
Dennis Gearon
Thanks for the start. I'll start on it.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--- On Tue, 10/5/10, Craig Ringer cr...@postnewspapers.com.au wrote:
From: Craig
, Mwah Ha Ha evil grin
accompaniment /
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--- On Sun, 9/12/10, Craig Ringer cr...@postnewspapers.com.au wrote:
From: Craig Ringer
I'm trying to import from a postgres database (which will work in parallel) to
a ElasticSearch databse (JSON input).
Is there anyway to get JSON output from postgres?
(googled, found only 'planner' output does this)
Dennis Gearon
Signature Warning
EARTH has a Right To Life
.
Would this be very expensive processor timewise?
I might just feed the whole long title in and have the display properties of
the browser truncate it.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http
On Fri, Aug 13, 2010 at 10:56 AM, Joshua D. Drake j...@commandprompt.com
wrote:
On Fri, 2010-08-13 at 11:38 -0400, Tom Lane wrote:
I don't really see that. The case where it's sensible to use
compression on the connection is where you're pushing data across
a WAN. That's also pretty much
.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
Dennis Gearon
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
, and then put any language that I want in it. Then make different
indexes using differnt collations. So when I get a user's locality and
langauge, I search for the closest index, and specifiy it when doing text based
searches.
Is this possible?
Dennis Gearon
Signature Warning
EARTH has
:59:17 pm Dennis C wrote:
OK well the gunzip seemed to do the trick, but I don't recall before
having to do anything other than run the pg_restore command. Anyway,
thanks to everyone for all your help!
My guess is that previously the dump command was actually:
/opt/local/lib/postgresql84
On Fri, Jun 25, 2010 at 6:58 AM, Scott Marlowe scott.marl...@gmail.comwrote:
Biggest difference between MySQL and PostgreSQL? The developers.
I like that... It has a nice ring to it.
Greetings;
As I've been doing for quite some time, backed up my database as
such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5
Trading-Access
But then when I tried restoring it my usual way as
such: /opt/local/lib/postgresql84/bin/pg_restore -d Trading-Access
...@gmail.com wrote:
On 25 June 2010 16:28, Dennis C dcsw...@gmail.com wrote:
Greetings;
As I've been doing for quite some time, backed up my database as
such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5
Trading-Access
But then when I tried restoring it my usual way
OK well the gunzip seemed to do the trick, but I don't recall before
having to do anything other than run the pg_restore command. Anyway, thanks
to everyone for all your help!
On Fri, Jun 25, 2010 at 11:29 AM, Adrian Klaver adrian.kla...@gmail.comwrote:
On 06/25/2010 09:04 AM, Dennis C wrote
location of the datum.
But the process you described went one further than I knew, the output in the
local tz. Thanks for that.
Dennis Gearon gear...@sbcglobal.net
wrote:
I've got an application brewing that gathers the
following data:
location (lat/lon)
time (no time zone)
date
with timezone (i.e. it's stored in absolute time (in seconds) relative to GMT)
Any easier way to do this?
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--
Sent via pgsql-general
), transaction without shuttling any
information back and forth between the database and the calling script?
Thanks in advance.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
purposes, to be input via the
command line, is Postgres vulnerable to SQL injection from that?
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--
Sent via pgsql-general
is there anyway with a running instance of postgres to find out if it was
compiled with:
BIGINT
vs
DOUBLE PRECISION
timestamps?
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http
for those walking up to a new server and who want to know the same information:
shell script invoked by:
script_filename database user
#!/bin/sh
psql -c show INTEGER_DATETIMES; -d $1 -U $2 -W
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die
On Thu, May 20, 2010 at 7:49 AM, Hernan Danielan
hernandanie...@gmail.comwrote:
The server and the client are running in the same machine.That is why a
network connection problem is almost imposible. I do not know if i am doing
something wrong, my code is in my fist message. It is a extrange
’, ‘v’, ‘S’);
and that doesn't work either.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Yep bad scraping from one site to another. Probably encoding.
Thanks for telling me what (should) have been obvious about the two INs. The
gobbledy gook was bad encoding between the two web pages.
select
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise
On Wed, May 12, 2010 at 11:33 AM, Richard Broersma
richard.broer...@gmail.com wrote:
On Wed, May 12, 2010 at 9:18 AM, Justin Graf jus...@magwerks.com wrote:
I would do a plain text file something like XML. Given this is for
industrial use 10 years is a good number for warranty and
On Wed, Mar 10, 2010 at 10:55 AM, Ben Chobot be...@silentmedia.com wrote:
On Mar 10, 2010, at 12:15 AM, Stuart Bishop wrote:
syslog doesn't give you easily machine readable output. I'm not sure how
syslog implementations handle high load (our sysadmins won't use it, so I
haven't
fine. Is this a known issue, feature, or I am doing something wrong? I thought
that doing a database recovery using a copy version of a dump would be a no
brainer, it would happen all in one transaction?
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we
at 9:02 PM, Dennis Gearon gear...@sbcglobal.net
Dennis Gearon
Merlin Moncure mmonc...@gmail.com wrote:
Just make sure that when you inspect the record, do so: a. in a
transaction (preferably a brief one) and b. WITH UPDATE until your
operation completes. That way if two operations collide one
. I RTFMed and Googled, but did not see the answer.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
empty.
no other fancy stuff like functions/views/installed languages/blah,blah
running on Ubuntu latptop
I don't know if I have log files set up or where they'd be.
Dennis Gearon
Signature Warning
EARTH has a Right To Life
I agree with Bolivian President Evo
On Tue, Sep 15, 2009 at 3:03 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Sep 15, 2009 at 1:49 PM, John R Pierce pie...@hogranch.com wrote:
std pik wrote:
Hello all..
I'm using PostgreSQL 8.3..
How can I get information about the hardware utilization:
- CPU usage.
-
1 - 100 of 366 matches
Mail list logo
