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
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 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
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
(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
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:/
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
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.
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
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
> 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
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
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
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
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
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
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
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
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.
--
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
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
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
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
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
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
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
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-
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
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
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
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
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
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
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 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
that, then I'm not sure exactly what it could be - but it's obvious
that your ident server is reporting an incorrect username, so you'll need to
investigate that one.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
that if that's what it's
doing.
--
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
le. To do this, you need to
set up some IP level redundancy for your LDAP.
--
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/
pl/pgsql debugger that has those functions. If
you're not using it then you can safely ignore them, but if you do use
it, expect it to be broken.
--
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 also
been pretty irregular). At some point there was supposed to have been
an equipment move from one rack to another, and clearly this caused
some serious fallout. Unfortunately, we have received no further
information about what the actual problem is, or any kind of ETA on a
fix.
--
Magnus H
queries.
top will give you an averate CPU usage over an interval, but
pg_stat_activity shows a snapshot. So probably the sessions were running
simple things, but just at the moment pg_stat_activity "hits", it wasn't
doing anything.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
state.
FWIW, another option for writing your authentication module is to
write a simple RADIUS server running on the same box. It's pretty
trivial to do, especially in a high level language. The end result is
the same as if you use PAM - you get custom authentication that can
apply specific
It will be that if you have the tablespaces in the actual directories.
The question is how and why you ended up with the tablespaces in the
actual directories there, and not symlinks. It seems rather pointless
to have tablespaces if they go in there...
//Magnus
On Thu, Dec 1, 2011 at 13:35, Samba
inside the packages
themselves.
That said, you should ensure that it's encrypted from the server side
as well. Make sure the replication line in pg_hba.conf uses "hostssl"
and not "host". If it does, then you can be sure the connection is
encrypted, or else the user would not be a
onnection
> (validation username/password etc.), before creating the backend.
>
> Anyway, I do have an idea how this could be done using a shared library
> (so it has the same disadvantages as logon triggers). Hopefully I'll
> have time to implement a PoC of this over the weeken
uot;.
> 3) Options like archive_command etc that need to be typed out manually
> should be obsolete; let the database server sync itself without needing a
> manual file copy.
You don't need to set archive_command to use just replication, so they
*are* obsolete from a replica
this, the wiki should work right away.
What username did you use? I'll go check the logs for anything suspicious..
--
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
user password?
>>
>
> There's only one way to change a password: ALTER USER... PASSWORD...
Not really. You can use "\password" in psql, or you can use
PQencryptPassword() in libpq. I don't know if that function is exposed
in other client drivers, but it's certain
ve's system table
> is not updated.
You run VACUUM and ANALYZE on the master only, and the results are
automatically replicated to the slave.
However, the *statistics views* on the slave are not updated. That's
why it looks like it's not been run, even though it has.
--
Magnus
his brings me to the
> bigger question.
Intraquery parallelism is certainly something PostgreSQL is in need
of, and it's going to get more and more obvious over the next couple
of years.
Whether it uses threads or not is an implementation detail, just like
processing of regular queries on
like this?
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0495aaad8b337642830a4d4e82f8b8c02b27b1be
(So yes, the principle was agreed to be safe)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-general@pos
ring(2, getStringPrompt("new title"));
> pstmt.executeUpdate();
>
> getStringPrompt returns a string and new_book_id is an int.
Aren't you passing your parameters in the wrong order? Your query
wants title first and book_id second, but you send in new_book_id
first and the new title
ead. My guess is that something was changed there.
> 3) Is there a formal way to get the location of the "pg data dir" from
> a C language routine?
You can look at the configuration variable data_directory, or use the
C symbol DataDir which is exported from the backend.
> 4)
) instead of
> 'cp' , cp will just kick and error and stop restoring on the first file it
> doesn't find.
Not in 9.1 (and later). Regular restore_command and set
standby_mode=on in recovery.conf is the easier way there.
--
Magnus Hagander
Me: http://www.hagander.net/
od as long as you don't get the
> dreaded "could not reattach to shared memory" issue. Not sure if that
We believe that issue has been fixed. And I don't recall having heard
any such bug reports at all since the last fix went in
There might still be some cornercase of c
ctory?
>
> I've done that a couple times, but no effect. I think Tom's point
> about a filesystem bug is probably right.
You mentioned encryptfs, right? That's where I'd be looking first :-O
it wasn't obvious enough to throw something in your kernel dmesg log
by any chance? :-)
--
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 is 8Gb,
see e.g. http://en.wikipedia.org/wiki/Tar_(file_format).
I think there are extensions that let you store bigger files, but
since PostgreSQL will never create files that big it's not
implemented in the basebackup system. Because again, the root of your
problem seems to be that you
;.
>
> Would it be feasible for pg_restore to detect that it is a different pg_dump
> format and inform the user about it?
The main one you'd want to detect is plain I think - and I don't know
if we can reliably detect that. It could be just a generic textfile,
after all -
;t use an objective-c construct. If you are using some wrapper on
top of libpq it might change things, but libpq itself has no knowledge
of GC at all.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-general mailing list (pgsql-gene
need to make that map in the profile of the postgres user
for it to work. I'm pretty sure the instructions you've been following
are designed for moving the installation to a different *local* drive,
not to a network drive, which is why this is not mentioned there.
--
Magnus Hagander
e same 9.1.3-1~lucid located in a local ext4 filesystem,
> the pg_restore went well without a single error.
Yes, it certainly sounds like that. You probably need to bring it up
with the glusterfs folks...
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
h how replication and/or sequences work wrt wal
logging in postgresql. (but no, I'm not actually volunteering at this
point to write said patch due to my backlog already being too large
:P)
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Se
On Mon, May 7, 2012 at 5:02 PM, Liang Ma wrote:
> On Fri, May 4, 2012 at 3:58 AM, Magnus Hagander wrote:
>> On Mon, Apr 30, 2012 at 8:34 PM, Liang Ma wrote:
>>> Hi There,
>>>
>>> While trying to restore a ~700GM binary dump by command
>>>
>>&g
On Mon, May 7, 2012 at 7:34 PM, Liang Ma wrote:
> On Mon, May 7, 2012 at 12:54 PM, Magnus Hagander wrote:
>> On Mon, May 7, 2012 at 5:02 PM, Liang Ma wrote:
>>> On Fri, May 4, 2012 at 3:58 AM, Magnus Hagander wrote:
>>>> On Mon, Apr 30, 2012 at 8:34 PM, L
Dhaval Shah wrote:
> I am setting up Postgres for OpenSSL + FIPs.
>
> I am compiling Postgres with OpenSSL FIPS library using the
> "-with-openssl" option. The question I have is, just doing that
> suffice? Or do I have to modify the postgres source code?
>
> Since I read through the OpenSSL FIP
Holger Hoffstaette wrote:
> On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote:
>
>> I'm not sure which directory should we create $PGDATA -- "My Documents",
>> "Application Data", "Local Settings" or direct child of %USERPROFILE%, but
>> anyway some of them would be better than "Program F
Harald Armin Massa wrote:
> THE MORE hurting problem on Windows7 is the inability to start the
> postgresql service. There must have been some changes to the service
> framework / security
> "security" which prevend the startup...
Dave Page just posted a patch for that, so we'll hopefully have it
Holger Hoffstaette wrote:
> On Tue, 27 Jan 2009 13:17:30 +0100, Magnus Hagander wrote:
>
>> Holger Hoffstaette wrote:
>>> On Tue, 27 Jan 2009 16:10:26 +0900, ITAGAKI Takahiro wrote:
>>>
>>>> I'm not sure which directory should we create $PGDATA --
Tom Lane wrote:
> "Moshe Ben-Shoham" writes:
>> C:\Program Files\PostgreSQL\8.3\bin>pg_dumpall -U admint >
>> c:\temp\dbdump.sql
>> pg_dump: SQL command failed
>> pg_dump: Error message from server: ERROR: character 0xd595 of encoding
>> "UTF8" has no equivalent in "WIN1252"
>
> Apparently you h
Tom Lane wrote:
> Magnus Hagander writes:
>> Tom Lane wrote:
>>> (Hmm, actually it looks like pg_dumpall hasn't got a -E switch,
>>> which seems like an oversight. So you need to fix your locale,
>>> or else use pg_dump directly.)
>
>>
Knut P. Lehre wrote:
> When using a libpq-based clientlib with SSL, libpq gets crt and key
> files from %APPDATA%\postgresql (on MS Windows) (from now on called
> "DIR"). I'd like to connect from the same app to two different pg
> servers using a different set of crt/key files. One way of doing tha
George Oakman wrote:
> Thanks Craig,
>
> I'm trying to compile a very simple test with Visual Studio (2008), but
> I get the following errors:
The PostgreSQL backend and header files are not compatible with Visual
Studio 2008. At least they're not tested wit hit. You need to try Visual
Studio 2
Windows 2008 is basically a vista with some (unfortunately not enough)
of the cruft removed and some nice additions in the server side
totally irrelevant to postgresql.
So as long as it's fine on vista, it should be fine on 2008. I don't
regal offhand if 8.2 is or if it requires 8.3, but th
On 17 mar 2009, at 05.22, "Joshua D. Drake"
wrote:
On Mon, 2009-03-16 at 23:02 -0400, Tom Lane wrote:
"Raji Sridar (raji)" writes:
I don't mind going to 8.3 or later. I want to ensure that Postgres
is
tested on Windows 2008 and patches created like other platforms.
How do
I enable that
Richard Broersma wrote:
> Using the following links to get to the PostgreSQL 8.3.7 (Windows)
> one-click installer:
>
> http://www.postgresql.org/download/windows
> http://www.enterprisedb.com/products/pgdownload.do#windows
>
> and then running the update utility, I get the following error messag
I don't know that anybody does. We usually get a report a couple of
minor versions in and fix it then, which backs that guess. It's also
not tested by the buildfarm. So I think you can call it semi-
maintained at best.
So if you want to become the maintainer and test/send patches at an
ear
Rainer Bauer wrote:
> Hello,
>
> I signed up a couple of months ago but never received the confirmation email.
>
> If I try to create a new account with the same email address, but a different
> handle it is denied with this error message: "A user with that email already
> exists".
>
> When I cl
Rainer Bauer wrote:
> Hello Magnus,
>
> Sunday, April 19, 2009, 11:05:49 AM, you wrote:
>
> MH> You need to have the email system give us at least a chance to get off
> MH> the graylist :-) Or you need to whitelist the wwwmaster.postgresql.org
> MH> domain.
>
> It was whitelisted and works now l
Eugene . wrote:
>
> Hi all,
>
> I've been tasked with evaluating the feasibility of migrating our
> in-house application from MSSQL to PostgreSQL. It is fairly old and has
> lots of stored procedures, which is why we need to think carefully
> before making the switch. Does anyone else have a simi
Vikram Patil wrote:
>
>
> Hello All,
>
>
>
> I am trying to compile postgresql with visual studio but I am
> not successful yet. Actually I just need binaries which are built with
> Visual Studio 2008.
>
> Please provide some idea or input about future plans to compile
> postgresql
Tom Lane wrote:
> Konstantin Izmailov writes:
>> I've asked a few people at pgcon2009 about the issue of connecting users
>> differently: some in SSIS mode, some - with password. This is still an
>> issue: if server is configured for SSIS, there is no way to connect with
>> password.
>
> Huh? Th
I assume this is also VirtuaL PC on the mac, right? I've been using
VirtualPC on the PC for a lot of th dev work on the intaller, and it
should certaily work there..
Does this only occur with win2k, or does it also occur with
XP/2003/whatever?
In the end I doubt there is much we can do, it seems
> Hello!
>
> Finally the time has come for us to upgrade our PostgreSQL
> 7.4.5-servers to 8.0.1 - and though I'm very much looking
> forward to some of the new features, the dump&reload process
> is worrying me a bit this time. I've got one cluster in
> particular which is roughly 9GB in size
> >We hope to have shared row locks in 8.1 for this usage.
> >
> >
> Thanks, and good news, and just what I hoped for. Are there
> some kind af priority orderet todo list somewhere ?
>
> Looking forward to, see You in copenhagen af LinuxForum 2005.
Speaking of which, are there any other intere
> >Speaking of which, are there any other interesting (or
> non-interesting)
> >people from the community that are gonig to be there? I know I am...
> >
> >
> Please take a look for yourself : http://www.linuxforum.dk/2005/en
I know that part - I have my tickets already. I meant attendants, no
> I'm having an issue with what appears to be the stats
> collector process dying on Postgresql 8.0.1 running on
> Windows XP w/sp1.
>
> I've enabled
> stats_command_string and stats_row_level in my config file.
> During bulk inserts the stats collector process appears to
> encounter some sor
>Hello everyone. Thanks for the answers earlier about the new
>8.0 version.
>
>We have a client who is thinking about putting postgresql 8.0
>on Windows
>2003 Server, but he is concerned because this is the first version to
>run natively on windows. Are there any issues with 8.0 on Windows?
Title: Message
A
couple of comments:
pgadmin asked you for the postgres database account. NOT for the service
account. The postgres database account is never autogenerated, it is always
entered during the installation (on the initdb page).
To
change a users password in any windows versio
> I thank you all for throwing light on the question I asked.
[missed it earlier, not been reading that lists mail]
> I was exchanging mails with one of the developers on
> PgFoundry. He made a comment and said
>
> 'Is anybody using PostgreSQL on Windows?'.
Yes. I know of several fairly lar
>Hi,
>
>I am trying to build postgres 7.4.5 on windows (200) on
>mingw/msys env. I have installed win32-pthreads to
>enable-thread safet feature. Couple of issues that I
>wanted to check:.
7.4 is not supported natively on win32. If you need it on windows, you
need to use cygwin. If you can, go
> An idea I like, because I have entrenched windows clients
> also, is to run things that run best under Linux on VMWare
> (vmware.com) and to run good Windows things (like desktop
> apps) under Windows. Linux can be either the host or guest
> OS under VMWare, so the options of which OS is tru
> Thanks Magnus,
>
> Just the information I need. Is this the case if Linux is
> the host (and running PostgreSQL) and Windows is the guest
> running under VMWare? I care about the data in the Linux
> realm. I could give a rip if a PowerPoint presentation gets
> hosed. On the other hand, i
> > Do *not* do this with a production database.
> >
> > Vmware does *not* correctly handle fsync()s (or O_SYNC or any of
> > those) thruogh to disk. If your host PC crashes, your database will
> > almost certainly be corrupted. fsync() on the client just
> puts it in
> > the RAM cache on the
> Hi,
> I'm just starting to look at Postgresql. My platform (for better or
> worse) is Windows, and I'm quite interested in the pl/python support.
> However, when I run the binary installer, it is not offered
> to me as an option (it's there, but greyed out). The
> plpython.dll file is installed
> Hi,
>
> I have a table with about 1500 records. My query is very
> basic: SELECT * FROM foo;
>
> With postgres 8.0.1 on Win XP (Celeron 2400, 500MB RAM) it
> returns the results in about 80ms. The same query on the
> same database, tested on three different win2k machines all
> running 8.
> You're right, the Celeron 2400 is much faster than the 200,
> but not that much more than the 1800, and all win2k
> (professional) machines are serving up the records in exactly
> the same amount of time.
>
> Across a network (issuing the query from the 2400 celeron win
> XP to the 233 PII w
> None of these tests were run over a network - all local.
> Given that the hardware is very different, however, I did
> find it strange that all win2k (Pro, not server) served up
> the records in almost exactly the same time, while the 2.4
> celeron is 80ms!
Note that the granularity of the
> Just installed the 8.0 version for Windows. As a Unix guy, I
> would like to do things through the command prompt. I have
> trouble to bring up it. After bringing up the "psql to
> template1" as the same user of the installation
> configuration, it disappears right after I type in the passwor
> > The confusing thing for me is that so far, the only
> consistent pattern
> > here is that machines running win2k Pro take roughly 4 seconds to
> > deliver the data to the client, while win XP machines perform much
> > better (<200ms to deliver recordset). I've tried installing QoS
> > pac
>Hi,
>
>I installed postgres 8.0 for windows on my win xp (Simplified Chinese
>version). The encoding is unicode. When I set pgsql client encoding to
>gb18030, I could insert Chinese text from the command line to
>postgres.
>
>However, I could not get the sort order of Chinese varchar field to
>wor
501 - 600 of 998 matches
Mail list logo
