PC #2, how should i install it..
Check the command lines for the EnterpriseDB installer. I'd be surprised
if it didn't have a binaries-only option that allowed you to skip
database creation and creation of a Windows service entry, so you can
then just use pg_ctl to start/stop the DB.
--
Craig
a
serialization failure and forcing the app to re-issue the transaction.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
size is 32 kB.
Use pg_total_relation_size to include TOAST tables too.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re-titled thread.
On 07/11/2012 11:13 PM, Gregorio, Albert wrote:
I am working with PostgreSQL 9.1.3 -- I setup a master and standby --
Initiated replication and verified that it was occurring -- Failed
over from master to standby and verified that the database could be
updated on the new
the server, which you don't want to do.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
was built against.
Since you've neglected to describe your client or server environments at
all, it's hard to say more.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
that the only mention of this is at the very
bottom of this page:
http://www.postgresql.org/docs/9.1/static/functions-sequence.html
as it's an important property of sequences and one that shouldn't just
be a footnote.
I'd use a real table for this job.
--
Craig Ringer
than hunting blindly with EXPLAIN ANALYZE it's better to just
turn log_temp_files on and see what's reported.
--
Craig Ringer
SchemaSpy ( http://schemaspy.sourceforge.net/).
--
Craig Ringer
hitting
operating system limits. Look for fork() failures, unexplained
segfaults, etc.
--
Craig Ringer
, but it fits - you're getting an
error saying that psql is trying to operate on a socket that isn't there.
The fact that there's nothing in the system logs or Pg logs just adds
weight to that. I'm guessing you have a threading bug, possibly signal
related.
--
Craig Ringer
--
Sent via pgsql-general
Here's the test program, btw:
https://github.com/ringerc/scrapcode/tree/master/scripts/pg_forktest
pgfork.py is a home rolled fork() horror.
pg_mp.py is the same thing done with Python's multiprocessing module.
--
Craig Ringer
it. etc.
Honestly, if you don't have something you want to _achieve_ it's
probably mostly going to be boring. What do you want to do, to get out
of this?
--
Craig Ringer
an UPSERT or MERGE operation.
PostgreSQL doesn't have any native support to do this for you. Doing it
right is surprisingly tricky. This is the best article I've seen on the
topic:
http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/
--
Craig Ringer
Penatho. http://kettle.pentaho.com/
For very very fast loading of bulk data, consider pg_bulkload
http://pgbulkload.projects.postgresql.org/ . It's only worth the hassle
if your load will take many, many hours without it.
--
Craig Ringer
huge engineering effort anyway.
For now, you'll have to live with disconnecting sessions from your DB
before cloning it as a template.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
On 06/25/2012 02:50 PM, Stefan Schwarzer wrote:
Craig Ringer wrote:
I'm puzzled about why you don't appear to be looking at the server error logs
(/usr/local/pgsql-9.1/data/pg_log) during troubleshooting. They're your main
source of info.
Hmm, I guess it's because I didn't think of it, I
on the current directory - probably your
home dir - but the _postgres user doesn't have access to it.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://www.postgresql.org/docs/9.1/static/release-9-1.html
Do not just try to upgrade your production database. Do a test with a
test copy first, and test your application against it; don't just assume
it'll all work.
--
Craig Ringer
. Always dump with
pg_dump from the newer database.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
race conditions and bugs related to its file access interception, and Pg
appears to be particularly good at triggering them.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
runs….
You really should be able to use pg_ctl though.
I'm puzzled about why you don't appear to be looking at the server error
logs (/usr/local/pgsql-9.1/data/pg_log) during troubleshooting. They're
your main source of info.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql
://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/
(thanks again depesz for your great articles).
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 06/24/2012 03:42 PM, Robert Poor wrote:
Craig:
On Sun, Jun 24, 2012 at 12:06 AM, Craig Ringer ring...@ringerc.id.au wrote:
That [implementation of UPSERT] is incorrect; it's subject to several nasty
races.
The best article I've seen on this is here:
http://www.depesz.com/2012/06/10/why
method
Great.
--
Craig Ringer
/static/datatype-binary.html .
--
Craig Ringer
on the folder with the
PostgreSQL executables etc in it (by default it contains the datadir,
but not always, so may need to be set separately), *AND* set an
exception for the postmaster and postgres.exe executables.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
.
--
Craig Ringer
, it seems blindingly obvious. You have a talent for
making a devastating point very succinctly.
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
--
Sent via pgsql-general mailing list (pgsql
will you
account for work done by PgAgent (if used), via dblink, etc?
I guess I'm unsure what you're trying to accomplish.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the tx and nobody's wanted to add a communication channel to
let psql tell the backend it's working interactively?
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
--
Sent via pgsql-general
user's load can adversely affect other users.
While most people's use of Pg doesn't suffer for these limitations, I
suspect you'll need to know about them if you're trying to offer
multi-tenant hosting.
--
Craig Ringer
CREATE TEMPORARY VIEW, but that'll still
exist until the session ends. Both approaches are slow.
That leads back to my first question: What exactly are you trying to
accomplish with this? What problem are you trying to solve?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general
be the solution.
Yep, that's the immediate cause of failure, and I missed that in my
reply so I'm answering the *next* question. Whoops, sorry.
If you remove the name and use positional style, the function still
fails for a different reason, as per my post following.
--
Craig Ringer
--
Sent via pgsql
PostgreSQL server logs?
Try enabling log_statement='all' in postgresql.conf .
--
Craig Ringer
of commands is probably possible in weaker
installations.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
fired
up an Azure VM (Linux or Windows) and done some tests, focusing
particularly on crash-safety, fsync rates, and I/O performance. If not,
I might have to have a play.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
the debug info
into external symbols packages using strip --only-keep-debug. There
isn't much point unless disk space consumed by executables is a big
concern, though.
I always use --enable-debug when building Pg. I rarely need the symbols,
but it's handy to have them when I do.
--
Craig Ringer
.
But the make process gives me this:
Looks like your dev env is broken or incomplete.
--
Craig Ringer
to a limitation/bug in how PostgreSQL and
pg_restore handle locales and encodings. You must use the CREATE
DATABASE followed by separate pg_restore method in that case.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
of PostgreSQL and can bypass all security and
authentication completely.
--
Craig Ringer
://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD
--
Craig Ringer
://social.microsoft.com/Forums/en/crm/thread/db84d4c3-c58e-4ff9-997f-f4e0116bf043
http://blogs.msdn.com/b/astebner/archive/2010/10/20/10078468.aspx
BTW, IBM seems to install the redist as:
|vcredist_x86.exe /q /c:msiexec /i vcredist.msi /qn /l*v
%temp%\vcredist_x86.log|
... not sure why yet.
--
Craig Ringer
workload. There's no point
running a benchmark that's nothing like your workload and drawing
conclusions about your workload from it.
--
Craig Ringer
:
(a) Silently skipping installation and returning success; or
(b) installing themselves into WinSxS whether or not a newer version
exists already
They absolutely should not be failing. Can you please post your
installation logs?
--
Craig Ringer
less modern
JavaScript sucks, I expect to see tons more PL/JavaScript once Pg 9.2
starts seeing adoption.
--
Craig Ringer
install. They work fine
everywhere I use them.
To find out why the MSVC++ runtime is failing to install on your machine
you need to collect the installer log. See:
http://wiki.postgresql.org/wiki/Troubleshooting_Installation
--
Craig Ringer
master solution.
PgPool-II doesn't offer mutli-master operation. Not much does.
Multi-master is very difficult to get right, and even harder to make fast.
Are you really sure it's what you want? Failover is often a much, MUCH
simpler and more efficient approach.
--
Craig Ringer
--
Sent via pgsql
and nobody has stepped up to implement it.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-usability-pgadmin-iii-and-pg.html
and would be interested in your comments/experiences because more
knowledge will help produce a better UI if I ever get the time to have a
go at addressing some of this, or if someone else does.
--
Craig Ringer
On 05/30/2012 10:01 AM, Adrian Klaver wrote:
On 05/29/2012 06:56 PM, Craig Ringer wrote:
On 05/29/2012 02:27 AM, Alexander Reichstadt wrote:
Hi,
I am trying to simply export my postgres database from one server
and then import it into another. I thought I could use PhpPgAdmin,
but the hints
... in response to the command: CREATE ROLE postgres;
Anway, I hope my rant/critique/whine is helpful.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
intention to break that down into specific problem areas and
points, I just thought it was worth getting a few initial impressions too.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
, but might not be too.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 05/14/2012 12:12 PM, Pham Ngoc Hai wrote:
I'm running PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by
gcc (GCC) 4.4.6 20110731 (Red Hat 4.4.6-3), 64-bit
on CentOS release 6.2 (Final)
Recently we encountered postmaster segfault, what the core dump gives
me is:
Did you ever see
they are in UTF-8 and was well and truly worth the storage
bloat IMO. Pity Unicode had to grow again and break the assumption.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
a hardware fault or (small
chance) kernel bug. If Pg could cause a crash like that it'd be a kernel
DoS vulnerability, but I'm much more inclined to suspect the hardware
even without the dodgy history.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
recursive common table expressions (`WITH RECURSIVE') are used
to handle queries on self-referential tables. Have a look in the
documentation for more information.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
distributed as the EnterpriseDB One-click
installers do support SSL, yes.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
when fsync is on.
You were running in a mode that says be fast even if you eat my data.
It ate your data. If you don't tell it to, it won't.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
--
Craig Ringer
sent in my last post for info on how to do it using windbg or vc++
express.
--
Craig Ringer
--
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 are using a standard binary distribution of PostgreSQL then yes,
you should use Visual C++, preferably the same version of Visual C++
that was used for that version of PostgreSQL. Specify your version of Pg.
--
Craig Ringer
partitioned by is not only ordinal but interval too,
then it'd be possible to define regular intervals for partitioning and
build a bitmap for matching tables. That'd be a fun honours / masters
project, but hardly something suitable for trying to hack into a
production setup.
--
Craig Ringer
to start. Probably
permissions. See:
wiki.postgresql.org/wiki/Guide_to_reporting_problems
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
table and committed.
--
Craig Ringer
lists or on Stack
Overflow anyway.
--
Craig Ringer
On 29/12/2011 2:48 PM, saqi...@igis.nust.edu.pk wrote:
Hi every1 how are u all??? Members i am new in postgres and want to
work on pgrouting but i am facing some issue will u please help me???
I have loaded my line shapefile in pgadmin
or improvements to the code below?
Only that it might be less hassle to wrap gethostname from pl/perl or
pl/python rather than adding a new C function, particularly if this is
only for DB testing and is not performance critical.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general
loaded DBs, big reporting queries on other DBs, etc.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
selectivity index
(say 1:1000 or more) where you want to keep the index tiny, fast, and
very quick to scan.
I guess ideally Pg would be able to deduce that the index value is
always the same and just store a page list rather than a b-tree, but
it's a bit of a tiny use case.
--
Craig Ringer
currently
operating as. Related to:
http://stackoverflow.com/questions/8432636/in-postgresql-are-partitions-or-multiple-databases-more-efficient/8439618#8439618
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
run I'm not sure what to advise.
--
Craig Ringer
On 12/15/2011 01:16 AM, Andreas wrote:
Am 14.12.2011 14:28, schrieb Craig Ringer:
On 14/12/2011 8:32 PM, Andreas wrote:
Hi,
I asked elsewhere about the best way to store db credentials within
a user-session of a web-app.
Where? Link?
Well, it was on the general list of php.net.
I read
warning when this condition is detected, since
I've seen several people confused by it over time.
--
Craig Ringer
**NOT** have administrator rights. Grant the
account full control over its data directory and REMOVE its
administrator rights.
--
Craig Ringer
of mytable_one when you do a
seqscan on it, but it might not, and it might be correct in not doing so.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
as WITH expressions.
There's been talk of a Pg extension that allows optimisation through
WITH, but it's not currently possible.
Another option is to wrap things up in SQL functions or views.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
.
Personally I'd choose good performance monitoring over user/query
priorities any day. With good perf monitoring I can script from the
outside I have a lot more control, can send alerts, etc etc.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On 12/09/2011 10:35 PM, Adrian Klaver wrote:
First question, are you sure you are connecting to same database in
both the remote and local case?
It strikes me that this is another use case for being able to get the
system identifier from SQL :-)
--
Craig Ringer
--
Sent via pgsql-general
On Dec 8, 2011 1:27 PM, Chris Travers chris.trav...@gmail.com wrote:
Additionally I am not entirely sure what he means by the last point.
If you look at the work that NTT along with EDB has put into
Postgres-XC, for example, it looks to me like the Postgres ecosystem
is growing by leaps and
On 12/08/2011 08:53 PM, Tomas Vondra wrote:
On 8 Prosinec 2011, 12:24, Craig Ringer wrote:
- admission control, queuing and resource limiting to optimally load a
machine. Some limited level is possible with external pooling, but only by
limiting concurrent workers.
o d
The first thing I'd like
connections I'm generally reluctant to use setups where the app auths
against the database with a given user ID and password directly.
--
Craig Ringer
surprised given how
complicated problems around lock management and priority inversion are
to get right even in a system where there *aren't* free-form dynamic
user-defined queries running.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
of the reasons
I'd love to see in-core pooling, because I don't see how an out-of-core
solution can maintain session state like advisory locks, HOLD cursors, etc.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
can't find the
function because it's in a schema that isn't being searched;
- ?
Please show your function definition.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
EnterpriseDB. If it's another product, please specify.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
proc.
If you're connected to EnterpriseDB, I'd expect that.
If you're connected to PostgreSQL, maybe PgAdmin is translating EXEC
into a SELECT ?
--
Craig Ringer
On 06/12/11 22:51, Daniel Migowski wrote:
Continuing this talk on general, as requested by Craig.
I have a functional Index on a table that is relative expensive to calculate.
Now I noticed on every update of even index-unrelated fields of the table the
index function is calculated again
and purely relational. I don't have any experience
with Castle ActiveRecord. When I've used hstore with hibernate I've
always done it by direct native queries.
--
Craig Ringer
Cisco) are releasing
- it's their kernel and any (L)GPL userspace components, but not their
own stuff.
Note that relying on a full-GPL library that you directly link to
clearly *does* require you to license your own code under the GPL.
Anything short of that is grades of fuzzy.
--
Craig
. Opinions do vary, and mine's just one
uninformed opinion; if you want a good one go ask the SFLC.).
--
Craig Ringer
to use an INNER JOIN and
consolidate the rows, or use a nested SELECT and aggregate on the fly.
That'll get slow. It'll work and is IMO better than all the other
options you suggested, but I'd probably favour hstore over it.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general
value 2550017 in pg_toast_17076
Now that you've taken a file-level backup (hopefully copied to a
different computer), do you think it might be worth doing an fsck of the
file system? I'm wondering if your underlying storage has been doing
something dodgy.
--
Craig Ringer
--
Sent via pgsql
a compressed SSH tunnel, compressed VPN, etc.
Alternately, investigate 3rd party replication options like Slony and
Bucardo that might be better suited to your use case.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
not indicate something
unusual.
All pg threads are sleeping (S state).
I will try to reproduce this, this time with a smaller initial disk size...
Try checking where the postgres processes are waiting, too:
ps -C postgres -o wchan=
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql
) ?
Check the man page for psql in 9.1; I think client-side keepalive
support got committed for 9.1 . If it didn't, you can always set it
globally for all TCP/IP connections on your system. See eg
http://tldp.org/HOWTO/TCP-Keepalive-HOWTO/usingkeepalive.html .
--
Craig Ringer
...
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
info we can see what might be going on.
--
Craig Ringer
that talked to wmi. If you were to
write a suitable script, I'm sure the EnterpriseDB folks would consider
including it in the installer and adding an option to run it on uninstall.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
someone's written one, there isn't one.
I imagine you'll need to find a generic OLEDB / ODBC / ADO.NET BizTalk
adapter and use that with the suitable PgODBC or nPgSQL driver.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
401 - 500 of 1783 matches
Mail list logo
