Re: [GENERAL] pg on Debian servers

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/>

Re: [GENERAL] pg on Debian servers

ly. 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-administration.org/article/

Re: [GENERAL] Logcal replication in large scale

On Wed, Sep 20, 2017 at 10:02 AM, Nicklas Avén <nicklas.a...@jordogskog.no> 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 <nicklas.a...@jordogskog.no> > wrote: > > Hallo all > > I a

Re: [GENERAL] Logcal replication in large scale

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? >

Re: [GENERAL] pg_ident mapping Kerberos Usernames

hat is possible, or 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/>

Re: [GENERAL] pg_rewind - restore new slave failed to startup during recovery

y people have fallen into this trap up to > now... We should 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 mi

Re: [GENERAL] debugging SSL connection problems

pect. You should be able to use (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/

Re: [GENERAL] pg_basebackup error: replication slot "pg_basebackup_2194" already exists

d -- but it's the pid of pg_basebackup. I assume you're not running the two pg_basebackup processes on the same machine? Is it predictable when this happens (meaning that the pid value is actually predictable), or do you have to run it a large numbe rof times before it happens? -- Magnus Hagander Me: https://www.hagander.net/ <http://www.hagander.net/> Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Re: [GENERAL] Help: Installing 9.6 breaks local connections to 9.2 on Centos 6.9

nough workaround 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/>

Re: [GENERAL] Convert from LATIN9 to UTF-8 / WAL Replication

ing pg_upgrade while maintaining the 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/>

Re: [GENERAL] Link errors

I missing? I am linking 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 p

Re: [GENERAL] Compatibility of libpg

On Thu, May 4, 2017 at 7:32 PM, John R Pierce <pie...@hogranch.com> wrote: > On 5/4/2017 2:19 AM, Magnus Hagander wrote: > > On Wed, May 3, 2017 at 11:31 PM, John R Pierce <pie...@hogranch.com> > wrote: > >> On 5/3/2017 2:20 PM, Magnus Hagander wrote: >&g

Re: [GENERAL] Compatibility of libpg

On Thu, May 4, 2017 at 12:06 AM, Igor Korot <ikoro...@gmail.com> wrote: > > On Wed, May 3, 2017 at 5:20 PM, Magnus Hagander <mag...@hagander.net> > wrote: > > On Tue, May 2, 2017 at 4:49 AM, Igor Korot <ikoro...@gmail.com> wrote: > >> > >> Joh

Re: [GENERAL] Compatibility of libpg

On Wed, May 3, 2017 at 11:31 PM, John R Pierce <pie...@hogranch.com> 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

Re: [GENERAL] Compatibility of libpg

from 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 MS

Re: [GENERAL] Recover PostgreSQL database folder data

d up on 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/>

Re: [GENERAL] A change in the Debian install

e 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/

Re: [GENERAL] browser interface to forums please?

ty members 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 wo

Re: [GENERAL] browser interface to forums please?

On Wed, Apr 5, 2017 at 6:31 PM, Adrian Klaver <adrian.kla...@aklaver.com> 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

Re: [GENERAL] browser interface to forums please?

can't be tried again, 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/

Re: [HACKERS] REFERENCES privilege should not be symmetric (was Re: [GENERAL] Postgres Permissions Article)

ck branches, even more so than other behavior. In this case I think it's quite 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,

Re: [GENERAL] Wiki editor privilege

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

Re: [GENERAL] Load multiple CSV file in Postgres using COPY

On Feb 17, 2017 06:53, "John R Pierce" <pie...@hogranch.com> 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/WI

Re: [GENERAL] Load multiple CSV file in Postgres using COPY

-> 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 external script (eg: shell script) but is there any > other way to do this using single COPY command? > > Perhaps something like &qu

Re: [GENERAL] Can't restart Postgres

tializes the new data directory 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

Re: [GENERAL] Can't restart Postgres

inaries in that directory seems 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/

Re: [GENERAL] Can't restart Postgres

e >> > > What about if 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

Re: [GENERAL] PostgreSQL corruption

like other issues, 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/

Re: [GENERAL] pg_upgrade not able to cope with pg_largeobject being in a different tablespace

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 th

Re: [GENERAL] Unexpected trouble from pg_basebackup

On Wed, Oct 5, 2016 at 3:55 PM, otheus uibk <otheus.u...@gmail.com> wrote: > > > On Tue, Oct 4, 2016 at 10:49 PM, Magnus Hagander <mag...@hagander.net> > wrote: > >> >> >> On Tue, Oct 4, 2016 at 10:42 PM, otheus uibk <otheus.u...@gmail.c

Re: [GENERAL] Unexpected trouble from pg_basebackup

INT with spreading, which 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/

Re: [GENERAL] Filters not supported for LDAP authentication

or it. I see no reason why we wouldn't accept a patch for that functionality. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [GENERAL] Site down

alerts got lost along with the big 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/

Re: [GENERAL] Equivalent of Oracle's per-session statistics (v$client_stats)?

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

Re: [GENERAL] PostgreSQL crashed, whole PC not responding

uration_statement 2000 (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/

Re: Email address VERP problems (was RE: [GENERAL] Does a call to a language handler provide a context/session, and somewhere to keep session data?

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/

Re: [GENERAL] could not migrate 8.0.13 database with large object data to 9.5.1

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

Re: [GENERAL] PostgreSQL flavors

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/

Re: [GENERAL] Let's Do the CoC Right

ovenant *and* the CoC suggested by others. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [GENERAL] Let's Do the CoC Right

On Fri, Jan 22, 2016 at 8:37 PM, David E. Wheeler <da...@justatheory.com> wrote: > On Jan 22, 2016, at 11:28 AM, Magnus Hagander <mag...@hagander.net> wrote: > > > Regardless whether it's true or not (to which I cannot speak), surely > statements like that would vio

Re: [GENERAL] dblink connect per socket / specify cluster name

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

Re: [GENERAL] Support for hardware tokens for server/replication private key

ho has, it should work. From 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/

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

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

Re: [GENERAL] 9.3.9 ?

On Jun 12, 2015 1:33 PM, Albe Laurenz laurenz.a...@wien.gv.at 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.

Re: [GENERAL] count distinct and group by

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/

Re: [GENERAL] Upgrading hot standbys

, they have to be redone from scratch. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [GENERAL] GiST indeices on range types

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/

Re: [GENERAL] Ransomware article

, 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/

Re: [GENERAL] sslmode verify-ca and verify-full: essentialy the same?

with verify-full than with verify-ca. If I'm wrong, where am I wrong? How does libpq verify the server's name? Reverse DNS? Other mean? libpq uses the hostname that you specify in the connection string (or in an environment variable, or however you end up specifying it). -- Magnus Hagander Me

Re: [GENERAL] sslcompression / PGSSLCOMPRESSION not behaving as documented?

and that you might need to set an external override)? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

capable MUA. -- 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

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

On Mon, Nov 10, 2014 at 8:53 PM, John R Pierce pie...@hogranch.com 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 Nabble - I think only

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

-5826230.p...@n5.nabble.com - which does not contain those parts. And it wasn't event sent as multipart, so there is not much of ways to misparse it. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Planet Postgres

, 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

Re: [GENERAL] Where should I post 3rd party product announcements?

. These are 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

Re: [GENERAL] Where should I post 3rd party product announcements?

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 jonat...@copycat.fr wrote: Sorry for being a bit dense, but where should I submit a website news posting ? Le mardi 14 octobre 2014 11:45:55, Magnus Hagander a Ã

Re: [GENERAL] OpenSSL Vulnerabilities

of 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:56 PM, Magnus Hagander mag

Re: [GENERAL] OpenSSL Vulnerabilities

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/

Re: [GENERAL] Heartbleed Impact

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

Re: [GENERAL] Online recovery of Tablespace

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 believe they have made any such extensions either) -- Magnus Hagander Me: http

Re: [GENERAL] LDAP authentication not working

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/

Re: [GENERAL] LDAP authentication not working

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 sfa...@hawaii.edu mailto:sfa...@hawaii.edu wrote: I don't think SSL support for LDAP

Re: [GENERAL] Monitoring Pg servers with Microsoft SCOM

) about SCOM to recommend any of them in particular. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [GENERAL] UNIQUE contraint that is initially deferred in Postgres 8.4.13

