Lee Keel wrote:
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
>> [EMAIL PROTECTED] On Behalf Of Magnus Hagander
>> Sent: Thursday, November 08, 2007 1:30 PM
>> To: Kevin Neufeld
>> Cc: Tom Lane; pgsql-general@postgresql.org
&g
Willem Buitendyk wrote:
> Is there any plan to port Postgresql to windows x64? I can currently
> run Postgresql as 32 bit inside Vista 64 - would I see better
> performance if Postgresql was running under 64 bit. My biggest concern
> is memory - at 32 bit is not Postgresql limited to 4GB in windo
On Thu, 2007-11-15 at 20:35 +0200, Andrus wrote:
> "PostgreSQL 8.2.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
> (mingw-special)"
> Database size in disk returned by pg_database_size() is 210 MB
>
> Database compressesed backup file size is now 125 MB.
> This seems too much. I ex
On Mon, 2007-11-19 at 10:33 +, Richard Huxton wrote:
> Bebarta, Simanchala wrote:
> >>
> >> Does the problem go away when you put shared_buffers back to a lower
> >> number?
> >>
> > Yes, when I set the value to 1300 MB, everything goes fine. Any value
> > higher than this value does not a
On Thu, 2007-11-22 at 15:26 +0900, Paul Lambert wrote:
> I'm running PG 8.3beta3 on a W2K3 server.
>
> I've set up a tablespace on D drive, with PG itself on C drive and
> loaded a bunch of data into a database to test. The directory I've
> created the tablespace in on D drive grows to 116Mb -
On Thu, 2007-11-22 at 17:04 +0900, Paul Lambert wrote:
> Paul Lambert wrote:
> > I've just noticed in the tablespace documentation (Ch 19.6) that PG
> > makes use of symbolic links that point to any user-defined tablespaces
> > but AFAIK W2K3 doesn't support symlinks.
> >
>
> OK, W2K3 supports
On Tue, 2007-11-27 at 11:11 +0100, Wolfgang Keller wrote:
> Hello,
>
> sorry for "butting in", but I'm just curious...
>
> > resolution?
> >
> > http://archives.postgresql.org/pgsql-general/2007-11/msg00946.php
> >
> > conclusion?
> >
> > Mac was still pretty slow in comparison
>
> Anyway, how
On Tue, Nov 27, 2007 at 05:01:06PM -0700, Scott Ribe wrote:
> > In general, you can expect any Unix based OS, which includes MacOS X, to
> > perform noticeably better than Windows for PostgreSQL.
>
> Is that really true of BSD UNIXen??? I've certainly heard it's true of
> Linux. But with BSD you h
On Wed, 2007-11-28 at 07:29 -0700, Scott Ribe wrote:
> > Yes, very much so. Windows lacks the fork() concept, which is what makes
> > PostgreSQL much slower there.
>
> So grossly slower process creation would kill postgres connection times. But
> what about the cases where persistent connections
Ron Johnson wrote:
> On 11/28/07 11:13, Magnus Hagander wrote:
>> On Wed, 2007-11-28 at 07:29 -0700, Scott Ribe wrote:
>>>> Yes, very much so. Windows lacks the fork() concept, which is what makes
>>>> PostgreSQL much slower there.
>>> So grossly s
Trevor Talbot wrote:
> On 11/28/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>
>> On Wed, 2007-11-28 at 07:29 -0700, Scott Ribe wrote:
>>>> Yes, very much so. Windows lacks the fork() concept, which is what makes
>>>> PostgreSQL much slower there.
&g
On Wed, Nov 28, 2007 at 10:33:08AM -0800, Trevor Talbot wrote:
> On 11/28/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> > Trevor Talbot wrote:
> > > On 11/28/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>
> > >> There is at least one othe
Guillaume Pungeot wrote:
> Hi,
> I have a problem when a lot of connexions are opened on postgresql.
>
> When 243 threads have been created by postmaster, the next CreateThread
> fails and the following error is written in pglogs : "FATAL: could not
> create sigchld waiter thread: error code 8".
> > > Hi,
> > > I have a problem when a lot of connexions are opened on postgresql.
> > >
> > > When 243 threads have been created by postmaster, the next CreateThread
> > > fails and the following error is written in pglogs : "FATAL: could not
> > > create sigchld waiter thread: error code 8".
>
On Mon, Dec 03, 2007 at 04:41:35PM +0100, Enrico Sirola wrote:
> Dear all,
> I'd like to use the upcoming release 8.3 for my next project. When is it
> expected to be finalized? My deadline is 2nd quarter 2008, do you think
> there is a chance for me to use it?
Most likely. While there is no pro
> We're developing .NET application (closed-source) and would like to include
> pg_dump to allow users to perform "quick database backup" within main
> application.
>
> Two questions:
>
> 1. Do we need to include any dependent files besides pg_dump.exe ?
IIRC, you need libpq and it's dependencie
On Thu, Dec 06, 2007 at 09:42:19AM +0100, Marco Curtolo wrote:
>
> Hi, my question is this: it is possible to query, using SQL, an LDAP server
> and put these data to a table of a Postgres database (under linux) ???
Depending on exactly what you nede to do, check out dblink-ldap
(http://pgfoundr
Mitchell Vincent wrote:
> On Jul 29, 2007 2:51 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>> Mitchell Vincent wrote:
>>> Ah, I see what you mean.
>>>
>>> I was hoping to be able to rebuild the MSI to not include the things I
>>> didn't n
On Tue, Dec 11, 2007 at 05:50:46PM -0500, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Howard Cole wrote:
> >> I take it from the lack of response that nobody knows how to kill a
> >> connection from the postgresql side on windows?
>
> > You can't, short of sending a signal to
> > Tatsuo Ishii wrote:
> > > Hi,
> >
> > > test=# select t at time zone 'jst' from t2;
> > > timezone
> > > -
> > > 17:34:56+09
> > > (1 row)
> > >
> > > test=# select t::time from t2;
> > > t
> > > --
> > > 12:34:56
> > > (1 row)
> >
> > Hello,
> >
> > time
Sean Z. wrote:
> Hi,
>
> I need your kind advice on postgres deployment strategy. My application
> is developed on 8.2.4 and need to be deployed to Windows server 2003.
> Clients may /may not have postgres installed. How can I deploy postgres
> silently on client machine? Specifically:
>
> 1.
On Wed, Jan 02, 2008 at 11:17:52PM -0800, Goboxe wrote:
> Hi,
>
> What are required to be configured in order to send logs to
> remote syslog server for pg running on Windows platform?
>
> In http://pgfouine.projects.postgresql.org/tutorial.html , it says
> "You can set syslog to send the log to
Clodoaldo wrote:
I'm the owner of a database and when i issue an analyze command on it,
the pg tables are skipped with the message that only the owner can
analyze them:
$ psql fahstats -U cpn
Welcome to psql 8.3beta4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
On Wed, Jan 09, 2008 at 03:02:53AM -0800, Robin-Vossen wrote:
>
> So I thought lets add the language I miss.
> doing:
> createlang -d ledgersmb -U ledgersmb plpgsql
> I keep getting:
> createlang: language installation failed: ERROR: permission denied for
> language c
You must run creatlang with
On Thu, Jan 10, 2008 at 11:36:04AM +, Mark Walker wrote:
> Ignoring the warnings not to use a beta product on a production database I
> had been running 8.3beta1. When I saw that it had hit 8.3RC1 I decided to
> upgrade and folowing the usual data compatibility within major versions I
> did not
On Mon, Jan 21, 2008 at 04:05:13PM +0100, Henrik wrote:
> Hello list,
>
> I know backup of pg is a well discussed topic and ranges in solution
> from simple pg_dump to more advanced PITR with Slony.
>
> Even though I've studied most of them I can't really decide the best
> solution for a new
On Mon, Jan 28, 2008 at 10:07:43AM +0100, Rainer Bauer wrote:
> Hello,
>
> I cannot retrieve any list messages through the news server anymore
> (since last Tuesday). Are there any known problems?
>
> The reported error is: "503 NNTP server unavailable".
Yes, it's been down for quite a long time
been finalized and is available at
http://2010.pgday.eu/training. Note that for the training, there are limited
seats available for each session on a first come first serve basis, so register
early to avoid disappointment!
On behalf of the team, welcome to Stuttgart and PGDay.EU 2010!
--
Magnus
quot;ou=postgresql,dc=domain,dc=com"
>
>
> I'm trying to translate that to the old syntax of:
> ldap "ldap://w.x.y.z/ou=postgresql,dc=domain,dc=com;"
>
> basically, i don't know how to fit cn=admin and ldapbindpassword into that
> string.
The search+b
On Thu, Nov 4, 2010 at 15:30, David Kerr wrote:
> On Thu, Nov 04, 2010 at 02:07:29PM -0700, Magnus Hagander wrote:
> - >
> - > I'm trying to translate that to the old syntax of:
> - > ldap
> "ldap://w.x.y.z/ou=postgresql,dc=domain,dc=com;"
> - >
know how your specific disk does it, but if it
uses SMB or NFS, this is not safe. If it's an iSCSI mount, for
example, it should be safe. But it certainly looks like an SMB mount -
in which case you should rethink your strategy.
I would bet your problems are caused by this.
--
Magnus
a generic registered
> address like "mailingl...@postgresql.com.au"
This part I really don't like. It should at least be posted with some
kind of uniquely identifiable pass-through address, if not the users
own address (make that an option?). Like
magnus-hagander-...@forums.whatever
d other
than that, they are on markmail.org, Nabble, etc. AFAIK several of
those allow both reading and posting. Is there actually something
about these interfaces that people find *missing*, or can we easily
solve this whole thing by more clearly telling people that these
options exist?
--
Ma
> to make sure anything I do does not in any way reflect badly on the community
> or seem like i'm doing anything dishonest.
Some of us are already reading this thread. But the correct forum to
use is the pgsql-www mailinglist.
--
Magnus Hagander
Me: http://www.hagander.net/
erly?
And somehow discourage top-posting in said responses? We absolutely do
*not* want a forum to start feeding non-quoted responses back to the
mailinglists, and non-quoted responses is unfortunately pretty common
on most forums where I usually end up - but again, that is hopefully
just a
On Tue, Nov 16, 2010 at 11:11, Thom Brown wrote:
> On 16 November 2010 09:30, Magnus Hagander wrote:
>>
>> On Tue, Nov 16, 2010 at 03:45, Elliot Chance wrote:
>> > I have made some major changes "beta2"
>>
>>
>> > Extra thoughts;
>>
On Tue, Nov 16, 2010 at 10:59, J. Roeleveld wrote:
> On Tuesday 16 November 2010 10:30:05 Magnus Hagander wrote:
>> On Tue, Nov 16, 2010 at 03:45, Elliot Chance wrote:
>> > I have made some major changes "beta2"
>>
>>
>>
>> > Extra thoughts
er like a forum. I
> understand that I can broadcast this information on other mailing lists (www
> was mentioned) but if theres no absolute authority figure would it make any
> serious difference from what we're already doing?
We don't deal in authority figures, we deal in authori
s something different, though, with it's
rating systems and such.
What I'm more interested in is still a word from the people who would
actually *use* a forum on how this would be better than sites like
Nabble and Gmane.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: htt
On Wed, Nov 17, 2010 at 00:00, Elliot Chance wrote:
>
> On 17/11/2010, at 6:22 AM, Stephen Cook wrote:
>
>> On 11/16/2010 10:51 AM, Magnus Hagander wrote:
>>> What I'm more interested in is still a word from the people who would
>>> actually *use* a forum
7;t like my honest answer :-)
Clearly you're volunteering to tell us exactly *what* features are
needed that aren't on gmane, nabble or such sites. Which is something
nobody has done so far - other than just saying they don't like email.
--
Magnus Hagander
Me: http://www.hagander
On Sat, Nov 20, 2010 at 14:22, Elliot Chance wrote:
>
> On 20/11/2010, at 11:52 PM, Magnus Hagander wrote:
>
>> On Sat, Nov 20, 2010 at 12:26, Elliot Chance wrote:
>>>
>>> On 20/11/2010, at 9:52 PM, Magnus Hagander wrote:
>>>
>>>> On
enough
>> that I would never use it.
>>
>> Based on that, I'm back to saying that the email has to be generated
>> from a valid email address, that can be used for return traffic.
>> Whether it's the users original address or a forum-specific one i
though.
> A forum handle of some sort would probably be sufficient.
The forum is, AIUI, requiring a validated registration, so we know
that it's not just a completely unidentified person. I assume the
forum will be putting the registered *name* in the name part of the
From field still, eve
a public place.
I doubt people will really remember that. However, the forums could be
given a big disclaimer on posts saying that private replies may show
up public, or it could even add it to the footer of the message (sure,
nobody reads that, but at least we tried..)
--
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
hat circumstances can lead to
> this?
There should be a details row associated with that message that should
give you some further hints on what actually went wrong.
You should probably post this to the npgsql list as well, since it
does seem to be an npgsql problem - as you say, it works fro
Documents\Visual Studio
> 2005\Projects\NpgsqlTest\NpgsqlTest\Program.cs:line 17
> I found a way to reproduce the same message in psql: when creating a local
> user with the same name as a domain user, the connection attempt when logged
> in as that user fails with the same message (rightl
text
> 2010-11-22 13:25:54 CET DETAIL: The logon attempt failed
> (8009030c)
>
> 2010/11/22 Magnus Hagander
>>
>> Plase don't drop the mailinglist from the thread.
>>
>>
>> On Mon, Nov 22, 2010 at 11:57, Reto Schöning
>> wrote:
>> > T
such an ancient
> version kicking around? If so, IMO the most recent 8.1 really needs to
> be on postgresql.org, even if it's within a password-protected folder
> that forces you to type "I don't care if this eats all my data" as the
> password before downloading...
>
like this for PG in Windows?
Either one of these two should work fine. What you have to worry about
is if they honor the synchronous I/O flags and commands properly - I
don't know if either of them do. And of course, it'll be really slow.
You need to look in your eventlog to get th
ion. however, it will automatically be built whenever you build
postgresql on windows, so if you do a build-from-source, you'll get
it.
(Note that you're looking for libpq.lib, not libpqdll.lib, if you want
the static one)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www
be able to
use gigabytes of memory in a single backend for sort/hash operations
and such. For that, there was no workarond...
--
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
> the log level in postgresql.conf to see if it logs the error message from
> copy, or try xcopy instead of copy.
Note thatn when PostgreSQL runs, it will shed any rights given through
"Administrators" or "Power Users" group. So this is not an identical
test.
--
Magnus
m.
> 4) The slave DB instance will also be v9.0.1 on linux, but it wil be a
> virtual machine. Do you see any problem with that?
None other than potential performance issues if it's too slow.
> 5) Is there a step-by-step "how to" document for this?
http://wiki.postgresql
ld look at pgBouncer (actually we have looked at it but it’s
> not in use right now)
If you can use that, or application level connection pooling, you will
likely get much better performance.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via
e without starting postgresql server.
>
>
No, unfortunately there isn't (that would never work, but in theory we could
have some attach/detatch command that would do it but there is no such
thing). You can do a dump/reload of a single database, but that's the only
thing..
successfully compiled, including files that use elog.h . Yet your extension
> doesn't compile, complaining about a macro/typedef conflict.
>
> This makes me wonder: what's different?
First check would be that you are including postgres.h *at the top* of
your files. It will bring
es with the installer? If the latter, then it's probably that it's
the wrong version of visual studio.
Those imports are from the Visual C runtimes, so that's what you're
missing for those - or using different versions.
--
Magnus Hagander
Me: http://www.hagander.net/
W
ot;.
> 1>C:\Users\Julia\Desktop\db_con\Debug\db_con.exe : fatal error LNK1120: 7
> Unresolved external references.
>
> Which libraries are missing now?
At least one of those is winsock, thus probably wsock2_32 or something
like that. The SSPI stuff is from some other system library, don
.
Using SR, the method will be to upgrade the master and then rebuild
the slave off that one. You can upgrade with pg_upgrade, which will
shorten your downtime, but there will be downtime.
For a downtime-less upgrade, you will need to look at one of the
"userspace replication solutions", l
No, you can't. Because it gets a new systemid and things like that.
If you use rsync to push from the master to the slave, the
re-provisioning of the slave will be fairly quick, but again it's well
above zero.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpr
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
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/
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/
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
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
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
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
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&#
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
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
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/
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/
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/
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
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
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
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/
--
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
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
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
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
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
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:/
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
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
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
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
>>
&
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
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/
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/
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
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
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
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 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
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/
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
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/
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.
-
101 - 200 of 998 matches
Mail list logo
