? or on a
seperate VM on the same host ?
what does `iostat -x 5` show ? let it run a bunch of samples, then run
this slow query and get more samples. pay attention to the disk
drive(s) the database is stored on.
high %utilization or await times would be a bad thing.
--
john r pierce
compared to randomly: 7,3,10,1,4
its unclear to me what you mean here.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
on the hard disk.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to
look at the pg_dump code, its fairly complex.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
to create database
How to solve this one?
sudo -u postgres psql -c alter role roelof with createdb createuser
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
on the desktop login, much the same as quite a few built in accounts,
like the IUSR_machinename account that Microsoft's IIS webserver uses by
default.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
newer than the
oldest transaction.
select * from pg_stat_activity where xact_start now()-interval '1 hour';
will list all connections with transactions over 1 hour old.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via
in == bytes out.)
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
= #{other_id}
then avg(daily_action_answers.value) end as other
), :view).group(view.gender)
end
OT, but it boggles my mind that anyone thinks thats 'better' than the
straight SQL
--
john r pierce 37N 122W
somewhere on the middle of the left
syntax in whatever language that was. to me,
thats just more layers of obfuscation.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 7/3/2014 4:51 PM, David Wall wrote:
That's interesting. Since I gzip the resulting output, I'll give -Z0
a try. I didn't realize that any compression was on by default.
default compression only happens in with pg_dump -Fc
--
john r pierce 37N 122W
on a 64bit
client OS, if you have 32 bit applications, they also require 32 bit
ODBC drivers. only if both the OS *and* the client applications are
64bit would a 64bit ODBC be suitable.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
john r pierce 37N 122W
somewhere on the middle of the left coast
the table
definition, so you can then proceed to insert new data into it.
I really don't understand what you mean by 'a database of a file
system'. I'm beginning to suspect you don't understand how SQL
databases work.
--
john r pierce 37N 122W
database (port) to connect to?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 7/1/2014 11:08 AM, Felipe Gasper wrote:
What is the best way to list a role’s owned objects in any database?
query pg_class in each database ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing
but
somehow that seems wrong. Any ideas?
how would an instance of your program know what to connect to, or which
previous instance its 'predecessor' was ?
normally, you have ONE database for a given set of applications, and all
the applications share the same database tables and such.
--
john r
archive_command or script that you use for copying/gzipping the files?
Thanks beforehand.
you need ALL the archived WAL files since the start of the last base
backup, or none of them are useful.
--
john r pierce 37N 122W
somewhere on the middle of the left
,
and restart the app(s). Usually we try to do our schema updates so the
old code will continue to work with the new schema, so the new code can
be cut in incrementally with virtually zero downtime.
--
john r pierce 37N 122W
somewhere on the middle of the left
On 6/12/2014 1:23 AM, Khangelani Gama wrote:
I then did the following:
1.We installed library 'xml2' (version = 2.6.23)
2../configure --with-libxml
3.gmake
4.gmake install
was the previous version custom built with /no/ options ?
what OS/distribution is this on?
--
john r pierce
On 6/12/2014 2:06 AM, Khangelani Gama wrote:
Was the database server restarted after the new version was built?
It was not restarted - Should I do so?
why aren't you running the version in the pgdg yum repository, which
includes XML support and a lot more.
--
john r pierce
shown in ps output
with the pid (or procpid if an older release) in pg_stat_activity, too.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
it for a transaction, then release it back to the pool.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
? If it is
possible, then how do I do it exactly as the only thing I get from
libpq is a void-pointer?
those are text data types. there is no binary representations.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general
to fix ? is it easier to remove and reinstall postgres ??
or maybe it is not worth bothering to fix and just use sudo ?
removing/reinstalling would change nothing.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql
On 6/5/2014 2:43 PM, Moshe Jacobson wrote:
The EXPLAIN ANALYZE for this query indicates that all of the tables in
the query are being joined despite the fact that they are not needed
at all.
Why is this?
why would you join 28 tables you're not using ??
--
john r pierce
not the problem, hard to guess what is, sounds like
you have a lot going on.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On 6/1/2014 12:16 AM, David Wall wrote:
at
com.esignforms.db.ConnectionPool.makeConnection(ConnectionPool.java:302)
that sounds like some form of connection pool.
perhaps connections are being shared between client processes that
expect different timezones?
--
john r pierce
replicated).
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
happens?
your log shows no such evidence nor really says much of anything, other
than that you restarted postgresql at 2014-05-10 00:15:58 CST and again
at 2014-05-10 20:52:24 CST
--
john r pierce 37N 122W
somewhere on the middle of the left coast
constrain itself to not generating more than N blocks/second
the answer is, no, there's no such feature.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
of index, this would be akin to what vacuum and
autovacuum do now.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
can't recommend any specific ETL tool to do this
as I've never needed to do this exactly.
there's some ETL tools listed here,
http://en.wikipedia.org/wiki/Extract,_transform,_load
--
john r pierce 37N 122W
somewhere on the middle of the left coast
development.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
didn't specify the columns in your file, how would you expect it
to know whats there and not there?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
...
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
table bloat.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
) on a development server. anyone who's worked with
these postgresql munin scripts have any ideas?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
it was barfed out of some ORM or similar data distraction.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
to which I respond with radiovision's password. I then get the error:
connection to database radiovision failed: FATAL: password authentication failed for
user DrRudner.
try pg_dump -U radiovision -C radiovision ...
--
john r pierce 37N 122W
somewhere
.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in short order, meanwhile running at molasses slow speeds.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
suitable as database storage, they perform really
poorly on random writes, and if you're going to store the data on the
systems hard disk, you might as well store the software there too as you
can't access the data without the server software.
--
john r pierce
software from your management,
then you shouldn't be doing this at all.
if you have a business need for this, then get the network
administrators to deploy a proper database server on the network, don't
juryrig something up on your PC
--
john r pierce 37N 122W
? nothing in postgresql.conf has
anything to do with INSERT statements or query parameters or functions.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
support if you
can, as openssl is a mess.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
which implements the business logic, and THAT
talks to the database.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
to OpenSSL 1.0.1x for x=a-f...openssl is only used on windows when
someone uses it explicitly, such as in Cygwin applications, and such.
It *is* used by postgresql under windows as enterpriseDB builds it,
since PG was written to use openssl in the first place.
--
john r pierce
, the binary name is postgres.exe, from what I've read they are
static linking openssl. the updated versions on the site linked in
another message are fixed per the note on that page.
http://www.enterprisedb.com/products-services-training/pgdownload
--
john r pierce
connection until its committed.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
name
is. my postgreses are generally postgresql-x.y where x.y is the major
version (9.1, 9.3, etc)
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
not aware of which
changes have been made lately.
Do you think I need to reinstall the works and set everything up again?
rpm -qa |grep postgres
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list
.
The former seems more likely. /var/log/yum.log might be helpful
in affixing blame.
or maybe you're looking at the wrong server or VM ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql
On 4/10/2014 1:01 AM, Albe Laurenz wrote:
If you are in a totally trusted environment, why would you use SSL?
Belt, and suspenders.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql
, decrypt it in the client when you need it back.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
as the
file system is operational, this implies that any data in it can be read
by anyone with access to that system.
now, if you just need a checkbox saying its encrypted, then whatever, it
hardly matters.
--
john r pierce 37N 122W
somewhere on the middle
of
this encrypted data (presumably credit card numbers or some such ?) if
so, then it too would need to be able to decrypt the data and would have
to possess the decryption key(s).
--
john r pierce 37N 122W
somewhere on the middle of the left coast
r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
BBU's on raid cards are being replaced by 'flash-back' which is a
supercap and flash memory backup for the raid card's write-back cache.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
a straight JBOD configuration.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
UI to instrument your java ETL
tool to allow you to pause and run manual SQL queries on the same interface?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
objects, that are then broken, THATS also broken behavior.
but yeah, this belongs on the jdbc list.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
means, keep it on someone
elses virtualized infrastructure with no performance or reliability
guarantees.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
if Spring has automagically released/closed the connection?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
random access. you'd get way more IO
throughput with a raid10 array of 15k rpm SAS disks, maybe 10 x 600GB or
whatever, or with a suitable SSD configuration, although 3TB of SSD
might get expensive.
--
john r pierce 37N 122W
somewhere on the middle
that)
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of problems and performance
issues, not the least of which is transaction conflict resolution.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 3/27/2014 6:41 AM, Adrian Klaver wrote:
http://www.hpenterprisesecurity.com/vulncat/en/vulncat/index.html
This indicates Postgres is not supported.
looking over what that tool *does* audit in the plsql and tsql that it
supports is not very reassuring.
--
john r pierce
...
from the manual, it appears LIKE belongs in parenthesis.
CREATE TABLE tse_history_old (LIKE tse_history INCLUDING ALL) WITH OIDS
--
john r pierce 37N 122W
somewhere on the middle of the left coast
On 3/26/2014 12:42 PM, Dev Kumkar wrote:
Is Fortify supported for PostgreSQL?
why don't you ask the Fortify vendor ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general
On 3/26/2014 12:58 PM, Hall, Samuel L (Sam) wrote:
That doesn't help. Even this CREATE TABLE tse_history_old (LIKE
tse_history) gives an error
the exact same error ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
On 3/26/2014 1:07 PM, Hall, Samuel L (Sam) wrote:
ERROR: syntax error at or near LIKE
LINE 2: CREATE TABLE tse_history_old (LIKE tse_history)
thats the syntax from
http://www.postgresql.org/docs/current/static/sql-createtable.html
try it in psql instead of pgadmin ?
earlier, you
, but that has no
impact on single threaded performance, only matters if you're running
enough queries concurrently to use all the cores.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general
by EnterpriseDB's PostgreSQL Advanced
Server, which has extensive Oracle compatability added to it.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
. with it at 300,
under heavy load, the replication could run as much as 5 minutes (300
seconds) behind before it errors.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
count to be tunable, probably down around 2X the
cpu core count, depending on various things.some folks say, CPU
cores/threads plus disk spindles is the optimal number.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via
over the years of
supporting this, but nothing concrete yet. Your best bet would be to
ask about this on the Postgres lists
in addition to what the others suggested, you can use a CURSOR to read
through results in arbitrary sized blocks.
--
john r pierce
enough that you DONT get into problems when doing stuff
like basebackups.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
contention from
other virtual machines on the same physical host.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
6i? If not, what
options would you recommend?
extremely unlikely Oracle Forms will work with ANYthing other than
Oracle database.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql
).
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
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/19/2014 1:21 PM, Dev Kumkar wrote:
createdb -U postgres -E utf8 -l en-US -T template0 mynewdb
Password:
*createdb: database creation failed: ERROR: invalid locale name: en-US*
I believe its en_US ... _ not -
--
john r pierce 37N 122W
somewhere
, another bastard, this is a modified ISO-8859-1
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
by a different postgres
server, running multiple databases?
Craig's answer covers all the bases, quite accurately.Because you
don't like it, you think someone else is going to give you some magic to
make all that go away?
--
john r pierce 37N 122W
the resources
I'm using? Unless postgres supports balooning of memory?
perhaps you could start/stop the test instances on demand as needed ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general
is not an allocation, its just an estimate of how
much system cache is likely to contain recently accessed postgres data,
the planner uses it guess the cost of 'disk' accesses.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql
copyright and two paragraph disclaimer
in your copyright notices, if you're distributing any derivative of
PostgreSQL, otherwise, there are no strings attached.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general
to achieve password-less login in postgresql? I
tried alter user password NULL.
.pgpass is supported by any libpq based client.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general
for the slave.
scripts for doing things like deleting old files are OS dependent. on a
(l)unix type system, its as simple as...
find /path/to/files -mtime +2 | xargs rm
will delete everything over 2 days old in that path.
--
john r pierce 37N 122W
On 2/1/2014 3:18 PM, Edson Richter wrote:
It is possible to put a PostgreSQL database in substitution of a
Oracle database for an app running BDE?
Any tips (beyond obvious check Oracle specific funcionality)?
what is BDE ?
--
john r pierce 37N 122W
On 2/1/2014 4:26 PM, Adrian Klaver wrote:
On 02/01/2014 03:26 PM, John R Pierce wrote:
On 2/1/2014 3:18 PM, Edson Richter wrote:
It is possible to put a PostgreSQL database in substitution of a
Oracle database for an app running BDE?
Any tips (beyond obvious check Oracle specific funcionality
most such, they are undoubtedly designed for a lowest common
denominator, and won't have support for database implementation specific
data types, just common stuff like strings, numbers.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
On 1/28/2014 1:20 PM, Tom Lane wrote:
I think you can fix it by explicitly casting your placeholders, eg
?::macaddr.
that might work for a wrapper that lets you roll your own SQL, but I
thought he said one of these autogenerated SQL, taking it out of his
control.
--
john r pierce
have these issues..
it had more implicit casts prior to (I think) 8.3, but there were many
ambiguities where things could be interpreted to mean radically
different sorts of operations, so they tightened things up in 8.3+ (or
was it 8.4+ ?)
--
john r pierce
doesn't have a
primary key, um, why not??
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
On 1/26/2014 12:35 AM, Dmitry Koterov wrote:
PostgreSQL supports synchronous multi-master
no, PostgreSQL does not support multi-master, not without some sort of
third party replication system, all of which have serious compromises.
--
john r pierce 37N
On 1/24/2014 11:55 AM, Susan Cassidy wrote:
I don't actually know what SELinux is. What else will happen if I
(find out how to) disable it?
your system will be less secure.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent
exceptions but allow them
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-update-in-einem-statement/
that won't perform very well if you have a high level of concurrency.
have you seen the upsert example in the postgres plpgsql docs ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
801 - 900 of 2328 matches
Mail list logo