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
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
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
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
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;
>>
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
> 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/
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
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
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
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;"
> - >
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
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
management integration etc.
BTW - Dave, I notice the edb page says only ubuntu 8.04 and up, fedora
10 and up, etc are supported by the installers from 9.0 and newer -
the download page on pg.org should probably be updated with that
information.
--
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 Wed, Oct 6, 2010 at 15:54, Tom Lane wrote:
> Magnus Hagander writes:
>> On Wed, Oct 6, 2010 at 14:17, Greg Sabino Mullane wrote:
>>>> But that's build-time, not run-time.
>>>
>>> Correct, not sure of your point. Is this a problem? Build-time is
>
of DBD::Pg clearly doesn't tell you what
version of libpq it's using, only what it was built against.
As long as you have libpq 9.0, you can decode the bytea hex thingy,
irregardless of what version of libpq your was linked against.
--
Magnus Hagander
Me: http://www.hagander.net
ir and pg_config --includedir.
But that's build-time, not run-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
versions of
libpq that may be installed on the machine you are actually linking
against?
--
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's even present at all.
>
> We could add a PQlibpqVersion(), maybe, but it would be many years
> before client code could rely on that being present.
I think we should.
And in a small way they can already - if they check for it
dynamically, they'll know if it was 9.1 or newer at
t;= 9) {
>
> I'd raise a bug with psycopg2 if it does not provide that information.
How does the driver figure it out?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
here's a way to access that function through psycopg2.
But it does outline that fact that it wouldn't suck to have a function
in libpq returning the version so that application can check this at
runtime - clearly it would also be useful when being linked "through"
somethi
, since the
view can only talk to one database at a 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
oral extensions. IIRC it's a very simple project. Jeff - have you
looked at this?
--
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
ped the pgxs file - for users of mingw? I have a feeling it won't
- the thing uses files generated by the postgresql ./configure-script,
doesn't it?
--
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
4 bit versions of Windows can it run?
Any x64 version should work fine. No support for Itanium if you happen
to have one of those old versions.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgre
gAgent for this. It ships with pgAdmin3 (and as a
separate download) and can do all this.
--
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
*within* the
server or *within* the client will make things a lot harder.
Also note that PostgreSQL 9.0 will be available natively 64-bit on Windows.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-gene
)
>
> Magnus how can I linking against postgres.exe I mean the gcc line. I did
> others function and worked fine
Sorry, I don't know this. I don't use mingw myself anymore. But it
should work in the same way as you link against any other third-party
DLLs with it - DLLs and
d windows import libraries, so you need to create your own
there)
--
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
I tried with shared_buffers > 4Gb, but now that i see that page,
I think I need to re-verify that :-)
--
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
saction and never commits it. Perhaps the previous version
was working in autocommit mode by default, and the new one doesn't.
--
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
ons), I would encourage you to look at setting up a mirror on
github and use their wiki services.
--
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
k_mem = 191845
>> max_stack_depth = 2MB
>
> 1GB for temp_buffers is a *LOT*. You do realize that's per backend?
> Those other settings don't look too unreasonable.
Definitely - particularly since this is a 32-bit version, that's
getting very close to the address spac
is here, or what
> additional things I can do to get more information out next time the backend
> crashes?
>
> I'm running PostgreSQL 8.4.4 on Windows server 2003 Standard.
Are there any running postgres.exe processes still present on the
machine? (Other than the postmaster itself, that is
cation again from scratch,
meaning from a new base backup. That also means that if the master
crashes while you're backing up your slave, it will be out of date.
> Will it break the relationship between source and target? Do I need to
> re-configure it in order to receive the WAL files?
Ye
dependent.
> also, once the target PG database receives WAL files and update its own
> database, can I run pg_dump to dump all the data when it is in recovery
> mode?
No.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-ge
d the child will stop working.
In theory you could do something like close(PQsocket(conn))...
--
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
7;t been worked on in a while, but is this any
> use?: http://nagiosplugins.projects.postgresql.org/
Those are plugins to monitor postgresql using nagios. For that, you
should realy be looking at check_postgres. I think what the OP is
looking for is a way to store Nagios metadata in postgres, w
ostgreSQL builds isn't - it "should just work", but I don't
believe anybody has ever tried it. But this error shows a much more
fundamental problem than the PostgreSQL code, and you need to get that
solved first.
Any particular reason why you don't want to build with the
g about the features also included in PostgreSQL,
you should start by reading the chapters at
http://www.postgresql.org/docs/8.4/static/backup.html.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@po
n, there are usually backports available of the newer
versions.
--
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
l probably need to find a non-US company for that, but there
are plenty of those around both in Europe and elsewhere. Only the
installer is the issue there.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-genera
ventually get finished.
--
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
ons available for
the windows installers, but you can always download the source off the
postgresql.org mirrors and build your own 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
On Mon, Jun 14, 2010 at 10:57, Scott Marlowe wrote:
> On Mon, Jun 14, 2010 at 2:35 AM, Magnus Hagander wrote:
>> On Mon, Jun 14, 2010 at 05:17, John T. Dow wrote:
>>> Apparently the problem boils down to this question: how did some of the
>>> files get set to be syst
re out when that gets
set.
> Anybody ever seen this?
Well, at the risk of sounding like a broken clock, yes - with
antivirus or antispyware that sets the flag on things they find
suspicious.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via
"mapped win32 error code to " showing
up - there will be *tons* of other logging output of course)
--
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 Mon, Jun 7, 2010 at 15:58, Thomas Kellerer wrote:
> Magnus Hagander, 07.06.2010 15:52:
>>>
>>> Some AV software probably behaves fine.
>>
>> Probably.
>
> In case anyone is interested:
>
> I have two development computers that run Postgres on Windo
s running pg in a virtual machine on the
box.
> It'd be interesting if someone with a paid contract for AV support would
> go to their AV vendor and get them involved. With the active
> co-operation of an AV vendor or two and a reproducible fault, some
> progress might be possible.
g out and back in again when
using the GUI editors, and if you changed it from the commandline it
might simply be gone.
--
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
>
>> Stephen
>>
>> -BEGIN PGP SIGNATURE-
>> Version: GnuPG v1.4.9 (GNU/Linux)
>>
>> iEYEARECAAYFAkwGZQsACgkQrzgMPqB3kijNXgCfSVVSLUqUNs5gCIx0wk44hEmQ
>> 0yIAoJYgfOqYZLjlftJ+0lU3WjUVoKHZ
>> =jdXN
>> -END PGP SIGNATURE-
>>
>
>
--
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? We considered it with ODBCng but couldn't
> find any real suitable purpose.
Linking it into 64-bit applications would be the obvious one, no?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-gen
hich will likely be a lot faster than using LIMIT, but the same idea
applies - do a binary search. Should take a lot less than days, and is
reasonably easy to script.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql
DLL_INIT_FAILED
>
> Apparently this can mean insufficient heap space. I'm not sure if this is a
> surprising thing to get during high load.
>
> Not sure what can we do about it.
Do you know how many processes were running at the time? (both pg
backend processes and proc
missions adds a bit of complexity,
but not much. Trying to do them generic will make it a lot more
complex though, so if you jus tneed it for this one case, a quick
one-off script is probably the easiest way to go.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.co
R BY count(email_address) did give the same results for my data but
> only because the count values just happen to give the same ordering as the
> years - I tested by changing some dates.
> Many thanks all.
Curious note - how does the non-subselect version and the subselect
version compare per
1 order by 1 asc rows unbounded
> preceding)
> from email_list group by 1 order by 1;
>
> Does anyone have any other ideas?
Aren't you looking for something along the line of:
SELECT year, sum(c) over (order by year)
FROM (
SELECT extract(year from signup_date) AS year, cou
f';
END;
RETURN 't';
END;
$$
And execute
SELECT * FROM my_table WHERE NOT is_valid_encoding(my_column, 'LATIN1')
--
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
've reported the problem to the guys responsible for the boxes we
> have in that data center.
I've just checked with Damien and he's working on it - services are
coming back online as I write this.
--
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
ared_buffer size cannot be more than size_t*”
>
That is normal since your binary is 32-bit. In fact, having shared_buffers
at 1Gb may give you some trouble with your fairly high work_mem as well, as
the *total* amount of memory in the process is limited. That's another
reason to try a lower shared_buffers.
(other than that, read the comments from Thom)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
QL commands by psql.
>
> The two applications are incompatible at that level.
FYI, psql in PostgreSQL 9.0 will ignore UTF8 BOMs.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@pos
ings. As long as you use
pg_start_backup() and pg_stop_backup() before and after the tar, they
are perfectly harmless, and can be ignored.
--
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 Wed, Apr 7, 2010 at 4:57 PM, Heine Ferreira wrote:
> Hi
>
> Will desktop heap usage in windows still be a problem in the upcoming 9.0
> release?
Yes. It's likely to be a smaller issue on 64-bit (not tested yet), but
it will be there.
--
Magnus Hagander
Me: http://www.ha
On Tue, Apr 6, 2010 at 09:42, John R Pierce wrote:
> Magnus Hagander wrote:
>>>
>>> fwiw, on my win7 pro 64bit desktop, that reads...
>>>
>>> %SystemRoot%\system32\csrss.exe ObjectDirectory=\Windows
>>> SharedSection=1024,20480,768
>>>
On Mon, Apr 5, 2010 at 23:45, John R Pierce wrote:
> Magnus Hagander wrote:
>>
>> No, there's a problem with the Desktop Heap getting exhausted because
>> of system DLLs that allocate from it whenever they are loaded into a
>> process. It's in the Windows F
Windows problem, really,
not a PostgreSQL problem. It simply can't deal with many processes the
way the system DLLs are built. The exact limit varies between
installations - likely due to third party DLLs being loaded, like AV
and FW software.
It may be that this is actually not a problem w
vacuum ,certainly not vacuum
full, just analyze.
Oh, and if what you're doing is actually full text search, which is
what it looks like, you should really look at using the native full
text indexing support rather than just stuffing your words in a table.
You'll get better and much fas
put it's
data files by default. Does anybody know if that has changed recently?
--
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.p
C library to
> prevent the connection functions to search for password in files ?
No, but you could possibly set the PGPASSFILE environment variable to
a place where you *know* there won't be a pgpass file, if you can
determine such a place.
--
Magnus Hagander
Me: http://www.hagander.net/
Work
ase user loyalty as it'll
>> be much harder for them to change to a different, SQL-based
>> database. That'll be pretty cool."
>>
>> You may also notice that without SQL, the project name is somewhat
>> misleading. To address that, the project name will be c
n touched since 2004. That shouldn've have worked in
8.4.2 either - but it's only checked on server startup, so if you
changed the mode after startup you wouldn't have noticed.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-
y api's. Is it like ce where such things can
be removed by an oem manufacturer?
--
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
rminated by Signal 11 :-(
>
> Try 8.4.3, which has some XML crash related fix:
> http://developer.postgresql.org/pgdocs/postgres/release-8-4-3.html
Note that 8.4.3 hasn't actually been released yet though - that's the
developer version of the docs.
Expect it out before tomorro
what brand (yet).
>
> 15,000rpm SAS
> 10,000rpm SATA
>
>
> As with everything it's a trade off: 4 SAS drives or 6 SATA II drives in raid
> 10. I'm trying to find
> out if (for many many small reads and writes) one is more desirable than the
> other.
How muc
es this, and if we use CSV format
it's machine readable.
I had a patch sometime back last autumn that did a fairly major
restructuring to allow some of this kind of refactoring, but it was
rejected (on reasonable grounds). My next thought around that was to
add a "pipe" style
t;e:\" too (doesn't need
> write access).
I wonder if it may have osmehting to do with a semicolon in the
password. IIRC we fixed that in the way that we reject semicolons, but
I don't recall which version we did that in.
So please give it a try without having a semicolon in the
the probem. GetAvailableLocales() is the last step that
runs pre-installation. It has clearly moved past it.
If you get the initdb execution error, there should (hopefully) be a
separate log called (IIRC) initdb.log.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-li
nge all
your DNs in the LDAP catalog, but that's likely to break a lot of
other things)
PostgreSQL 9.0 will allow you do do a search+bind to get the
functionality you want. The change should be fairly standalone so you
could probably have it backpatched if it's urgent for you, but since
H. mentions possible fix "backport" into 8.2.
>
> I looked through all 8.2 release notes (upto 8.2.15), but couldn't find any
> reference to this fix beeing backported into 8.2.
>
> So, was it or was it not backported into 8.2.5?
It has not been backported.
--
nnot allocate an array of constant size 0 c:\program
> files\microsoft visual studio 8\vc\include\sys\utime.inl 44
These are all coming out of your SDK files. Can you build your
projects if you *don't* include the postgres headers at all? Perhaps
you are stuck with one of those pl
y useful, it's been removed (well the option is there, but it
doesn't do anything) in 8.4.
--
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
against server 8.3.9. This should, I think, work if you use -i.
It's not recommended, but it should work.
In the second one, it's pg_dump 8.3.9 against server 8.4.0. This is
simply not supported. You need to use pg_dump 8.4 for server 8.4.
--
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
ATEROLE;
> GRANT database-users TO "dbuser2";
>
> How to query database-users to list the dbuser1 and dbuser2?
I think you're looking for:
SELECT rolname from pg_authid a INNER JOIN pg_auth_members m ON
m.member=a.oid WHERE m.roleid=(SELECT oid FROM pg_authid WHERE
rolnam
is open source, and a
such free of costs.
--
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
address space* rather than pure
memory. PostgreSQL is failing to allocate 1Gb of *continuous* memory.
Not just 1Gb of memory anywhere. Shared memory, for example, lives at
a fixed location already. There may be >1Gb free in the address space,
just not where you need it.
In general, when you are starting to talk about things like 1Gb
maintenance_work_mem, you should've switched to 64-bit a while ago :-)
> oh, hmm, my swap is 517Megs, that probably isn't helping. Usually swap is
> 1.5/2x available memory, isn't it? (it is for most unix's and oracle, but
> i'm not sure about PG and linux)
I don't think that affects this problem.
--
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
would confuse the hell out of the people there.
In case you are storing something like that, you may be better off
using bytea instead of text.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgre
> i'd like
> something that doesn't require a restart.
The data isn't being tracked, so there is no way to show it. The
length of the query tracked can be found in the parameter
track_activity_query_size. Note that increasing that will obviously
increase the overhead of col
2010/2/4 Owen Hartnett :
>
> On Aug 9, 2009, at 3:10 PM, Magnus Hagander wrote:
>
>> On Sun, Aug 9, 2009 at 10:22, Abraham, Danny wrote:
>>> Does anybody have a proven way to regenerate this problem?
>>>
>>> SO that I can tell that the patch really does
gt; that the former.
The *meaning* has always been supported versions, but if you read the
contents of the feed it does say latest.
Does anybody know if it's actually supported to have multiple channels
in one RSS feed? If it is, we could add a second channel with
unsupported versions, still l
ould *not* see 7.3 or 6.1 or whatever.
And it needs to be done within the RSS spec (which does allow custom
namespaces though, so that may not be a problem)
As for an estimated end-of-life, yes, we could definitely add that.
Now that we finally have it :-)
> Either way, please add 7.4 back in.
stgres could be advised to throw a warning at least if
you're running an unsupported version ;)
--
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
ertificates.)
uuid:s are, AFAIK, not cryptographically strong. They are predictable
- a lot less predictable than a sequence, but still. If you want
secure random numbers, you need to look at pgcrypto -
http://www.postgresql.org/docs/current/static/pgcrypto.html
--
Magnus Hagander
Me: http:/
(see event viewer) ?
>
> PostgreSQL error log entries (in `pg_log' under data directory) ?
That's where you need to go, yes.
--
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
red disk.
>
> I tried generic service, and application, either one won't bring up
> postgresql database engine service.
>
> did I do something wrong?
>
That should work. My guess is it's a permissions issue. Check what you
get in your logs - both in the pg_log directory and i
On Thu, Jan 21, 2010 at 12:45, A. Kretschmer
wrote:
> In response to Magnus Hagander :
>> 2010/1/21 Bjørn T Johansen :
>> > We are going to be setting up a PostgreSQL server on a guest under VMWare
>> > ESX 4... Is there any performance improvement by choosing 64bits L
an you may eventually need to increase
the size of the machine, go with the 64-bit one from the beginning,
because changing from 32 to 64 bit requires dump/reload.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgs
On Mon, Jan 4, 2010 at 06:28, lls wrote:
> 22.12.2009 21:40, Magnus Hagander пишет:
>
> On Tue, Dec 22, 2009 at 10:30, Лев Ласкин wrote:
>
>
> Hi.
> We have installed Postgresql 8.3.3. When we see the output of atop-d, we see
> just such a string
>
> db0: ~ # atop
E can solve your problem:
WITH t2 AS (SELECT 1 AS a)
SELECT * FROM t2 LEFT JOIN t3 ON TRUE
--
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
ere any plans to make this work?
Sure. 8.5 (current alpha release included) will let you do
i INT NOT NULL UNIQUE DEFERRABLE
which will make that work.
(you might want to consider using an actual email address if you want
to get responses to your questions in the future)
--
Magnus Hagande
a lot less writes here, but on 8.4 it's perfectly normal.
--
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
201 - 300 of 998 matches
Mail list logo