aking it rather harder to
integrate into core with a long-term vision:
https://apps.fedoraproject.org/packages/v8
Regards,
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Sep 16, 2014 at 1:43 AM, Michael Paquier
wrote:
> https://apps.fedoraproject.org/packages/v8
Forgot to add that this is probably one of the reasons why Fedora
sticks to this version.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
rows)
=# insert into aa_foreign values (1,2);
INSERT 0 1
... Will generate the following data on remote node:
=# select * from aa;
a | b | c
---+---+---
1 | 1 | 2
(1 row)
Regards,
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
It would be tempting to include parameters of pg_db_role_setting where
role setrole = 0 by default and I recall that there have been some
debate about that as well (this would roughly need to move
dumpDatabaseConfig out of pg_dumpall.c in a more generic place), but
nothing has actually been done. Note t
On Tue, Sep 16, 2014 at 10:17 AM, Daniele Varrazzo
wrote:
> On Tue, Sep 16, 2014 at 6:04 PM, Michael Paquier
> wrote:
>> On Tue, Sep 16, 2014 at 8:05 AM, Daniele Varrazzo
>> wrote:
>
>>> I'm learning now something about foreign tables in PG 9.3. I wonder i
e more adapted for a mailing list like
pgsql-general (just redirected to this mailing list) or pgsql-novice.
pgsql-hackers is made for more technical discussions about features
and existing patches.
Regards,
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
Win2k8 R2 and Win7?!) or if necessary
privileges are not present but well you are aware of that already :)
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
y)
for pg_class:
http://www.postgresql.org/docs/devel/static/release-8-4-19.html
Be careful that there may be some other corruptions elsewhere...
Regards,
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d for replicated tables, both things not that cool
for data warehouse applications, better for OLTP loads.
Regards,
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-+-
8 | 12
(1 row)
Regards,
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
clude/access/xact.h: Oid dbId;
/* MyDatabaseId */
src/include/miscadmin.h:extern PGDLLIMPORT Oid MyDatabaseId;
Regards,
--
Michael
he
> software bits so I can have postgresql started at boot time?
>
That's not surprising, this feature is deprecated in Mavericks. And launchd?
--
Michael
y if you use Server.app.
>
If there are people using a Mac with VMware Fusion, note that you can
create a VM running OSX by installing it from the recovery partition,
something useful for tests. No need to switch definitely the main machine.
--
Michael
evel = hot_standby in postgresql.conf of the master? Those are
necessary requirements to make a standby accessible for read-only
operations, which is what it seems you are looking for.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to yo
-procedure.html
--
Michael
ur server does not satisfy your needs,
shutdown the server and change the target. Note that operations are
not backward btw.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t you are comparing the results with the regression output
of a 9.4 server.
Regards,
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
uot;f","f":"g"}
(1 row)
You may prefer actually something that really merges everything, among
many methods here is one (not the fastest one, now on the top of my
mind):
=# with union_json as (
select * from json_each('{"a":"b","b"
On Thu, Nov 13, 2014 at 9:17 PM, dineshkaarthick
wrote:
> All,
>
> I need to know is it possible to execute two instances of Postgres with
> single data directory shared between the two instances.
No, a server instance cannot run on a data folder being used by an
existing instance.
target-settings.html
Aren't pg_xlog_replay_pause and pg_xlog_replay_resume what you are looking for?
http://www.postgresql.org/docs/devel/static/functions-admin.html#FUNCTIONS-RECOVERY-CONTROL
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ng around Pike Place Market with posters
> of the Postgres elephant that say "Have You Seen Me?"
>
> ;-)
Challenge for a beer: do it and post a pic here.
Note: it *has* to at Pike Place Market.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgre
I don't think you've defined your problem very clearly.
Suppose you have 1000 names in your database. Are you planning to compare
each name to the other 999 names to see which is closest? What if two
names are equally close to a third name but not to each other, how do you
decide which is better
Have you considered using a soundex function to sort names into similarity
groups? In my experience it works fairly well with Western European names,
not quite as well with names from other parts of the world. It also
doesn't deal well with many nicknames (Mike instead of Michael, etc.)
--
umGetInt64, and Int64GetDatum---I think all for bigints. Does that
> sound right? If so, would you like a documentation patch?
+1 for adding it.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have several web apps that access our Postgresql database that I'd like
to lock out of the database for about an hour during a weekly maintenance
interval. (There are some internal users that do not get locked out,
because they're running the maintenance tasks.)
There are no time-of-day access l
Yeah, a cron job to swap pg_hba.conf files is the best solution I've come
up with so far. It's not one web app, it's closer to two dozen of them, on
multiple sites.
--
Mike Nolan
On Sat, Dec 13, 2014 at 11:10 PM, Adrian Klaver
wrote:
>
> On 12/13/2014 08:13 PM, Michael Nol
be used for
connections with libpq, see for example fe-connect.c.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Dec 18, 2014 at 12:05 PM, Adrian Klaver
wrote:
> Are there any more then those listed on the libpq page and PGDATA?
>
No other PG* I am aware of.
--
Michael
on about the
WAL segments written, flushed and replayed on each slave:
http://www.postgresql.org/docs/devel/static/monitoring-stats.html#PG-STAT-REPLICATION-VIEW
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://ww
it the number of WAL files that are actually necessary.
If you care that much about WAL retention btw, consider using
replication slots with 9.4, just be careful to monitor the partition
where pg_xlog sits in.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
of this database, and wish
that I'd started using it sooner.
--
Michael Heaney
JCVI
--
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/6/2015 2:19 PM, Jeff Janes wrote:
On Tue, Jan 6, 2015 at 9:09 AM, Michael Heaney <mailto:mhea...@jcvi.org>> wrote:
I'm fairly new to Postgres, and have a design issue for which an
array of integers might be a good solution. But I'd like to hear
from
ludes at the top of Mkvcbuild.pm. All the
contrib modules listed there will be ignored at build and install, so
just update it according to your needs if you want to ignore one thing
or another, including any custom thing you may have copied in the code
tree.
--
Michael
--
Sent via pgsql-general
1 tests, aren't you using some fork?
> Maybe some contrib modules are absolutely needed?
Yes, some are: spi/ for autoinc.dll, dummy_seclabel/ for dummy_seclabel.dll.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ht
I'm running 9.3.5 on a virtual machine with 5 cores and 24 GB of
memory. Disk is on a SAN.
I have a task that runs weekly that processes possibly as many as 120
months worth of data, one month at a time. Since moving to 9.3.5
(from 8.2!!) the average time for a month has been 3 minutes or less.
ell if your goal is to implement your own
receiver.
In any case, the documentation provides some examples:
http://www.postgresql.org/docs/current/static/logicaldecoding-example.html
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscri
data so it'll be an even longer run than
this week's was.)
--
Mike Nolan
On Sat, Jan 10, 2015 at 12:55 PM, Andy Colson wrote:
> On 01/09/2015 07:52 PM, Tomas Vondra wrote:
>
>> On 9.1.2015 23:14, Michael Nolan wrote:
>>
>>> I'm running 9.3.5 on a virtual m
On Fri, Jan 9, 2015 at 7:52 PM, Tomas Vondra
wrote:
> On 9.1.2015 23:14, Michael Nolan wrote:
> > I'm running 9.3.5 on a virtual machine with 5 cores and 24 GB of
> > memory. Disk is on a SAN.
> >
> > I have a task that runs weekly that processes possibly as many
to parse
my $pgcrypto = $solution->AddProject('pgcrypto','dll','crypto');
[blah]
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t; START_REPLICATION.
That's confusing btw, I am pushing a fix with more details.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, Jan 10, 2015 at 8:54 PM, Melvin Davidson
wrote:
> Just curious. Have you checked that the tables are being vacuum/analyzed
> periodically and that the statistics are up to date? Try running the
> following query to verify:
>
>
A vacuum analyze runs every night and there would not have bee
On Mon, Jan 12, 2015 at 7:46 PM, Bob Futrelle
wrote:
> You should be able to find a cloud provider that could give you many TB.
> Or so they like to claim.
>
>
> Nope, but you probably find one willing to SELL you access to many TB.
--
Mike Nolan
For what it's worth, this week's run covered even more months than
last week's did, and ran in about 5 1/2 hours, with no slowdowns,
under a similar system load. So, it could have been a one-time thing
or some combination of factors that will be difficult to reproduce.
--
Mike Nolan
--
Sent via
E as mentioned by Tom.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
discussion I recall on the matter being this one:
http://www.postgresql.org/message-id/capphfdsxwzmojm6dx+tjnpyk27kt4o7ri6x_4oswcbyu1rm...@mail.gmail.com
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.
Oleg Bartunov wrote:
> We are eager for development of this API.
Yeah, me too actually :) Oleg, are there plans on your side to do
something in this area for 9.6?
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
On Thu, Jan 22, 2015 at 11:06 PM, Andrey Lizenko wrote:
>> 3. They are not WAL-logged.
> Whats wrong with it in my case?
Nothing. Temporary tables are not WAL-logged, but transaction commit is.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
and +1
Yes, embedded with CREATE TABLE AS:
=# create table test as select a % 2 + 1 from generate_series(1,100) as a;
SELECT 100
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
gt; callbacks are receiving? Apologies if it is staring me in the face and I've
> missed it...
I think that you are looking for GetUserNameFromId(GetUserId()) from
miscadmin.h.
Regards,
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
tgresql metrics? Thanks.
Take a look at PoWA:
http://dalibo.github.io/powa/
I've downloaded but haven't installed it yet, so can't give you any
feedback on its performance or usability.
--
Michael Heaney
JCVI
formation
containing a set of C functions to operate on arrays. You may as well
look at contrib/intarray for some inspiration.
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Jan 29, 2015 at 9:36 PM, Quirin Hamp wrote:
> Please remove me from mailing list. I have deleted my account from pgsql
> forum and I still get emails!
>
Here is an entry point to DIY:
http://www.postgresql.org/community/lists/subscribe/
--
Michael
ndby.html#SYNCHRONOUS-REPLICATION
With the upcoming 9.5, pg_receivexlog provides an option --synchronous
to issue sync commands as soon as there is WAL information available.
I think that this would be what you are looking for, but you will need
to wait until 9.5 is out.
--
Michael
--
Sent via pgsql-gene
Might not do what you want, but I just change the password.
--
Mike Nolan
On Fri, Feb 6, 2015 at 4:11 PM, Melvin Davidson
wrote:
> Possibly,
>
> To disble:
> ALTER USER name RENAME TO xname;
>
> To enable
> ALTER USER xname RENAME TO name;
>
> ???
>
>
> On Fri, Feb 6, 2015 at 3:57 PM, Felipe Gas
On 2/6/15, David G Johnston wrote:
> On Fri, Feb 6, 2015 at 2:22 PM, Michael Nolan [via PostgreSQL] <
> ml-node+s1045698n5836989...@n5.nabble.com> wrote:
>
>> Might not do what you want, but I just change the password.
>>
>>
> How do you do that and r
master, you may as well
rewind it with pg_rewind if WAL forked (assuming that page checksum is
enabled for 9.3~ or that wal_log_hints is enabled in 9.4~).
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
:
DEBUG: received replication command: IDENTIFY_SYSTEM
DEBUG: received replication command: START_REPLICATION SLOT "slot" LOGICAL 0/0
LOG: called startup_cb_wrapper
Note that on 9.5 (master HEAD at c619c23) I am seeing an assertion
failure. What is the server version you are using? I w
On Tue, Feb 10, 2015 at 5:59 PM, Andres Freund
wrote:
> On 2015-02-10 11:01:08 +0900, Michael Paquier wrote:
>> Just in case, I have just done a quick test with pg_recvlogical on
>> latest HEAD of REL9_4_STABLE and the startup_cb gets called:
>> DEBUG: receive
hey guys, I'm kinda new to Postgres and I'm learning it now. I have work to
convert some stored procedures in MySQL to Postgres and I came across an
issue here that I can't solve:
update db.user
set Deleted= 1
, UpdateTerminal = @UpdateTerminal
, Upda
hey, guys, I came across a merge statement when I'm trying to convert
stored procedures from Mysql to Postgres:
merge into db.ChargePeriod d
using (
select ba.ClientID
, ba.BillingAccountID
, bs.BillingScheduleID
, @CodeWithholdD as WithholdTypeID
from
en requesting remote servers.
--
Michael
--
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/8/13, Gavan Schneider wrote:
> 2. SELECT ... WHERE
> '2011-01-01'::TIMESTAMP <= col_of_type_timestamp
> ANDcol_of_type_timestamp <=
> '2011-12-31'::TIMESTAMP;
This won't quite work, because '2011-12-31'::TIMESTAMP
is the same as 2011-12-31 00:00:0
It is probably not the most efficient, but I often use this syntax,
which reads better.
Select . where col_type_timestamp::date between '2011-01-01' and
'2011-12-31'
This will use a timestamp index.
--
Mike Nolan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Hi All,
We are having a thorny problem I'm hoping someone will be able to help with.
We have a pair of machines set up as an active / hot SB pair. The database they
contain is quite large - approx. 9TB. They were working fine on 9.1, and we
recently upgraded the active DB to 9.2.1.
After upgra
On Tue, Feb 5, 2013 at 1:57 PM, Scott Mead wrote:
>
>
> I would love to see pgpass storing encrypted stuff here, that'd be
> great... in the meantime...
>
>
I would suggest going one step further, and making encrypted pgpass
authorization something that has to be specifically enabled in pg_hba.co
Hi Hari,
Thanks for the tip. We tried applying that patch, however the error recurred
exactly as before.
Regards // Mike
-Original Message-
From: Hari Babu [mailto:haribabu.ko...@huawei.com]
Sent: Tuesday, 5 February 2013 10:07 PM
To: Michael Harris; pgsql-general@postgresql.org
x27;t
work then we may try using rsync instead.
We'll let you all know the result.
Regards // Mike
-Original Message-
From: Magnus Hagander [mailto:mag...@hagander.net]
Sent: Thursday, 7 February 2013 11:49 PM
To: amutu
Cc: Michael Harris; pgsql-general@postgresql.org; Hari Babu
S
I believe that most of the people in this project do the same.
Doing that is particularly helpful when you want to merge PG code directly
in XC or when you need to have a look at the code diffs between both
projects.
--
Michael
Hi,
>> Also, we can see that 9.2.3 has been released now and has a number of fixes
>> relating to WAL replay, so we have decided to try again using that.
>> We will scrub the standby and make a fresh copy using pg_basebackup. If that
>> doesn't work then we may try using rsync instead.
I am pl
test version 1.0 released last year in June lacks of a couple of
features widely used these days like returning or triggers, but the team is
working hard in implementing that for 1.1 planned for April-June this year
with many other things.
--
Michael
what you see.
Does the error happen when connecting directly to a Datanode?
--
Michael
On 03/01/2013 02:31 AM, Albe Laurenz wrote:
> JD Wong wrote:
Hi Adrian, yes I completely copied the config-file and data directories
over.
>
>>> That's guaranteed to break everything badly.
>
>> Even if I "read only style" copied the files? Do you mind elaborating on why
>> this ha
I'm running into this exact situation:
http://www.postgresql.org/message-id/CAG1_KcBFM0e2buUG=o7ojq_ktadrzdgd45ju7gke3duz0sz...@mail.gmail.com
We really need to be able to have a group of developers who can create
things and modify each others' stuff[1]. Is it still more or less
impossible?
The
On 03/20/2013 04:12 PM, Alvaro Herrera wrote:
> Michael Orlitzky wrote:
>> I'm running into this exact situation:
>>
>> http://www.postgresql.org/message-id/CAG1_KcBFM0e2buUG=o7ojq_ktadrzdgd45ju7gke3duz0sz...@mail.gmail.com
>>
>> We really need to be able
On 03/20/2013 05:18 PM, Rob Sargent wrote:
> What's your process? First I've heard of a group of dev's ignorant of
> permission _and_ trusted to change things in a db which affect others.
It's a playground for a group of people. They want to be able to create
stuff, and then modify that stuff. N
On 03/20/2013 06:40 PM, Adrian Klaver wrote:
> On 03/20/2013 03:26 PM, Michael Orlitzky wrote:
>> On 03/20/2013 05:18 PM, Rob Sargent wrote:
>
>>
>> At the moment, everyone's just experimenting. Even with the proper
>> tooling, my blog app shouldn't
On 03/20/2013 08:05 PM, Adrian Klaver wrote:
>>
>> Now everything in the database will be owned by dev_user. But what
>> happens if we have 100 databases (this is realistic for us), and add a
>> new developer a year down the road? I have to not only add him to
>> dev_user, but look through each dat
On 03/21/2013 10:39 AM, Adrian Klaver wrote:
>>
>> This won't fly unfortunately. It's a shared host, and the "developers"
>> are a mixed bag of our employees, consultants, and the customer's employees.
>
> Do not follow. The set role= is put on a login role. It will only work
> on those databases
On 03/21/2013 11:34 AM, Adrian Klaver wrote:
> On 03/21/2013 07:52 AM, Michael Orlitzky wrote:
>> On 03/21/2013 10:39 AM, Adrian Klaver wrote:
>>>>
>>>> This won't fly unfortunately. It's a shared host, and the "developers"
>>>>
bles are a subtype of unlogged tables, as temporary tables are
not WAL-logged.
This article from Robert Haas will give a good summary of such differences:
http://rhaas.blogspot.jp/2010/05/global-temporary-and-unlogged-tables.html
--
Michael
On 3/27/13, Steve Crawford wrote:
> Somewhat more worrisome is the fact that it automatically rounds input
> (away from zero) to fit.
>
> select '123.456789'::money;
>money
> -
> $123.46
So does casting to an integer:
select 1.25::integer
;
int4
1
And then there's this:
>
> there is no 'cron' built into postgresql. you could write your function,
> then have an external cron job invoke it, like: psql -c "select
> yourfunction()"
>
Note also that if you are planning some development with the coming release
9.3, you could also achieve that inside the server by using a custom
bgworker.
--
Michael
this route
> before. Any tips, tricks, failures, successes, etc.? I would just like to
> hear some first-hand commentary on this topic.
>
Here is a tool that can be used to migrate an Oracle DB into a Postgres DB:
https://github.com/darold/ora2pg
Hope it is useful.
--
Michael
).
> >
> > What is best way to decrease CPU usage of this process?
>
> Do you by any chance have a large number of databases, and/or a large
> number of objects in your databases (tables or indexes)?
>
Could you output the result of this query?
SELECT count(*) FROM pg_class;
--
Michael
.3 and 9.3. Materialized views have
just been implemented and will be available in postgres 9.3 whose release
is planned this year.
For your example. documentation is your friend:
http://www.postgresql.org/docs/devel/static/sql-creatematerializedview.html
--
Michael
omplicate your database schema.
--
Michael
rts of a query plan :
http://explain.depesz.com/
This is perhaps more simple than visualizing raw ANALYZE output, and it
will help you to catch what are the tables needing indexing, or perhaps
partial indexing.
--
Michael
On 4/17/13, Scott Marlowe wrote:
> My experience, doing production and dev dba work on both postgresql
> and oracle, is that either works well, as long as you partition
> properly or even break things into silos. Oracle isn't magic pixie
> dust that suddenly gets hardware with 250MB/s seq read arr
p this from
happening? I'm not really in the position to have different users for
the modification of the table_list and the drops so I don't think I can
use different roles.
I'm pretty sure I can't do what I need as postgres doesn't support
triggers on DDL but may
te the index after a crash as the
data of
the normal table is still here, what would impact the performance boot of
the server.
Do you have a particular use-case in mind? I cannot see advantages directly
advantages in having an unlogged index on a logged table...
Regards,
--
Michael
On 5/11/13, Moshe Jacobson wrote:
> I have a master database cluster on one server, and it is configured to
> ship logs via scp to an archive directory on my slave server. The slave
> server is configured for streaming replication, and also is configured to
> delete the archived xlogs when they ar
--
> idx_tup_fetch,
> n_tup_hot_upd,
> n_live_tup,
> n_dead_tup
>
pg_stat_user_tables is similar to pg_stat_all_tables, except that it
contains only user tables:
http://www.postgresql.org/docs/9.2/static/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW
Thanks,
--
Michael
On Tue, May 28, 2013 at 12:25 AM, wrote:
> Thank you Wolfgang, just one question, what "bio" means? In the part that
> says "69 bio EUR..."
>
In this case, billions.
--
Michael
need to set wal_keep_segments to a value high enough on
master such as the slave can can up. For reference:
http://www.postgresql.org/docs/9.2/static/runtime-config-replication.html
--
Michael
erything I was supposed to do.
>
Playing with recovery.done has no effect on the promotion. Perhaps some
issue with the layer used for automatic settings?
--
Michael
rchive after failing to get it through
streaming replication?
More details at paragraph "Standby Server Operation" here:
http://www.postgresql.org/docs/9.2/static/warm-standby.html
--
Michael
consumption:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=b0fc0df9364d2d2d17c0162cf3b8b59f6cb09f67
This single commit has removed years of pain for many users.
--
Michael
.2/static/datatype-json.html
http://www.postgresql.org/docs/9.2/static/functions-json.html
Note that 9.3 has far more features related to json:
http://www.postgresql.org/docs/9.3/static/functions-json.html
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
Hi pg devs, fellow pg users
I'm Michael, and this is my first post here.
I asked this question last night:
http://dba.stackexchange.com/questions/45077
which details the problem (or not?) I'm having. The gist of it is that Postgres
is not archiving the first WAL segments for
I have a table called jobs with ~17 millions records. Without an index on
the queue column, the following query
select count(*) from jobs where lower(queue) = 'normal'
found ~2.6 millions records in 10160ms
With the following index:
create index lower_queue on jobs (lower(queue))
th
701 - 800 of 3411 matches
Mail list logo
