use a restart. I run upgrades
> without any applications running so I don't know exactly what could
> happen when using unattended upgrades.
>
libpq does get upgraded, but it does not cause restarts. A restart of a
client application using libpq must be done manually by the administrator
(unless there is specific code in the client application or it's packaging
to deal with that).
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
n?
Certainly. Unrelated to PostgreSQL, this is a standard feature in Debian.
Commonly used to prevent things like kernel upgrades from happening on the
same schedule as others.
Basically, you put the package "on hold". See the debian administratino
guide at
https://debian-administrati
On Wed, Sep 20, 2017 at 10:02 AM, Nicklas Avén
wrote:
> On Wed, 2017-09-20 at 09:44 +0200, Magnus Hagander wrote:
>
> On Wed, Sep 20, 2017 at 8:53 AM, Nicklas Avén
> wrote:
>
> Hallo all
>
> I am thrilled about logical replication in PostgreSQL 10. My head have
>
On Wed, Sep 20, 2017 at 8:53 AM, Nicklas Avén
wrote:
> Hallo all
>
> I am thrilled about logical replication in PostgreSQL 10. My head have
> started spinning about use cases.
>
> Would it be possible to use logical replication as a distribution
> method of data?
>
As an answer to the generic q
is it something where I need to
> pick one way to do it?
>
This looks like you are trying to connect with the actual username
user1¡A.DOMAIN.TLD. pg_ident only sets what you are allowed to log in as,
not what it will attempt.
If you are using psql, you are probably doing something like "psql -h
myserver". You need to add the user, so "psql -h myserver -U user1", to
instruct it of which username to actually use for the login.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
really mention that in the docs. What do others
> think?
>
If the documentation is missing such a clearly critical step, then I would
say that's a definite documentation bug and it needs to be fixed. We can't
really fault people for missing a small detail if we didn't
(I think) SSL_get_peer_certificate() to get at it.
(this is what libpq does and stores it in ->peer, but that's a private api.
But you can see be-secure-openssl.c for some examples)
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
> This seems to be new with 10. I recently began testing the
> pacemaker resource agent against PG 10. I never had (or noticed) this
> failure with 9.6.1 and 9.6.2.
>
Hah, that's an interesting failure. In the name of the slot, the 2194 comes
from the pid -- but it's the pid o
present.
But it should perhaps be more clearly documented somewhere.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
e latin9 encoding, and then do a second
migratino which changes the encoding from 9.6 w latin9 to 9.6 w utf8. That
way you can get access to the newer tools such as pglogical to help you do
that.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
with wsock32.lib...
>
I suggest you try building it with the supported method (the msvc build
system in src/tools/msvc), and then inspect the difference.
You can also look up those references in the Microsoft docs (for each API
function there is a listing at the bottom of the page tell
On Thu, May 4, 2017 at 7:32 PM, John R Pierce wrote:
> On 5/4/2017 2:19 AM, Magnus Hagander wrote:
>
> On Wed, May 3, 2017 at 11:31 PM, John R Pierce
> wrote:
>
>> On 5/3/2017 2:20 PM, Magnus Hagander wrote:
>>
>>>
>>> Please note that this m
On Thu, May 4, 2017 at 12:06 AM, Igor Korot wrote:
>
> On Wed, May 3, 2017 at 5:20 PM, Magnus Hagander
> wrote:
> > On Tue, May 2, 2017 at 4:49 AM, Igor Korot wrote:
> >>
> >> John,
> >>
> >> On Mon, May 1, 2017 at 9:38 PM, John R Pierce
&g
On Wed, May 3, 2017 at 11:31 PM, John R Pierce wrote:
> On 5/3/2017 2:20 PM, Magnus Hagander wrote:
>
>>
>> Please note that this method of building libpq has been removed from
>> Postgres 10, so it's considered to be deprecated for quite some time.
>>
>&g
Postgres 10, so it's considered to be deprecated for quite some time.
> Is there a way to build a Debug version of the libraries?
> I'm building my app in Debug mode right now and prefer not to mix the
> libraries.
> Especially since I know Debug and Release version with MSVC li
the selinux docs for how to figure out what
is wrong and probably use restorecon to get things back in order.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
ht be able to make upstream
> changes to remove the need for others.
>
That'd be useful. I think you should also include Devrim to figure out what
things would actually make *both* sides happier.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
ers who *are* willing to do that, and
they make that platform work. So I'm very grateful for those people doing
it, even better that it's not me.
And also, if somebody wants to take another stab at trying to make web
forums for PostgreSQL, I say let them try. I don't think it would work, but
I'd be happy to be proven wrong.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Wed, Apr 5, 2017 at 6:31 PM, Adrian Klaver
wrote:
> On 04/05/2017 09:17 AM, Magnus Hagander wrote:
>
>
>> This has been tried a number of times. I'ts been a couple of years since
>> I last saw one, but multiple people have set up forums, either mirrored
>> or
n, but in the previous attempts it
certainly hasn't been "many users". It could be that whomever set them up
did a bad job of course, I can't judge that as I didn't personally use them
more than take a look every now and then.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
ite unlikely that it would hit somebody, but the risk is
there. And people generally auto-upgrade to the latest minor releases,
whereas they at least in theory read the top of the release notes when
doing a major upgrade (ok, most people probably don't, but at least some
do).
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Thu, Mar 23, 2017 at 7:57 AM, Charles Clavadetscher <
clavadetsc...@swisspug.org> wrote:
> Hello
>
> I would like to upload the slides of my presentation at Nordic PGDay
> 2017. Could you please grant me edit privilege on the wiki?
>
> My user name is cclavadetscher
&g
On Feb 17, 2017 06:53, "John R Pierce" wrote:
On 2/16/2017 9:43 PM, Magnus Hagander wrote:
>
Perhaps something like "COPY FROM PROGRAM 'cat /path/*.csv'" would work for
you?
he's using HEADER, so cat wouldn't work.he's also using MSDOS/WIn
> ..
> ..
> COPY prdxgdat FROM 'Z:/data-2016-04-50.csv' WITH DELIMITER ',' CSV HEADER Y
>
> 50 files -> 50 COPY command, In my use case I think this is not a good way
> to load data, Can you suggest any better way to do this?
>
> I can always write e
y and starts PG. If I shut
> it down and copy the old data directory into the newly installed one, will
> there be an xlog issue?
>
You have to copy the xlog along with the database.
Or if you leave it in place where it is, the packages won't initialize a
new data directory.
-
to be from
postgresql-9.4-client though -- have you actually by mistake uninstalled
the server package completely?
As in, that directory is supposed to have the "postgres" binary which is
the database server and it's not there. So there is no wonder it's not
starting...
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
use pg_ctl as the postgres user? That will give you a better
> idea.
You don't want ot be doing that on a systemd system, but try a combination
of pg_lsclusters and pg_ctlcluster. Might be you need to shut it down once
that way before it realizes it's down,and then start it
you should really
upgrade that to something that doesn't have loads of known bugs and then
re-run the tests.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
nly potential problem. If you are
willing to spend towards it, it would probably be better to spend towards
the "upper layer" problem which would be to make it possible to move
pg_largeobject to a different tablespace *without* turning on
system_table_mods.
That said, I cannot comment to the complexity of either doing that *or*
doing a custom pg_upgrade that would support it. But solving a long-term
problem seems better than solving a one-off one.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Wed, Oct 5, 2016 at 3:55 PM, otheus uibk wrote:
>
>
> On Tue, Oct 4, 2016 at 10:49 PM, Magnus Hagander
> wrote:
>
>>
>>
>> On Tue, Oct 4, 2016 at 10:42 PM, otheus uibk
>> wrote:
>>
>>> After a 3 to 4 minute delay, pg_basebackup started
hich make it
take time. Try with "-c fast" and see if the problem goes away.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
wouldn't accept a patch for that
functionality.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
ig issues we've had with ipv6 routing recently.
It should be back up now.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Mar 22, 2016 6:14 PM, "Frits Jalvingh" wrote:
>
> Hello list,
>
> Oracle has a way to get per-session statistics. You identify a session
using a call to dbms_session.set_identifier('xxx'), then you enable
statistics using dbms_monitor.client_id_stat_enable('xxx').
> After this you do normal dat
0 (and it shows nothing).
>
That looks like a kernel issue/bug. Both because the log comes from the
kernel, and because PostgeSQL can't actually take down the whole PC as long
as the kernel is working properly.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
ral email, it doesn't have any shortcut) does not contain this address
naywhere, it was only used as an envelope sender. Possibly it got confused
by the other VERP address in the initial email, which AFAICT is a manual
mistake.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Mar 2, 2016 06:01, "John R Pierce" wrote:
>
> (thread moved from pg_bugs)
> (upgrading a 8.0.13 database on Windows XP 32bit to 9.5.1 on Windows 8 64
bit.)
>
>
> On 3/1/2016 8:05 PM, Premsun Choltanwanich wrote:
>>
>> Modified command by remove -Ft flag as per you suggestion:
>> pg_dump -v
ago and doesn't actually exist
anymore.
(The advanced servers version does of course, but that's not open source).
I think the only "Plus" product now is their cloud offering?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Fri, Jan 22, 2016 at 8:37 PM, David E. Wheeler
wrote:
> On Jan 22, 2016, at 11:28 AM, Magnus Hagander wrote:
>
> > Regardless whether it's true or not (to which I cannot speak), surely
> statements like that would violate *both* the contributor covenant *and*
> the
suggested by others.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Dec 21, 2015 08:58, "james garner" wrote:
>
> Dear list,
>
> i'm running PgSQL 9.3 on Debian installed from the Debian packets.
> I'm using dblink to access a different database.
> When im trying to connect to the database by socket via
> dblink_exec('dbname=test host=/var/run/postgresql' ..
>
rom a libpq perspective ,the replication standby is "just
another client", so any parameters that work for libpq should work there.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Nov 29, 2015 18:34, "George Neuner" wrote:
>
> On Sun, 29 Nov 2015 05:04:42 -0500, "Steve Petrie, P.Eng."
> wrote:
>
> >"George Neuner" wrote in message
> >news:kaed5btl92qr4v8ndevlgtv0f28qaae...@4ax.com...
> >
> >> My vote for an email client would be Thunderbird. It runs on XP or
> >> high
On Jun 12, 2015 1:33 PM, "Albe Laurenz" wrote:
>
> Birta Levente wrote:
> > In the postgresql yum repo appeared the 9.3.9 and 9.4.4, but on the
> > postgresql.org nothing about the new version. Where I can see the
changelog?
>
> AFAIK, it is being packaged and will be announced soon.
The rpm pack
y id;
>
>
There is no "id" column in the returned dataset to order by. You are just
returning one value, how would it be ordered? (and that row has a column
named "count" - but you can alias it to SELECT count(distinct id) AS id
FROM bg ORDER BY id - it just makes no sense to order a single row..
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
ith start/stop backups etc).
You can't upgrade the standbys and have them re-join the master, they have
to be redone from scratch.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
dexable with gist or spgist. I don't think the docs cover the actual
implementation internals though - you'll probably have to go to the source
if you need that.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
a LIKE matching on a string,
but if the application is trivial enough not to use that, it's certainly
doable. But all the security issues are 100% within the application itself.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
in the connection string (or in an
environment variable, or however you end up specifying it).
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
There's been a few reports on this now. Perhaps we should add a note to the
docs (not necessarily saying how to fix it, as it may differ, but a note
saying that many distributions changed the way this is handled and that you
might need to set an external override)?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Mon, Nov 10, 2014 at 8:53 PM, John R Pierce wrote:
> On 11/10/2014 11:13 AM, Magnus Hagander wrote:
>>
>> Then it's more logical. Nabble simply did not include that when the
>> email was posted. I would call that either a bug or at least a
>> limitation in Nabbl
t include that when the
email was posted. I would call that either a bug or at least a
limitation in Nabble - I think only they can figure out what's wrong
and if it's fixable. Until then, we'll have to recommend people just
post plaintext from there (which seems to work) or use a mo
e-mail but since I could read the
> problem areas the question is why other e-mail clients aren't seeing them...
I'd be more interested in how *you* could see them - unless you are
just referring to seeing them on nabble.com?
The original as delivered through the mailinglist is in it&#
conf.eu last week, and struggling under
backlogs. But as Stephen says, the backlog will eventually get worked
through, and the moderation happen.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
It's on http://www.postgresql.org/, click the link that says "Submit news".
//Magnus
On Tue, Oct 14, 2014 at 11:55 AM, Jonathan Neve wrote:
> Sorry for being a bit dense, but where should I submit a website news
> posting ?
>
> Le mardi 14 octobre 2014 11:45:5
primarily for website news postings - but a website news
postign is really what you should do with it, rather than post it to a
mailinglist. So I suggest a look at those rules and then a website
news submission that follows them.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http
by the operating system and nothing is
bundled by PostgreSQL. If you installed manually from source, for example,
then of course you need to make sure that your updated openssl is
compatible with the old one.
//Magnus
> Thanks
> V.S.Saravanan
>
>
> On Thu, Jun 12, 2014 at 7
tunately they don't seem to have information about the updates yet - I
will see if i can ping them about making sure that goes on there. I think
they have already patched it - but it's not confirmed on the website.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
com/openssl-fixes-another-severe-vulnerability-7000030253/
>
> Currently in PostgreSQL 9.4.3 the version is as follows: OpenSSL 1.0.1g 7
> Apr 2014
>
> As per the above link, fixed OpenSSL version would be 1.0.1h
>
> Looking forward for some comments here.
>
>
Hi!
The guys at EnterpriseDB are busy building new installers as we speak, I
would expect them to be out tomorrow or so.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
ion which occurs to me is using pg_xlogdump contrib. Has anyone
> tried something similar?
>
>
We do not support recovering just one tablespace. You have to recover the
whole database.
(I see that you are using EnterpriseDB's propietary version based on the
paths, but I don't b
On Wed, May 14, 2014 at 11:48 AM, Jürgen Fuchsberger <
juergen.fuchsber...@uni-graz.at> wrote:
>
>
> On 05/14/2014 09:10 AM, Magnus Hagander wrote:
> > On Wed, May 14, 2014 at 8:35 AM, Stephan Fabel > <mailto:sfa...@hawaii.edu>> wrote:
> >
> > I
gt;
>> Unfortunately I did not find what error code -1 means.
>>
>> Ldapsearch works fine:
>> > ldapsearch -W -H ldaps://wegc24.uni-graz.at:636/ -D
>> "CN=nss,DC=uni-graz,DC=at"
>>
>> Interesting is also, that postgres seems to not even reach the ldap
>> server: If I change parameter ldapserver to a non-existing url it gives
>> the same error code -1.
>>
>> Any help much appreciated!
>>
>> Best,
>> Juergen
>>
>>
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
ics back that you want. Some quick googling shows several examples of
how to monitor with custom SQL queries, but I don't know enough (or
anything) about SCOM to recommend any of them in particular.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
the docs are
wrong.
Deferrable unique constraints are a new feature in PostgreSQL 9.0, so it
shouldn't be working in 8.4.
(And as a sidenote, a reminder that 8.4 will go end of life in just a
couple of months, so if you aren't already planning an upgrade of your
production environment
l already be
covered there, and there's also an unconference day that is open for any
topic.
See http://www.pgcon.org/2014/.
No, it's not in the Columbia area (any of them), but on the other hand,
there will be experts from all over the world there.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
workaround is to make sure something happens on the master and
do a checkpoint.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Tue, Feb 18, 2014 at 6:07 PM, Purdon wrote:
> It seems that pgfoundry.org is down? Is this the case for everyone?
>
According to http://www.downforeveryoneorjustme.com/pgfoundry.org it is,
yeah.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
t; backup?
>
For the slave, yes. The master is perfectly fine, so you don't need to do
anything about that one. The errors are listed in the master log because
they are caused by commands sent from the slave, but they do not indicate a
problem on the master.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
to issue a fast checkpoint instead of the default one. Just
add "-c fast" to the commandline options. There should never be a need to
run a manual checkpoint.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Jan 15, 2014 12:07 PM, "Sameer Kumar" wrote:
>>
>> The error you are seeing is triggered because this relation file
>> exceeds MAX_TAR_MEMBER_FILELEN or 8GB for a single tar member, which
>> is as well the norm for tar.
>
>
> I thought PostgreSQL would break the file if it grows beyond 1GB (1GB
d it should clearly tell you
that. It should also tell you if you can safely cancel the pg_stop_backup()
command.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
e next release, since
that's going to be another LTS. There's been talk about changing the way
the logging is done in the debian packages in general, that might also be
part of the solution.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
id, even with that it shouldn't grow
*that* large, unless you've go a huge number of tables. Certainly not into
gigabyte range. So it could be that it's just the first indicator that
fires, but that there's actually something else using up your space. But
setting stats_temp_directory is a good first way to find that out.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
ig array, or one array of keys and one
array of values).
Also, it seems there's no length or size function for hstore? This is what
> I've got working now array_length(akeys(s.hstore_field), 1). It seems to
> be a rather long way to do it, but it works.
That I don't think there is one, no.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
>
> > "postgres", and Npgsql is specifying "POSTGRES", but I also at some point
> > configured two sets of SPNs on the domain for uppercase and lowercase, so
> > I don't know if that's a mitigating factor.
>
> The client gets its service
s,
and at least for me, this has always been enough. If your LDAP server,
or user provisioning system for that one, has some sort of trigger
functionality, you can make it "almost synchronous" as well.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t was closed,
whereas postgres waited for the timeout (but probably would've noticed
if it had actually had some other data to send maybe?). Do you have
some iptables connection tracking or something like that which could
be interfering?
--
Magnus Hagander
Me: http://www.hagander.ne
d a list of his contributions at:
http://git.postgresql.org/gitweb/?p=postgresql.git&a=search&h=HEAD&st=author&s=julian
Not sure if there might be others as well that he didn't commit
himself, but back in the days I think he mostly did.
--
Magnus Hagander
Me: http://www.hag
t means, and that's one
reason it has been deprecated since at least 8.2.
requiressl=0 means "negotiate. use ssl if the server asks for it, but
accept not using ssl". So this will connect without an error both with
and without ssl.
If you want to enforce ssl, use sslmode=require.
I
fix your server not to send
broken referrals ;)
But I can see how it could perhaps still be useful to be able to block
referrals. I think the reason it's not in there already is mainly that it
doesn't make much sense for the actual login bind - but it does make more
sense for the search s
r
--maintenance-db, but tat was added in 9.2 only. But even so, createdb
must connect to an *existing* database in order to issue the CREATE
DATABASE command, so you need a line in .pgpass for whichever
maintenance db you're using.
(also, you should really upgrade to 9.0.13, though that won
ckup functions also set internal state in the database, so you can't
just replace it with doing those operations manually. You do need to call
those functions.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
of the traffic between the ldap server and
postgres, to see how far it gets at all - that's usually a good pointer
when it comes to timeouts.
Also, what version of postgres (looks from the names that this might be edb
advanced server and not actually postgres? In that case you might be better
off talking to the EDB people - they may have made some modifications to
the ldap code perhaps)?
What OS?
Versions?
What ldap client and version?
What ldap server?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
behind that it can't recover.
It may definitely be something that needs to be cleared up in the
documentation though.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.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 Thu, Apr 18, 2013 at 10:37 AM, Eduardo Morras wrote:
> On Thu, 18 Apr 2013 10:33:20 +0200
> Magnus Hagander wrote:
>
>> On Thu, Apr 18, 2013 at 10:31 AM, Eduardo Morras wrote:
>> >
>> >
>> > I get Godaddy's page saying it's free
>>
&
On Thu, Apr 18, 2013 at 10:31 AM, Eduardo Morras wrote:
>
>
> I get Godaddy's page saying it's free
Really?
Whois shows it expires Oct 21 - and surely it will be renewed by then.
and godaddy says it's registered (though no details).
Any chance you just spelled it wron
o provide you with the "social coding"
stuff or whatever they call it (their forking/pull request/whatnot
stuff) if you like it - but you can also just use it as a pure git
repo if you prefer.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent v
any chance have a large number of databases, and/or a large
number of objects in your databases (tables or indexes)?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
implicit casts - it's
listed as the very first point under migration to 8.3 back in the old
release notes (which can still be found as a chapter in the 9.2
release notes for example, even though 8.3 is fully unsupported by
now)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http:/
or Postgresql 8.3 + PostGIS 1.5
Also, do note that PostgreSQL 8.3 is no longer supported - see
http://www.postgresql.org/support/versioning/. You should look into
upgrading ASAP.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pg
pilers from MS, but thta will
at this point require you to manually set up a project file in Visual
Studio Express - but for something as simple as an FDW, that shouldn't
be every hard.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-gene
s". Or you
had manually specified SQL_ASCII in the 8.4 method. SQL_ASCII
basically means "don't care at all about encodings".
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
f a database, but you can use a
different one when you create it - this can be specified in the CREATE
DATABASE statement.
You can also ask pg_dump to use a specific encoding using the -E
parameter. You can't do it on pg_dumpall, but you can do it if you use
pg_dump.
--
Magnus Haga
ong, and end up with data corruption. If you don't know exactly what
to do there, I would definitely advice you not to try it.
And don't even consider it without a high-end dedicated filer as the backend.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro
be
worth trying that one. If you can show that the problem is in
pg_basebackup, that's a very clear bug (either in pg_basebackup or in
the backend supporting code), so that would be good to know.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
of the developers. It worked this time, but that's
better for next time.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
suppose that if I set
> more than 1 second, it could accumulate a bunch of wal files and send it at
> once. So, it wouldn't work.
No, there is no such parameter. You might be able to send it through
some proxy that slows it down, but there is no builtin support to do
that.
--
Magnus Haga
On Jan 21, 2013 7:17 AM, "bhanu udaya" wrote:
>
>
> Hello,
> Greetings !
> Thank you for the prompt reply. I have changed the settings as listed
below:
> > > shared_buffers = 1024MB
> > > work_mem = 512MB
> > > maintenance_work_mem = 512MB
> > > wal_buffers = 100MB
> > fsync = off # ONLY DURING I
have something in pg_tblspc that is not a
symlink. That's never supposed to happen, so your data directory is
"corrupt". It's probably not something that actually causes a problem
other than this one in the backup - for now at least. But the fix is
moving the tablespace to a proper loc
On Nov 29, 2012 8:59 PM, "Björn Edström" wrote:
>
> Greetings list.
>
> I have a Postgresql 9.0.8 cluster with one master and a few slaves, in
> a hot standby and streaming replication setup. The setup has a single
> database with a single table. The table has a column "updated" of type
> "timesta
1 - 100 of 998 matches
Mail list logo
