On 02/12/10 01:11, Anibal David Acosta wrote:
> So, I only have the postgres directory on my hands. I decide to install the
> same database version in another computer and replace DATA directory, but I
> notice that 8.1 (windows binary) is not available for download.
>
> So, I don't know how to r
wouldn't it be better to
improve Pg's core to handle the job better? Per-user storage quotas,
database-scoped user IDs, age-limited transactions (though that can
already be done pretty easily with a simple script), access-filtered
views in pg_catalog, etc.
--
Craig Ringer
--
Sent via p
Hi all
I'm finding a few areas where PostgreSQL's refusal to implicitly cast
from 'text' to another type is causing real problems, particularly when
using the PgJDBC driver. I'd like to propose a couple of relaxations of
the implicit cast rules for certain text-like types:
- user-defined enums; a
nice if PostgreSQL offered more convenient ways to set an
initial schema for new connections, because for some use cases it'd be
quite handy to use a single database with many schema. Unfortunately
most tools only know how to ask for a database name, not a schema name,
and there's n
s", etc.
Personally, I'd be using existing system- and network-level intrusion
detection tools like tripwire and snort to try to spot intrusion if and
when it happens. I'm not confident that a chain-of-trust approach is
workable on Linux systems at present, though I'd love
ut have weird requirement, can you
help me"
--
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
arget server has a TPM you can enable and use for
Trusted GRUB.
--
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
Given:
create table t1 ( c1 timestamp without time zone, c2 int );
explain verbose select to_char ( c1, '' ) from t1
group by to_char ( c1, '' );
does any one know why the SEQSCAN node has TWO TARGETENTRYs?
Why do we project "c1" as well as "to_char( c1 . )" ?
ke any difference, but I'm far from a C/C++ expert.
Postgres is no doubt trying to load a C++ linked library as C - is there a way
to fix this?
AFAIK, dlopen() doesn't care if a library is C, C++, or BlueLanguage, so
long as it provides standard ELF symbols and a C-compatible entry poin
On 12/24/2010 11:16 PM, Elliot Chance wrote:
Cheers! It works.
Beware - that's really unsafe if you're calling C++ libraries that may
throw exceptions.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
Pg headers aren't really C++ safe. Neither is Pg's
longjmp-based error handling, which really won't mix well with
exceptions or with stack-based objects that have dtors.
--
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
postgresql developer. I haven't seen Diogo or Euler around on the
mailing lists, but that doesn't mean they're not involved.
--
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
database's write load on 8.4 and
above, you should not need to vacuum manually.
See the PostgreSQL documentation and wiki for information on tuning
autovacuum.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ke care
of this for you. In fact, I had to fight to convince Hibernate that I
*didn't* want it to increment all my counters in steps of 50.
--
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
ideas how I can reproduce 8.1 function
in 8.4?
In what regard is it 'not compatible' ?
Please provide output from 8.1 and 8.4 for one of the samples you're
using, along with an explanation of what's causing you problems.
--
Craig Ringer
--
Sent via pgsql-general mailing
x or
retire the legacy app. I'd just make really, really sure I could always
enable full char encoding support later.
substitute them? (not so nice, i'd like to have the chars in the db)
Ick.
--
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
CTION' state as listed in
"SELECT * FROM pg_stat_activity;" ?
Is autovacuum enabled? Have you done anything like tuned autovacuum to
hardly ever run?
What're the results of running 'VACUUM ANALYZE VERBOSE;' in the problem
database?
--
Craig Ringer
--
Sent vi
is similar it should be easy to adapt to use as a
loadable module. I haven't checked 8.1's code to check.
See the tutorial for help on how to implement C extension modules.
Personally I think you're way better off fixing your app to use pgcrypto
and a decent hash functio
g
aggressive enough, or it could be issues with long-running transactions.
--
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
connection, is there
are any command which will kill such a aborted transaction in a safe manner?
psql> select pg_terminate_backend(26286);
or
shell$> kill 26286
Do ***NOT*** use "kill -9" or "kill -KILL".
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-
ame to connect to, and
would just use what was provided to me. This is almost certainly how it
should be done on UNIX/Linux platforms.
--
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
pp. It can enforce your business rules about who is allowed to
see/modify what, when.
--
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
ctories and use pg_upgrade
Both require testing and careful thought. It's a pain, and one of the
reasons Pg isn't great for bundling/embedding in apps.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
ck trace
can be found here:
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows
--
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
ure does it have to be?
(You **might** be able to keep it secure against a non-admin user with
physical access if you had a system with a "trusted boot" chain using
the TPM, etc. I doubt you'll be able to require that, though!)
--
Craig Ringer
--
Sent via pgsql-general mailing list
ant to check out Firebird, which is designed for embedded
use. I don't know if it has encrypted data file storage options and
other weak-security-against-priveleged-local-user stuff, but it's going
to be a more viable option than Pg will.
--
Craig Ringer
--
Sent via pgsql-general mailin
features you use are part of the SQL standards, etc.
They are a premium software vendor and have a premium product, but
charge a premium price for it.
I tend to think of them as small fry compared to IBM, Oracle and
Microsoft. They're certainly more significant than folks like Cach
On 01/21/2011 10:45 PM, Robert Paresi wrote:
Hello,
I can't figure this out, and need help.
I need access (VIA SQL Statements) to retreive a list of all PUBLIC
tables, columns and their descriptions.
Look at the INFORMATION_SCHEMA schema.
--
Craig Ringer
--
Sent via pgsql-general ma
cess completes
properly?
I *think* tuples become available progressively, but I'm not certain of
that.
c. Is there anything I can do to make vacuums shorter?
Do it much more often.
Use Pg 8.4 or later, with visibility map.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-gener
On 01/31/2011 12:14 AM, Herouth Maoz wrote:
On 30/01/2011, at 12:27, Craig Ringer wrote:
OK, so you're pre-8.4 , which means you have the max_fsm settings to
play with. Have you seen any messages in the logs about the free space
map (fsm)? If your install didn't have a big enough f
here. Either way, you need to provide a lot more information for anybody
to have any chance of helping you.
--
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 15/02/11 00:55, Edwin Giraldo wrote:
> i was using holdem manager and my for some reason it said that i coudlnt
> connect to my postgres so i tried uninstalling postgres and installing
> it again, but i received a message saing that i could connect to the
> logon server please help i have team v
On 15/02/11 06:28, deepak wrote:
> Hi!
>
> I was trying to build PostgreSQL 9.0.1 using VS2008. I am having
> problems building the C extensions. I could build the main package, though.
The easiest way to do it on Windows is to make a new `contrib' module
and compile as part of the main build.
module together
because build.pl didn't understand ifndef .
--
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
ile syntax. I had problems when I was
putting the crashdump module together because build.pl
<http://build.pl> didn't understand ifndef .
--
Craig Ringer
Ok, I hadn't realized that the VS build system extrapolates information
from unix Makefiles..
I briefly tried
ction or type being accessed in
the global database server?
You probably want to use one database with multiple schema instead. See
the manual for more information about schema.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscri
actical if your webapp likes to run
its own generated DDL during upgrades (like Rails, Drupal, etc) or lacks
any sort of documentation on what access rights it needs.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@post
quot;ALTER DATABASE SET
search_path=shared,public" to make it default.
See the manual for more information about schema, and the commands/options:
SET
search_path
CREATE SCHEMA
CREATE FUNCTION
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql
ring negotiation or an explicit SET, rather than just making
it globally default. But, hey, hindsight.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ossible to maintain in a single database for all years of data?
How much data do you expect to have? How fast will it grow?
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
* Yes it's insane to write a mission-critical system in 1991 using a
closed source runtime that was abandoned and dead in 1983. It was before
my time at the company, which just means I get to suffer through
maintaining the damn thing while trying to replace it.
--
Craig R
new
representation is incompatible, as the text-format bytea affair
demonstrated.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 27/02/11 20:47, AI Rumman wrote:
> I am getting error in Postgresql 9.0.1.
>
> update import_details_test
> set data_row = '["4","1 Monor JoÃ\u083ão S. AntÃ\u0083ão
^^
Because your email client may have transformed the text encod
t at some point - personally, I don't presently even use
HS, so it's well beyond my needs.
--
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
eral times as the correct way to
'do' binary with libpq, handles this for you). Only the default
setting was changed.
Ah. Thanks for clarifying that.
It sounds like binary transfer is best for date, timestamp, and bytea.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.bl
e, and poor redundancy
against a variety of non-total failure conditions (data corruption,
etc). Add the synchronization costs to the mix, and I don't see the appeal.
I think clustering _in general_ is becoming a big issue, but I don't
really see the appeal of shared-disk clustering personally
SET client_encoding
--
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
ight be:
CREATE DATABASE garbage
TEMPLATE template0
ENCODING 'SQL_ASCII' LC_COLLATE 'C' LC_CTYPE 'C';
but I really don't think that's generally a good idea. Storing random
crap in text fields will cause you pain later. Better to either convert
the text to a sa
On 4/03/2011 10:18 PM, Maximilian Tyrtania wrote:
Am 04.03.2011 um 11:01 schrieb Craig Ringer:
On 04/03/11 00:02, Maximilian Tyrtania wrote:
After upgrading to pg 9.0.3 (from 8.4.2) on my Mac OS 10.6.2 machine i find
this in my log file (a lot):
STATEMENT: SELECT
pg_file_read('p
ing hard shutdowns where the client code
doesn't get a chance to run any cleanup/dtors/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
tatement
that might fail, or you can use PL/PgSQL's EXCEPTION blocks.
--
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
hanks to
the birthday paradox.
--
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
p anyway.
Given that, I wouldn't think that gear is much of an obstacle.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 1/04/2011 12:38 PM, Joshua D. Drake wrote:
On Fri, 2011-04-01 at 11:37 +0800, Craig Ringer wrote:
Many people have low-end SLR or high-end fixed cameras that're really
good video cameras, they just don't know it. Many of them will have
tripods, and a basic tripod for fixed ind
on't make sense in an spi context.
--
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
to remember them and be
able to reissue them on failure. If that is not acceptable to you, then
you should look into whether READ COMMITTED isolation will offer you
sufficient guarantees and see if you can use that.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
a corefile, or whatever I can, but
> I might need some guidance, as I'm pretty new to postgres.
A backtrace would be a good start. On Ubuntu you will need to install
debuginfo packages first. For details, see:
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_back
more characters into the 64 bits rather than the 8 chars you'd get
with one byte per char. Of course, you can't do that if your strings are
in any way user-supplied or user-visible because you can't support
non-ascii charsets when doing ugly things like that.
--
Craig Ringer
Tec
Nor I. https://launchpad.net/~pitti/+archive/postgresql/+packages
doesn't seem to list any.
Martin: Are your packages stripped, or do they include minimal debug
info in the main packages? Do you put your debuginfo debs anywhere
accessible?
--
Craig Ringer
Tech-rel
respect the time of the people here who're
volunteering to help. Put together a question with enough information
for someone to actually be able to help you. Remember that urgent for
you doesn't make it urgent for anyone else.
http://wiki.postgresql.org/wiki/Guide_to_reporting_prob
On 04/07/2011 06:37 PM, Chris Curvey wrote:
2) install bison, flex and libreadline5-dev (sudo apt-get install
PACKAGE). I already had the gcc package installed
The easy way to do this on Debian/ubuntu, if you're building something
that packages exist for, is (eg):
sudo apt-get build-dep po
ib modules can cause issues and
locale names differ across OSes. I usually CREATE DATABASE then restore
into the empty database, because pg_restore may try to create a database
using a locale that doesn't exist on the target machine.
--
Craig Ringer
--
Sent via pgsql-general ma
ommit
off.
BTW, the other area to look at with this is query batching. If the
client isn't on the same host as the server or at least on a very low
latency network, it can be much more efficient to batch queries together
to minimize the number of network round trips required.
--
Craig
xactly fast or space-efficient.
--
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
lots of shared
memory, why do you want to? In any case, 2GB of shared memory wouldn't
leave you any address space for anything else important.
I wouldn't want to go above 1GB on 32-bit Windows.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via p
er them. Do consider though that the
more behind the slave is, the more log files the master has to have
space to keep... and if the master runs out of space, things get ugly.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Sent via pgsql-general mailing list (pgsql-ge
On 14/04/2011 4:35 PM, Henry C. wrote:
There is no going back. Hint: don't use cheap SSDs - cough up and use Intel.
The server-grade SLC stuff with a supercap, I hope, not the scary
consumer-oriented MLC "pray you weren't writing anything during
power-loss" devices?
-
ably going to be hard for anyone
to help. Thanks to the joy of C, it's easy to stamp all over the stack
or the heap, so all sorts of weird and wonderful things can happen in
code unrelated to the real source of the problem...
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blog
27;t you using operating system packages? And why 9.2.4?
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscr
perly. Now it's only an issue if your app also needs to use
OpenSSL, gettext, etc its self.
Thoughts?
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-ge
On 07/03/2014 05:41 PM, Dave Page wrote:
> It shouldn't be an issue for psqlODBC itself as users of that link
> against the driver manager not the driver. I suspect what Craig is
> trying to do is build the driver against our server installation, which
> means he may need OpenS
t; And not only for BDR, but also streaming replication setups, could use this
> to do automatic client failovers, in the case there is a server side failover.
>
> Anyone who knows if there is anything in progress regarding this?
Other than the limited failover already in place for PgJD
On 07/12/2014 02:24 PM, Martin Gudmundsson wrote:
>
> 12 jul 2014 kl. 04:58 skrev Craig Ringer :
>
>> PgJDBC actually already supports rudimentary client-based failover.
>
> I’ve seen some mailing list threads regarding this but was that ever
> implemented? Do you know w
sing pg_dump and
pg_restore, or by using pg_upgrade after performing a backup. Don't get
stuck on some ancient version because you didn't consider upgrades.
(Perhaps we should add a section on this to the documentation?)
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL
ndle it.
I don't know if it handles beta upgrades though.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
json to/from Java objects or manipulate json trees, while
saving them to the DB and loading them from the DB as native json fields.
If you use hstore, you'll have to write the equivalent yourself or crib
from someone else. So why not start on the right foot and go straight
for jsonb?
--
C
ication after the WAL receiver process
> has died without restarting Postgres?
PostgreSQL should do so its self.
Please show your recovery.conf (appropriately redacted) and
postgresql.conf for the replica, and complete logs for the time period
of interest. You'll want to upload the logs somewher
ique violation, but it'll still fail.
Please read the detailed guidance on this problem that already exists:
http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE
http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/
http:/
data consumed by COPY.
(A truly tricky user could sneak malicious code into a table then trick
you into running a vulnerable PL/PgSQL procedure that used unsafe
dynamic SQL later, but that's also true with calling the function using
prepared statements.)
--
Craig Ringer
e,
then one thing that comes to mind is that the bytea_output parameter in
postgresql.conf might be different on the second database.
Craig
> *The database is on an AIX server (version 6.1). **Postgres version is
> 9.1.4. *
>
> *I**’**d welcome **any** input towards the resolution of t
)
Don't write the escaping yourself.
Use a CSV library that can consume your input data and emit correct CSV.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@post
on both the 32-bit and 64-bit hosts without
problems.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://
#x27;s why we have the WAL and do periodic checkpoints. If you yank the
drive mid-write you'll lose uncommitted transactions and might have
slower startup next time around, but it should otherwise not be overly
problematic.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreS
k8 R2 or newer system - just create an account like:
NT Service\PostgreSQL$EDB-9.4-x86
(or whatever name will get rid of conflicts) and use that instead of
NETWORK SERVICE.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & S
On 09/19/2014 07:04 PM, hubert depesz lubaczewski wrote:
>
>
> for i in {1..150}; do createdb -T database_source database$i; done
Unless `datistemplate` is set for the database, you'll need to do this
as a superuser.
--
Craig Ringer http://www.2ndQuadrant.co
at the required procedural language runtime versions
are now included in "installation-notes.html" in the installer, though.
Thanks for that.
(Any thoughts on my prior question about using virtual service accounts
on Windows 7, btw?)
--
Craig Ringer http://www.2ndQuadra
_twophase, and
> pg_stat_tmp from
>the postgresql data directory. Google said to recreate the missing
> directories and indeed
>Postgresql then was able to start.
That's a truly insane thing for an updater to do for any reason. Why
would it do that?
--
Craig Ringer
o
10.9, do some tests, and upgrade to 10.10 again, please get in touch.
Especially if you use Server.app.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
can find any trace of
them after the upgrade. I believe that the Apple-provided one only
starts up by default if you've installed Server.app, but I'm not certain
of that and - again - can't easily verify it.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL
connections between PostgreSQL servers.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
about for your bdr-plugin tree?
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
at if possible.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ith the lines
around it.
If possible run with log_error_verbosity=verbose and show the extra
line(s) printed after each log line too, please.
> BDR Settings(replaced the real db name here):
> 1. on node 01, the replication src one:
>
> 2. on node 02, mostly like 03
You forgot these.
...) .
I think you'll probably want to GetBackgroundWorkerPid(...) and examine
the returned BgwHandleStatus to see if it's BGWH_STOPPED . If not, keep
waiting. You might want a timeout to re-check.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support,
und a fair bit.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
are allocated, how big the chunks
are, etc. At the moment it's all pretty fixed, and it's really suited to
systems where they're connected most of the time.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d "dbname=mydb options='-c default_sequenceam=bdr'" dumpfile
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
On 01/07/2015 09:08 PM, Craig Ringer wrote:
> You can think of it like a simple abstract base class that everything
> else extends.
Ahem. Every other parse/plan tree node, that is.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Tr
It's difficult to
follow mailing list threads where some people post at the top and some
post in-line.)
>
>
> On Jan 7, 2015, at 8:25 AM, Craig Ringer wrote:
>
>> On 01/04/2015 12:33 AM, John Casey wrote:
>> While attempting to alter a table to add a global sequence
pecific issue of finding out when a
bgworker is unregistered would fit under that.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
201 - 300 of 1923 matches
Mail list logo
