reader.
near as I can tell, gmail ignores the threading headers, and just
threads based on subjects.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
the error results of a query executed via the standard libpq API.
If you are using a different API to access postgres, then you'd need to
look into that API's error return functions.
--
john r pierce, recycling bits in santa cruz
ar folders for the various
other email lists I'm on.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 3/24/2017 11:27 PM, John R Pierce wrote:
On 3/24/2017 9:49 PM, Yuri Budilov wrote:
Hello everyone
Can these forums be moved to internet ?
go ahead and start a forum. good luck.
sorry, that was a little terse. I tried to move a couple thriving
communities I'd created as email
On 3/24/2017 9:49 PM, Yuri Budilov wrote:
Hello everyone
Can these forums be moved to internet ?
go ahead and start a forum. good luck.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
.
how about piping the /output/ of pg_dump to GPG or a similar file/stream
encryption module ?
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
obviously
-- if not already done by pg_dump
ROLLBACK;
there is no way to get pg_dump to use the same connection as your
script its a standalone program, and will open its own connection,
hence run its own transactions.
--
john r pierce, recycling bits in santa cruz
, since update's are treated
as insert+delete, so the same blocks aren't written over and over nearly
as much as they might be in the oracle storage model.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
this. you can
restore to any transaction between when that basebackup was taken, and
the latest entry in the WAL archive, its referred in the documentation
as PITR, Point in Time Recovery.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general
PQputCopyData() in libpq, or similar in other APIs). you can use
\copy in psql to stream the data from the same input.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql
built so they avoid all the usual Linux library
compatibility issues? they have everything statically linked,,
including glibc and openssl and whatever?
--
john r pierce, recycling bits in santa cruz
d PG 9.6 under contract.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
N public.log AS ff ON ff.jobid = j.id <http://j.id>
WHERE j.clientid = 3369 AND ff.clientid = 3369
AND (ff.description LIKE '%change%')
ORDER BY gtime DESC
LIMIT 100
--
john r pierce, recycling bits in santa cruz
On 3/14/2017 12:31 PM, Lawrence Cohan wrote:
Subject:
Postgres backup solution
From:
Lawrence Cohan <lco...@web.com>
Date:
3/14/2017 12:31 PM
To:
"pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
was there supposed to be a question or statement or somethi
one-time port to an obscure platform which is at
best a historical oddity does no one any favors. if its not supported
and reasonably current, it might as well not exist.
--
john r pierce, recycling bits in santa cruz
jsonfield #>> '{path1,path2}')::numeric
--
john r pierce, recycling bits in santa cruz
reading from STDIN)this what psql uses for \COPY, you then read the
local CSV file and send it to the appropriate streaming interface, for
instance if you're using libpq, you'd use...
https://www.postgresql.org/docs/current/static/libpq-copy.html#LIBPQ-COPY-SEND
--
john r pierce, recycling
bandwidth to keep up with the core count? how fast are each of those
arm cores compared with the E5-2640v3 cores?
being an ARM, software support will likely lag, and you'll probably
find yourself having to do a lot of your own compiling of stuff beyond
the basic OS.
--
john r pierce, recycling
ng at
all. Windows, however, once it decides the first server isn't
responding will continue to use the next one that does reply.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
/slave cluster, you need to avoid the
'split brain' scenario where both servers think they are master because
they can't reach the other.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
details.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, that is reasonable.
the primary reason for the partitions is to make it easy to drop old
data by pruning a whole partition.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
('NOT IN') with generate_series.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e pgloader, but I don't know if that runs
on MS Windows, either. its very powerful for doing bulk imports from a
wide range of formats, and even allows data manipulation.
--
john r pierce, recycling bits in santa cruz
irely done
in host software.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 2/13/2017 11:03 PM, Nikolai Zhubr wrote:
Now I'd like to locate a CPU eater more precisely - supposedly there
is some issue with communication, that is why I don't want to mix in
anything else.
use iperf to test the network transport layer, without any postgres in
the loop?
--
john r
.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
choice,
and run it.first step would be to read the documentation.
http://www.pgpool.net/mediawiki/index.php/Documentation
https://pgbouncer.github.io/ (lower left side, multiple links)
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql
).
option? query editor window? what software are you talking about?
I'm using 1.22.1 version.
1.22.1 version? PostgreSQL versions currently supported are 9.2.x to
9.6.x
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
On 2/9/2017 9:16 PM, John R Pierce wrote:
that spike in your graph suggests you had 8000 concurrent SELECT
operations...
errr, 7000, still way too many.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
, and such global table operations. that spike in your graph
suggests you had 8000 concurrent SELECT operations going on, which is
likely way more than you have compute and IO resources to handle
efficiently.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql
ROLE. For example, being a member of a role
with CREATEDB privilege does not immediately grant the ability to
create databases, even if INHERIT is set; it would be necessary to
become that role via SET ROLE before creating a database.
--
john r pierce, recycling bits in santa cruz
is in how they are used. CREATE USER is exactly the
same as CREATE ROLE WITH LOGIN;
--
john r pierce, recycling bits in santa cruz
in groups.
--
john r pierce, recycling bits in santa cruz
/wiki/Database_normalization
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
whats going to happen in each case is futile.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
under all
circumstances and is not crashing the server at any moment? Looking
for some new strategies and ideas to come my way through this.
you would write test cases for all the functionality provided by this
extension, same as you'd test any other sort of API.
--
john r pierce, recy
it is thats taking 25 seconds.
--
john r pierce, recycling bits in santa cruz
allocation, and if thats not enough uses temporary files and multiple
passes.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to an app server, which has
the business logic and does the database connection and executes the
business logic specific queries.
--
john r pierce, recycling bits in santa cruz
.
--
john r pierce, recycling bits in santa cruz
as it only deals with files.
if its unix/linux, you can use iostat or sar to track all the disk I/O
over an interval of time.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
nside a transaction? was it the first thing done
in this transaction?when you got the error, did you rollback the
transaction and retry?once you've gotten an error in a transaction,
no further queries can be done until you rollback the transaction and
start a new one.
--
john r pierce, recycling bits in santa cruz
too much in
the application and not enough in the database
I also add an index to my query and my query's execution plan don't
use seq scan .
that has no bearing on the above problems.
--
john r pierce, recycling bits in santa cruz
if you
want a specific order, use ORDER BY in your query.
--
john r pierce, recycling bits in santa cruz
ror logged...
psql:companies.sql:1: ERROR: syntax error at or near "Spray"
LINE 1: INSERT INTO companies VALUES (AG Spray Inc.,,PO Box 12129,Sa...
note no list of fields.note no PK value. AND no quotes around the
values.
--
john r pierce, recycling bits in santa cruz
are.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the
'active' partition set, and add it to the 'archive' partition set.
voila, no inserts, deletes, or updates are done at all, just some
metadata operations.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
of these other sessions shared temporary tables? all very confusing.
so I'm still not clear here what it is you expect these 'global temp
tables' to do, and how they are supposed to behave?
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql
rather than a sql database. perhaps the
wiki/blog articles are stored in a sql database, but thats an
implementation detail.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
, and are automatically deleted when the transaction
or session terminates.
how do these 'general temporary tables' differ from regular tables that
you create on demand, then delete when you're done with them?
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql
On 1/11/2017 12:49 AM, Guyren Howe wrote:
would prevent an SQL injection from wrecking havoc.
sql injection is quite easy to avoid. always make parameterized
queries, never use client supplied data to assemble a query with string
concatenation.
voila, no injection possible.
--
john r
solutions to this.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
be vacuumed frequently
enough so the tuples can continue to be updated in the same block.
--
john r pierce, recycling bits in santa cruz
On 1/9/2017 11:05 PM, Guyren Howe wrote:
I’m trying to see how a typical web developer might use Postgres’
roles and row-level security to implement their authorization.
too much impedance mismatch with the stateless nature of http
--
john r pierce, recycling bits in santa cruz
--
Sent
as the volume is mounted,
the data is visible as the encryption keys are loaded at boot or mount
time. the only threat model FDE protects against is physical theft of
the server.
--
john r pierce, recycling bits in santa cruz
, including LD_LIBRARY_PATH gets dropped by su,
which is used to launch the postgres service.
but generally, using LD_LIBRARY_PATH is frowned on, instead, you should
link the applications with -R, or -Wl,-rpath and give it the path of the
libraries, so thats baked into the binary.
--
john r
On 12/20/2016 4:41 PM, James Zhou wrote:
- PostgreSQL 9.6.1 only supports a subset of unicode characters in
BMP. Is there any documents defining which subset is fully supported?
I believve its support is based on what the OS native runtime libraries
support.
--
john r pierce, recycling
On 12/15/2016 2:16 PM, Richard Brosnahan wrote:
gdb is not available on this machine. Neither which or locate could
find it. The servers we're given are truly, shockingly, stripped down
models.
what OS is this, what compiler toolchain did you use to build postgres
on them?
--
john r
that you set to '' or something
when its empty.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 12/13/2016 12:24 PM, Joshua D. Drake wrote:
Tryton is an ERP that has CRM functionality. Although it is a bit of a
beast.
indeed, most any ERP is pretty much a kitchen sink, trying to be all
things.AR/AP/PR/PO/Inventory/etc/etc/etc.
--
john r pierce, recycling bits in santa cruz
Management System).
--
john r pierce, recycling bits in santa cruz
tes), then do the pg_upgrade directly to 9.6.1
now, there could be application compatibility issues going from 9.0 to
9.6, those would best be addressed by 9.1.0, 9.2.0, ... release notes as
9.6 will include all those functional changes.
--
john r pierce, recycling bits in santa cruz
--
S
-boolean.html
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
PostgreSQL 9.5.0.1
Why 9.5.0 and not 9.5.5, which has a LOT of bug fixes ?
not saying thats your problem here, it sounds more like sequencing as
per Adrian's reply...
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ait_event.
How do I correct this?
are you running some sort of monitoring software thats periodically
looking at pg_stat_activity ? whatever query its doing needs to be
rewritten to take into account the pg_stat_activity changes in 9.6
--
john r pierce, recycling bits in santa cruz
Sheets; Web Data Connector
--
john r pierce, recycling bits in santa cruz
, for that you'd
normally have application software, or use ETL tools to bulk load data
from other sources, etc.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
ot of data to marshal
and process.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
if you're starting with an empty
table, don't create ANY indexes til AFTER you populate the table with
data, and before doing the CREATE INDEX, make sure
'maintenance_work_mem' is like 1GB.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgs
FROM stdin; then the psql client reads your file and pipes it to
that COPY command, so the file is read by the client, and not the server.
--
john r pierce, recycling bits in santa cruz
the
aggressiveness of autovacuum if you hope to keep up with that number of
stale tuples distributed among millions of records.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
CC
a SQL database may not really be the best way to do what you're
doing.an array of your 500 rows, updated in memory, with updates
logged to a transaction file and the whole array periodically written to
disk, would very likely be MUCH higher performance..
--
john r pierce, recycling bits in
compress well or not as
that may save some storage space at the cost of compress/decompress on
accesses.
pretty sure most all PDF's are already compressed, and won't compress
much further.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general
for storing arbitrary binary objects
that are called BLOB in certain other databases.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in the database is those db
backups become way huger if there's a lot of this file data.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/repoview/pgaudit_95.html
--
john r pierce, recycling bits in santa cruz
could find pgbench:
its a command line program. at CMD ('dos prompt'), try...
D:\Postgresql\9.5\bin\pgbench --help
(replace that path with wherever you installed the eDB postgres package)
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql
rollups
per hour, per day, per month could mean the difference between a billion
row seq scan that takes hours and a few second query to graph a given
time range.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
cluster.
look at the postgresql.conf file in the 2nd instance, is the path to the
log file directory hard coded?
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
to display time at the client's current (or
specified) time zone.
--
john r pierce, recycling bits in santa cruz
$PP/*.dump; do
pg_restore -d postgres --clean --create $db
done
but this is more for regular backups, the advantage of the compressed
format is pg_restore has a lot more options during database restore.
--
john r pierce, recycling bits in santa cruz
be used for
this, pretty much any language that can connect to the database and do
queries. I would NOT do this in a shell script as each interation would
involve multiple forks.
--
john r pierce, recycling bits in santa cruz
.
etc/etc.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
it, and sleeps
til the next minute then repeats. running it from cron would require
multiple process forks every sample, which is fairly expensive.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
) that once a minute executes those two queries (you'll need two
database connections since only the slave knows how far behind it is),
and inserts the data into your table.
--
john r pierce, recycling bits in santa cruz
as you
have, thats the 'live' value ... you oculd use a view, I suppose.
--
john r pierce, recycling bits in santa cruz
, not the
'minimum' version.why mess with bugs that have been fixed ? choose
the proper jdbc driver based on your Java JRE version (eg, jdbc42 for
Java 8)
--
john r pierce, recycling bits in santa cruz
On 11/24/2016 5:44 PM, Yogesh Sharma wrote:
I cannot change calling of REINDEX and insert query sequence because it is
execute automatically through some cron script.
any cron scripts are your own doing, so this statement makes no sense at
all.
--
john r pierce, recycling bits in santa
, and
select pg_stopbackup(); when you're done.
--
john r pierce, recycling bits in santa cruz
, barman, I've never used but its supposed to greatly
simplify this whole process...
http://www.pgbarman.org/
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
archives allows PiTR too, point
in time recovery. say you discover a bad script updated a ton of bad
data into your database last tuesday at 3pm. you can restore the
preceding base backup, then recover up to tuesday just before this event.
--
john r pierce, recycling bits in santa cruz
, anything that relies on those sorts of checks will fail
under concurrent loads.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to but not including the point in time of
the transaction that clobbered your data.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
it
resumes streaming. This will happen automatically.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
questions about this, I've never done it, but 15
seconds with google found that page.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
on dedicated hardware
servers, which don't have all these reliability and performance
problems. a complete server failure requiring a full rebuild is
something that would happen less than annually.
--
john r pierce, recycling bits in santa cruz
ng you. others can probably chime in with more info on this.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
101 - 200 of 2328 matches
Mail list logo