. (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, it's probably a good idea to start doing that, see http://www.postgresql.org/support/versioning/) -- Magnus Hagander Me: http://www.hagander.net

Re: [GENERAL] High Level Committers Wanted

. 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/

Re: [GENERAL] stand by is starting until I do some work in the primary

something happens on the master and do a checkpoint. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [GENERAL] Is pgFoundry Down? (2/18/2014)

On Tue, Feb 18, 2014 at 6:07 PM, Purdon kylepur...@gmail.com 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

Re: [GENERAL] CET ERROR: requested WAL segment has already been removed

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/

Re: [GENERAL] pg_basebackup and checkpoints

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/

Re: [GENERAL] pg_basebackup failing

On Jan 15, 2014 12:07 PM, Sameer Kumar sameer.ku...@ashnik.com 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

Re: [GENERAL] pg_stop_backup running for 10h?

can safely cancel the pg_stop_backup() command. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [GENERAL] postgresql-common breaks logrotate

packages in general, that might also be part of the solution. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [GENERAL] pg_stat_tmp

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/

Re: [GENERAL] hstore syntax

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/

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

to see. Congratulations on getting it to work. I'm a bit envious that you beat me to it (GSS auth interop between PostgreSQL on Windows and others is kind of my hobby), but the sooner, the better. +1 :) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [GENERAL] Using LDAP for PostgreSQL permissions/authentication

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

Re: [GENERAL] Strange message from pg_receivexlog

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.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Question re contribs of Julian Assange

of his contributions at: http://git.postgresql.org/gitweb/?p=postgresql.gita=searchh=HEADst=authors=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.hagander.net/ Work: http://www.redpill

Re: [GENERAL] Force ssl connection

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. If you want to enforce non-ssl, use sslmode=disable. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com

Re: [GENERAL] LDAP referrals

. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [GENERAL] .pgpass being ignored

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't change this specific case) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com

Re: [GENERAL] LDAP authentication timing out

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/

Re: [GENERAL] Snapshot backups

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/

Re: [GENERAL] pg_basebackup, requested WAL has already been removed

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

Re: [GENERAL] What's wrong with postgresql.org domain?

? -- 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

Re: [GENERAL] What's wrong with postgresql.org domain?

On Thu, Apr 18, 2013 at 10:37 AM, Eduardo Morras emorr...@yahoo.es wrote: On Thu, 18 Apr 2013 10:33:20 +0200 Magnus Hagander mag...@hagander.net wrote: On Thu, Apr 18, 2013 at 10:31 AM, Eduardo Morras emorr...@yahoo.es wrote: I get Godaddy's page saying it's free Really? Whois shows

Re: [GENERAL] Git host for postgresql related projects

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 via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] High CPU usage of stats collector

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

Re: [GENERAL] FW: statement failure

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://www.redpill-linpro.com/ -- Sent

Re: [GENERAL] could not link file pg_xlog/xlogtemp.72606

://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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Guidance on building Foreign Data Wrapper on Windows.

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-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] PG V9 on NFS

. 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.com/ -- Sent via pgsql-general mailing

Re: [GENERAL] Changing Character Sets

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 Hagander Me: http://www.hagander.net/ Work: http

Re: [GENERAL] Changing Character Sets

. -- 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

Re: [GENERAL] Hot Standby has PANIC: WAL contains references to invalid pages

, it might 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

Re: [GENERAL] Version numbers for binaries

. -- 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

Re: [GENERAL] Throttling Streamming Replication

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 Hagander Me: http://www.hagander.net

Re: [GENERAL] pg_Restore

On Jan 21, 2013 7:17 AM, bhanu udaya udayabhanu1...@hotmail.com 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

Re: [GENERAL] pg_basebackup questions

. 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 location. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list

Re: [GENERAL] Non-replicated index allowing comparison ()?

On Nov 29, 2012 8:59 PM, Björn Edström bj...@spotify.com 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

  1   2   3   4   5   6   7   8   9   10   >