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 post
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 wrote:
>
> I have an old production instance, let's call it A, that I need to
> decommission soon.
>
> I've created a pair of new instances, B
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 wrote:
>
> Is there a way to specify a wild c
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 wou
On Fri, May 22, 2015 at 10:02 AM, Tom Lane wrote:
> Alban Hertroys writes:
> > On 22 May 2015 at 04:46, Bill Moran wrote:
> >> With all that being said, if I were to build a patch, would it be likely
> >> to be accepted into core?
>
>
How feasible would it be to write a network proxy, like pg_b
correct?
> On May 15, 2015, at 8:07 AM, Dennis wrote:
>
> On node1:
>
> apimgtdb=# SELECT * FROM bdr.bdr_nodes
> apimgtdb-# ;
> node_sysid | node_timeline | node_dboid | node_status | node_name |
>
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 wrote:
>
> On 16 April 2015 at 23:58, Dennis wrote:
>&
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
on, Apr 13, 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
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
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
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)
n
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 wrote:
>
> I have removed a node from a three node bdr cluster using
> bdr.bdr_part_by_node_names() howeve
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 wrote:
> On Thu, Oct 9, 2014 at 3:52 AM, pinker wrote:
> Hello All,
> I have a brand new machi
, 2014, at 1:18 PM, Adrian Klaver 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
>
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 compl
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:
>
> ./scri
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 once
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 Jos
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 -c"select
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 wrote:
>
> On Fri, Jul 5, 2013 at 8:58 AM, Stuart Ford wrote:
>
>> On Fri, Jul 5, 2013 at 7:00 AM, Dennis Jenkin
On Fri, Jul 5, 2013 at 8:58 AM, Stuart Ford wrote:
> 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 a
On Fri, Jul 5, 2013 at 7:00 AM, Stuart Ford wrote:
> 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 - http://pastebin.com/YdWSmNUp
>
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.
Th
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
lan text dump. I don't have huge databases yet, 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."
_
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."
ql -d 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 t
On Thu, Apr 26, 2012 at 1:59 PM, Kenneth Tilton wrote:
> On Thu, Apr 26, 2012 at 2:24 PM, Tom Lane 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 the map, and it works fine
On Tue, Mar 20, 2012 at 8:27 PM, Jeff Davis 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 practice you ne
On Fri, Mar 16, 2012 at 2:20 PM, Aleksey Tsalolikhin
wrote:
> On Thu, Mar 15, 2012 at 6:43 AM, Aleksey Tsalolikhin
> 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 or 10 hours this time.
>
Aleksey, a sugges
On Thu, Mar 15, 2012 at 4:12 PM, Jeff Davis 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 time id
>> 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
> com
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 rates
On Wed, Mar 7, 2012 at 6:34 AM, David Johnston 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 track by'
On Tue, Mar 6, 2012 at 10:11 AM, Thom Brown wrote:
> On 6 March 2012 16:04, Adrian Klaver 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.
>> Any way search for postmaste
On Wed, Feb 29, 2012 at 8:54 AM, Adam Bruss 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
> registry branch fo
On Tue, Feb 28, 2012 at 8:48 AM, Adam Bruss 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 would mean
> the II
On Wed, Feb 15, 2012 at 9:18 AM, Tom Lane wrote:
> Magnus Hagander writes:
>> On Wed, Feb 15, 2012 at 06:40, dennis jenkins
>> wrote:
>>> I recently updated my Gentoo Linux development system from postgresql
>>> 9.0.4 to 9.0.6-r1 (9.0.6 plus some Gentoo spe
djenkins@ostara ~/code/capybara $ psql -U$someuser -dpostgres -c
"select version();"
version
--
PostgreSQL 9.
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
en
We are using PostgreSQL 9.1, but the aggregate should also run on 8.4 at
the end.
Best Regards,
Dennis
: 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 c
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
On Thu, Sep 29, 2011 at 12:08 PM, dennis jenkins <
dennis.jenkins...@gmail.com> wrote:
>
> (root@failed: ) # psql -Upgsql -dmy_db -c"create or replace function
> parse_micr(text) returns micr_struct
> as '/db/pgsql_micr_parser_64.so', 'pgsql_micr_parser&#
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 che
On Tue, Jul 19, 2011 at 5:41 AM, Antonio Vieiro wrote:
> 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
> double-check it. I was wo
On Tue, Jun 28, 2011 at 8:43 AM, Merlin Moncure 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 is true and I c
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: pgsql-general@p
On Sun, Apr 24, 2011 at 4:16 PM, Tom Lane wrote:
> Phil Couling 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 from a database built with a
On Wed, Mar 23, 2011 at 5:08 AM, Adrian Schreyer 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();
> }
>
>
> 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
On Thu, Feb 10, 2011 at 1:02 PM, Scott Ribe 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 a query to
> find such v
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 p
On Fri, Jan 28, 2011 at 1:19 PM, dennis jenkins
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-postgres
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 "-
st tested, theory based
practices. They just 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 mis
On Wed, Jan 5, 2011 at 1:03 PM, Bill Moran 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 themselves
> with isn
arehousing/map reducing arena 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
, 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
Si
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
ef-498e87a3e4b3
fa597e9c-ae35-461e-b15f-498e87a3e4b7
f3c46abf-a6b0-4c9c-b22d-498e87a3e4bb
fc868307-d1b1-4253-91d7-498e87a3e4bf
b79679a9-4359-42a1-bf46-498e87a3e4c3
d91bf8cb-e3be-4446-be73-498e87a3e4c7
bec9e0a1-cd85-4f0c-b35b-498e87a3e4cc
0e0ea724-e145-4932-b0df-498e87a3e4d0
30ab3e05-26e3-44af-a82f-498e87a3
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
To: r...@iol.ie
Cc: Elliot Chance , pgsql-general@postgresql.org
Subject: Re: The first dedicated PostgreSQL forum
Message-ID
NULL;
END;
' LANGUAGE plpgsql;
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
r,
(Love postgres 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 alwa
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 '
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 wrote:
> From: Craig Rin
KUDOS, I 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.
ions and billlions' of records, Mwah Ha Ha
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 wrote:
> From: Craig Ringer
&g
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
mal title' at
query time.
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 'Ho
On Fri, Aug 13, 2010 at 10:56 AM, Joshua D. Drake
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 exactly the sit
es withi postgres to them.
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)
T
collation, 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
-
That was it exactly as I just tested the entire process and it all worked
fine again. For some reason, I inadvertently replaced the "-Fc" part with a
"-c" somewhere along the way. Thanks again!
On Fri, Jun 25, 2010 at 5:18 PM, Adrian Klaver wrote:
> On Friday 25 June 2
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 wrote:
> On 06/25/2010 09:04 AM, Dennis C w
M, Thom Brown wrote:
> On 25 June 2010 16:28, Dennis C 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 t
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
./Trading-Acce
On Fri, Jun 25, 2010 at 6:58 AM, Scott Marlowe wrote:
>
> Biggest difference between MySQL and PostgreSQL? The developers.
>
>
I like that... It has a nice ring to it.
for the geographical 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
> wrote:
> >
> > I've got an application brewing that gathers the
> following data:
> > locati
timestamp
>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.yer
ing of SQL injection, anyone seen this site?
http://sqlmap.sourceforge.net/demo.html
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, 5/30/10, Tom Lane wrot
e for bulk 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
--
Se
d
statement(to avoid SQL injection), 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 Crowde
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,
otherw
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'
Lau
On Thu, May 20, 2010 at 7:49 AM, Hernan Danielan
wrote:
> 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 thing
> because with fi
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
class where relkind IN IN (‘r’, ‘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 lis
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 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 support, but
> > th
On Wed, Mar 10, 2010 at 10:55 AM, Ben Chobot 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 investigated this further).
one table at a time, it works just
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
Mon, Nov 30, 2009 at 9:02 PM, Dennis Gearon
Dennis Gearon
Merlin Moncure 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 will wait
for the ot
?
Thanks in advance. 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 (pg
cally 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 Bolivia
1 - 100 of 377 matches
Mail list logo
