RPK wrote:
> Is there any built in function in PGSQL to Encrypt/Decrypt a text before
> storing in field? If yes, which algorithms it supports and what is the
> maximum key size?
Take a look at contrib/pgcrypto. It supports a wide range of different
algorithms and key sizes. There's a README file
Vacuum Joe wrote:
> Quick question: I have installed PG 8.2.x on a customer's system and
> we will be storing a lot of critical data on it. It needs to be
> backed up maybe twice a day. It's very easy to back data up with the
> pgadmin tool (great tool btw) but we need an automated solution that
Are we sure we want to do this? (Sorry, didn't notice this thread last
time)
The default on *all* windows versions since NT 4.0 (which is when the
directory we use was added) will put this file in a protected directory.
The only case when it's not protected by default is if you're usnig FAT
filesy
>>> The default on *all* windows versions since NT 4.0 (which is when the
>>> directory we use was added) will put this file in a protected directory.
>>> The only case when it's not protected by default is if you're usnig FAT
>>> filesystem, in which case there is nothing you can do about it anywa
Tony Caduto wrote:
> Magnus Hagander wrote:
>> Are we sure we want to do this? (Sorry, didn't notice this thread last
>> time)
>>
>> The default on *all* windows versions since NT 4.0 (which is when the
>> directory we use was added) will put this file in a
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> Tony Caduto wrote:
>>> What about having a wallet type system where the user can create a pass
>>> phrase to protect a generated key that would get
>>> loaded once per session. That
Dave Page wrote:
> Magnus Hagander wrote:
>
>> Just to make things clear, this wouldn't be about another auth method.
>> Windows has an API to store arbitrary passwords in a "secure way". At
>> least it does in XP+, not sure if it was in 2000.
>
> Wou
On Wed, Feb 21, 2007 at 12:11:07PM +0900, Paul Lambert wrote:
> I have postgres running on W2K, version 8.2.1 which I am upgrading to
> 8.2.3 but when I run the upgrade I get an error as follows:
>
> "The installer has encountered an unexpected error
> installing this package. This may indicate a
On Tue, Feb 20, 2007 at 05:15:38PM -0500, Rhys Stewart wrote:
>
>
> Ok so i am having trouble installing plpython, and found this thread.
> Howevre, after adding postgresql/bin to the path and the python lib
> directory to the path i still get:
> createlang: language installation failed: ERROR:
RPK wrote:
> I have PostgreSQL 8.2 installed on Windows XP. I installed NPGSQL driver for
> .NET and tried to register it's dll with following command:
>
> regsvr32 c:\windows\system32\npgsql.dll
>
> It displays error: "Could not be registered, entry point not found".
regsvr32 is not used for .n
Joshua D. Drake wrote:
> Magnus Hagander: VC++ support (thank goodness)
I would much appreciate more people testing and commenting on this one,
from the version in CVS head.
//Magnus
---(end of broadcast)---
TIP 3: Have you checked
> For the record, anyone using wikipgedia deserves the pain they
> get: it is deprecated. The latest version of MediaWiki itself is what
> should now be used: it will detect if you have Postgres upon
> installation. :)
Perhaps the project should be *gasp* deleted then? ;-) Or is there
actual histo
Dave Page wrote:
> Scott Marlowe wrote:
>> On Fri, 2007-02-23 at 12:22, Chris Travers wrote:
>>> Hi all;
>>>
>>> Microsoft has seen it fit to publish a paper I have written as an
>>> introduction to PostgreSQL on Windows. This paper covers the basics of
>>> installing and configuring the softwar
On Thu, Mar 01, 2007 at 09:44:19AM +0900, Paul Lambert wrote:
> I'm running PG 8.2.3 on We doze 2000 Server. (Should I apologise for
> that up front to appease the masses?)
>
> I am periodically getting errors pop up on the server console of the
> following nature:
>
> The File or directory D:\
On Thu, Mar 01, 2007 at 02:31:12AM -0800, hengky liwandouw wrote:
> Dear all,
>
> I have another problem with Access 2003 as front end with Postgre 8.1, ODBC
> version 8.02.02 Unicode.
>
> I just upgrade the Point of Sales Program to Access 2003 MDE, all station
> running XP Home wth
On Thu, Mar 01, 2007 at 08:32:57AM -0500, Merlin Moncure wrote:
>
> Following an emergency downgrade back to 8.1, the kernel panics went
> away. Note that I don't believe for a second that the database was
> the root cause here...research suggest that the problem is due to some
> type of bug in t
On Thu, Mar 01, 2007 at 10:45:16AM -0500, Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
> > On Thu, Mar 01, 2007 at 09:44:19AM +0900, Paul Lambert wrote:
> >> I am periodically getting errors pop up on the server console of the
> >> following nat
John Smith wrote:
> guys,
> need to pitch tsearch2+postgresql- need some big names who use ts2?
http://search.postgresql.org, about 600,000 webpages and emails in the
archives.
//Magnus
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hannes Dorbath wrote:
> Bill Moran wrote:
>> It's a shame -- I get the impression that the rest of that error message
>> would help you fix the issue, but I don't remember what you can do about
>> it. Probably something to do with group policy, or some other setting
>> in the security realm.
>
>
Bruce Momjian wrote:
> Jan Muszynski wrote:
>> I found this thread (I'm posting here because I'm not subscribed to
>> Hackers)
>> http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg85241.html
>>
>> which seems to be talking about this issue. I'm just wondering what the
>> current status
On Mon, Mar 05, 2007 at 10:28:04AM -0500, [EMAIL PROTECTED] wrote:
> Here's something I've always wondered. When you dump a database, the dumped
> file
> looks like ordinary SQL, but if I load it into a query editor window and try
> to
> execute it, I always get syntax errors. The specific errors
On Mon, Mar 05, 2007 at 10:58:32AM -0500, [EMAIL PROTECTED] wrote:
> Quoting Magnus Hagander <[EMAIL PROTECTED]>:
>
> >It should work perfectly fine to restore it using psql -f on Windows as
> >well, I'd recommend that you look into why that's not working and tr
On Tue, Mar 06, 2007 at 10:02:31AM +, Desire Athow wrote:
> I am looking for a email list management solution (can be a script, an
> open source application etc), which uses Postgre SQL (AKA Postgres) as
> database.
>
> Can you let me know whether this rare bird exist?
IIRC, Sympa (www.sympa.
On Wed, Mar 07, 2007 at 07:46:16AM +0100, Martijn van Oosterhout wrote:
> On Tue, Mar 06, 2007 at 08:38:22PM +0200, andyk wrote:
> >This error is returned by libpq, as a reaction on WSANOBUFS error
> > from Windows Socket System. This means, applications tries to send much
> > data, and system
On Thu, Mar 08, 2007 at 09:56:23PM +0100, Jean-Michel Pouré wrote:
> Dear Friends,
>
> I am very impressed by TSearch2 and would like to thank Oleg and the
> team for their hard work.
>
> I would like to migrate a phpBB forum with more that 200.000 messages to
> TSeach. Full text searches have be
On Fri, Mar 09, 2007 at 12:12:42PM +0100, Steven De Vriendt wrote:
> Using Windows Xp I want to start pg_ctl as administrator.
> Reason for that I'm using Apache Tomcat and I can't seem to start that
> without Administrator privilges.
> Can someone tell me how do that ?
Make sure you use 8.2 and i
On Mon, Mar 12, 2007 at 02:20:44PM +0100, Joost Kraaijeveld wrote:
> Hi,
>
> The PostgreSQL of a customer database (running on Windows 2003) crashed
> and wrote the messages below in the logfile. According to the customer
> the drives are working OK, partitions are not full and nothing has
> chang
On Mon, Mar 12, 2007 at 02:46:22PM +0100, Joost Kraaijeveld wrote:
> On Mon, 2007-03-12 at 14:39 +0100, Magnus Hagander wrote:
>
> > What version of PostgreSQL is this?
> >
> Oh, forgotten: 8.1.x with no upgrade option (company policy)
It looks to me that you may be a vict
On Mon, Mar 12, 2007 at 10:13:48AM -0400, Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
> > It looks to me that you may be a victim of the bug patched in
> > http://archives.postgresql.org/pgsql-committers/2007-01/msg00214.php.
> > Tom, whatever happened
Jean-Michel Pouré wrote:
> IMHO, it would be better if PostgreSQL parser was able to find Tseach
> indexes alone, rewritting the query automatically. Maybe it is on the
> radar list of hackers.
How would you "rewrite a query automatically"? PostgreSQL will find it
automatically when you attempt t
Joost Kraaijeveld wrote:
It looks to me that you may be a victim of the bug patched in
>> http://archives.postgresql.org/pgsql-committers/2007-01/msg00214.php.
Tom, whatever happened about a backpatch for that one?
>>> It's applied.
>>>
>> http://developer.postgresql.org/cvsweb.cgi/p
George Weaver wrote:
> A client has PostgreSQL 8.2.1 installed on a Windows 2000 server.
>
> The time on the server is correct but PostgreSQL is returning a time 1
> hour in advance. In other words, it the server time is 1:00 pm,
> PostgreSQL is returning 2:00 pm. Both the PostgreSQL server and
Eric wrote:
> I am getting truly desperate! I am trying to build any version of
> Postgres on Windows from source. First experience with Postgres
> source. I have struggled for days trying to solve a problem. Would be
> willing to pay for the solution!!!
>
> The following error occurred when is
ither.
>
> Was thinking that maybe it's my PATH on Windows that could be fouling things
> up. I added the necessary bin dirs for pg and msys/mingw but have all types
> of MS items in the path too (which would be difficult to clean out). But
> I'm wondering if that's it.
&
On Wed, Mar 21, 2007 at 04:25:30PM +0300, Teodor Sigaev wrote:
> I can't reproduce your problem, but I have not Windows box, can anybody
> reproduce that?
>
>
> contrib_regression=# select version();
> version
>
> PostgreSQL 8.2.3 on i386-unknown-f
Bill Eaton wrote:
>>> I want to allow some queries for my users to run for a prescribed period
> of
>>> time and kill them if they go over time. Is there a good way to do this?
>
>> set statement_timeout perhaps?
>
> Ooh. I like that. It would be absolutely brilliant if I could figure out how
> t
Candy Gutierrez wrote:
> Hi,
>
> I just want to know if it is possible to install PostgreSQL 7.3.4 using
> Cygwin on a Windows 2003 Server R2 SP2 platform?
> I tried it several times but I couldn't create a database. But when I
> installed it on Windows 2003 Server (no SPs), it was
> successful.
Eric wrote:
> Thanks for responding Magnus.
>
> I did reinstall both msys and mingw, as well as blow away the source
> and start over from scratch. Maybe there is a stray file or directory
> that's not getting deleted on the clean. Also, does clean just clean
> up the compile environment, or doe
On Wed, Mar 21, 2007 at 09:13:55PM +0300, Teodor Sigaev wrote:
> >postgres=# select to_tsvector('test text');
> > to_tsvector
> >---
> > 'test text':1
> >(1 row)
> Ok. that's related to
> http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/wordparser/parser.c.diff?r1=1.1
Gerard Seibert wrote:
> FreeBSD-6.2
> (PostgreSQL) 8.2.3
>
> Occasionally, when booting up, I receive this error message:
>
>
>
> Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database
> system is starting up
>
>
>
> Since it only happens occasionally, I have not been able to figu
On Fri, Mar 30, 2007 at 12:19:44PM +0300, Andrus wrote:
> Any idea how to write server-side stored procedures in C# for PostgreSQL
> database ?
>
> In windows .NET 2 framework should be used and in Linuc/Mac/Windows MONO
> should be used for this.
>
> How to install MONO engine as server-side
Guy Rouillier wrote:
> Andrus wrote:
>> Last change for this project was 3 years ago.
>> So I think that it is dead.
>>
>> I'm writing application in C#.
>> I expected that I can wrote stored procedures in C# also using
>> something like mod_mono in Apache.
>>
>> So it seems that most reasonable w
On Tue, Apr 03, 2007 at 04:00:17AM -0400, Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
> > Both MS SQL Server and IBM DB2 (on windows) supports .net stored
> > procedures in C#, VB, or any other .net hosted language.
>
> Awhile back I read an article cl
On Tue, Apr 03, 2007 at 09:28:28AM +0100, Tim Perrett wrote:
> Hey all
>
> I am possibly looking to use PSGSQL in a project I am working on for a very
> large client. The upshot of this is the throughput of data will be pretty
> massive, around 20,000 new rows in one of the tables per day. We also
On Thu, Apr 05, 2007 at 07:57:41AM -0500, J. ORIOL wrote:
> Hello,
>
> I was in the archives, looking for some concrete info about
> inet_client_addr() use, but only a C function found.
>
> I have some clients to my app. (PG 8.2 in XP LAN). I want to generate
> auto-logs with trigger function f
Geoffrey wrote:
> Tom Lane wrote:
>> Geoffrey <[EMAIL PROTECTED]> writes:
>>> A backtrace against this process produces:
>>
>>> Program received signal SIGSEGV, Segmentation fault.
>>> 0x0814acc9 in FileAccess (file=168481968) at fd.c:717
>>> 717 if (FileIsNotOpen(file))
>>> (gdb) bt
>>
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> Geoffrey wrote:
>>> CREATE OR REPLACE FUNCTION pcm_getmiles_s(text,text,integer)
>>> RETURNS float8 AS '/esc/pgrnd/prog/libpcmiler'
>>> LANGUAGE 'c' WITH (isStrict);
>
On Tue, Apr 10, 2007 at 08:36:10AM +0100, Dave Page wrote:
> Andrew Hammond wrote:
> > On 4/9/07, CAJ CAJ <[EMAIL PROTECTED]> wrote:
> >> On 9 Apr 2007 14:47:20 -0700, Andrew Hammond
> >> <[EMAIL PROTECTED]> wrote:
> >> > I'm writing a script that wants to know the latest release for a given
> >> >
On Tue, Apr 10, 2007 at 09:52:52AM +0100, Dave Page wrote:
> Magnus Hagander wrote:
> > 2) Create a new file with a specific schema. Something like:
> >
> >
> >
> >
> > This is the most lightweight solution.
>
> More like:
>
>
>
On Tue, Apr 10, 2007 at 11:09:50AM +0200, Listmail wrote:
>
> I love Open Source XD
>
> http://ethan.tira-thompson.com/cvslog2web/
Hmm. Don't tell people about my secret plans :)
(Though I hadn't looked at that piece of software in particylar)
> Note that this is overkill (bu
On Tue, Apr 10, 2007 at 12:03:44PM +0100, Dave Page wrote:
> Magnus Hagander wrote:
> > On Tue, Apr 10, 2007 at 09:52:52AM +0100, Dave Page wrote:
> >> Magnus Hagander wrote:
> >>> 2) Create a new file with a specific schema. Something like:
> >>>
>
On Tue, Apr 10, 2007 at 12:35:38PM +0100, Dave Page wrote:
> Magnus Hagander wrote:
> > Terminology aside, why? The unit is "8.1" not "8" and "1". It makes no
> > sense to say you're on version 8, in the given context, so why should the
> >
On Tue, Apr 10, 2007 at 02:44:42PM +0200, Martijn van Oosterhout wrote:
> On Tue, Apr 10, 2007 at 12:18:52PM +0200, Magnus Hagander wrote:
> > But given that we might want to add things like this, having our own custom
> > XML format certainly makes a bit more sense, it might be h
On Tue, Apr 10, 2007 at 12:18:52PM +0200, Magnus Hagander wrote:
> On Tue, Apr 10, 2007 at 09:52:52AM +0100, Dave Page wrote:
> > Magnus Hagander wrote:
> > > 2) Create a new file with a specific schema. Something like:
> > >
> > >
> > >
>
On Wed, Apr 11, 2007 at 06:49:18PM +0200, Listmail wrote:
>
>
> >If someone wants the schema change, react *now*. Later on we can only
> >append to it, and not change it :)
>
> Since I like to complain...
>
>
>
> Suppose you someday add another dot, or a "b" for beta, wouldn't it
Beware that this is not a supported method, though. It often works, but
don't make it a part of your regular maintenance.
What you can do is use pg_cancel_query() to kick the session back out to
IDLE - that's fully suported, and it will drop any locks the process has,
so it shuold get rid of most
Guy Rouillier wrote:
> George Weaver wrote:
>>
>> Original Message From Guy Rouillier
>>
>>> http://www.postgresql.org/docs/techdocs.71. Color me dumb, but I
>>> can't figure a way to download the document "Apache 2.0, Tomcat 5.5,
>>> WARs & PostgreSQL 8.1 JDBC DataSources on Windows XP". When I
> > This sounds like a known bug in 8.2.x --- it's fixed for 8.2.4. If
> > you can still reproduce it with 8.2.4, please provide the test case.
>
> Hi Tom, thanks for the response.
>
> I must have missed it, but when was 8.2.4 released? I don't recall any
> announcement, and the website still s
> > I must have missed it, but when was 8.2.4 released? I don't recall any
> > announcement, and the website still says that 8.2.3 is the latest version.
> >
> > I'll download 8.2.4 tomorrow and report back on how I get on
>
> If I remember correctly, after a few "where's this new release" s
On Tue, Apr 24, 2007 at 05:53:02AM -0700, Jeff Lanzarotta wrote:
> Hello,
>
> I am writing an application that reads information from my PostgreSQL
> database. If I cause the program to crash and the program ends without
> gracefully disconnecting from the database, there is an open connection
> s
On Tue, Apr 24, 2007 at 06:55:12AM -0700, Jeff Lanzarotta wrote:
> OK, thanks. I figured the server would at some point in time clear the
> connection up, my question now is when does that happen? Any idea how
> long the connection sit around before the server cleans it up? Someone
> else said poss
Marcelo de Moraes Serpa wrote:
> Hello!
>
> I'd like to learn more about PostgreSQL (8.x) internal architecture so
> as to build C extensions and Stored Procedures in C. I think that I nice
> way to start is trying to compile PostgreSQL from the source. I'm on
> Windows XP PRO. I've found this art
Marcelo de Moraes Serpa wrote:
> Hello,
>
> I have compiled PostgreSQL 8.3devel using Microsoft Visual C++ 2005 but
> when I tried to start it (either by using the initdb.exe or
> postgres.exe) I receive the following error message:
>
> Message title: " postgres.exe - Entry point not found"
> Mes
Jim Nasby wrote:
> On Apr 24, 2007, at 8:50 PM, William Garrison wrote:
>> I have a server running Windows Server 2003 32-bit that has 8GB of
>> memory. Our system administrator installed PAE (Physical Address
>> Extensions) which I know MS SQL Server will use, but I'm not sure if
>> PostgreSQL wi
Tom Lane wrote:
> Michael Glaesemann <[EMAIL PROTECTED]> writes:
>> On Apr 30, 2007, at 16:39 , Tom Lane wrote:
>>> Yeah, Apple uses Postgres as a part of Remote Desktop, but I don't
>>> think
>>> they intend it for general use --- it deliberately uses a nonstandard
>>> port to avoid conflicting
Are you building with the same compiler as the backend was built with? If
you're using the binary distribution that means mingw unless you're testing the
pre-beta snapshot Dave uploaded a few days ago.
/Magnus
--- Original message ---
From: Islam Hegazy <[EMAIL PROTECTED]>
Sent: 5-2-'0
Islam Hegazy wrote:
> I have added the path to the include directory of postgresql but it
> hasn't already some of the files that are in linux include path like
> . It doesn't object about postgres.h which it can find now
> but it objects about strings.h
>
> I use MSVC6 to make my dll file.
The i
> I am trying out postgresql-8.3-dev1 on Windows XP SP2 and during the
> installation, I get the following error during the database cluster
> initialization :
This looks pretty interesting. Are you specifying an existing account for the
service or are you letting the installer create one? Any
On Fri, May 04, 2007 at 09:00:32AM +0200, Paolo Saudin wrote:
> I am trying to install the 8.3-dev version on a Vmware virtual machine with
> WinXP SP2. I am able to install the 8.2.4.1 version with no problem using
> the very same settings for both servers as follow:
There is no 8.2.4.1 version.
On Fri, May 04, 2007 at 09:38:48AM +0100, Dave Page wrote:
> Magnus Hagander wrote:
> >On Fri, May 04, 2007 at 09:00:32AM +0200, Paolo Saudin wrote:
> >>I am trying to install the 8.3-dev version on a Vmware virtual machine
> >>with
> >>WinXP SP2. I am able to
Stefano T wrote:
> Hi everybody.
> Well.. i've a probelm. pg doesn't start at boot. if i copy the string
> of command and try execute:
>
> C:\Programs\PostgreSQL\8.2\bin\pg_ctl.exe runservice -N "pgsql-8.2" -D
> "C:\Programs\PostgreSQL\8.2\data\"
> the output is:
> pg_ctl: could not start service
On Mon, May 07, 2007 at 05:31:02PM -0700, Ottavio Campana wrote:
> Hi, I'm trying to use tsearch2 for the first time and I'm having a
> problem setting up a query
>
> If I execute
>
> SELECT * from test_table where ts_desc @@ to_tsquery ('hello&world');
>
> it works, but I'm having the problem t
Ottavio Campana wrote:
> Magnus Hagander wrote:
>> On Mon, May 07, 2007 at 05:31:02PM -0700, Ottavio Campana wrote:
>>> Hi, I'm trying to use tsearch2 for the first time and I'm having a
>>> problem setting up a query
>>>
>>> If I
Dave Page wrote:
> novnov wrote:
>> I have python 2.4 installed; python24\lib in the path; why is the PL\python
>> option presented but disabled in 8.2 postgres installer? There must be some
>> conditions under which it (and the other langs) are enabled. The only one of
>> the 7 show that is enable
Cyril VELTER wrote:
>
> I'm trying to upgrade a pretty big database (60G) from postgres 8.0 to
> postgres 8.2 on windows 2000 Server (both version running on the same machine
> on different ports). During the migration process, I always get an error at
> some point (never the same) :
Int
On Mon, May 14, 2007 at 08:46:23PM -0300, marcelo Cortez wrote:
> hi all
>
> there any was successful with connect to postgres
> with psqlodbc in dsn less mode? It's wrong list for
> this subject? any pointer be appreciated
Certainly, all the time. For example (unix people close your eye
alled.
> Any suggestion will be appreciated?
>
> best regards
> MDC
>
> --- Magnus Hagander <[EMAIL PROTECTED]> escribió:
>
> > On Mon, May 14, 2007 at 08:46:23PM -0300, marcelo
> > Cortez wrote:
> > > hi all
> > >
> > > the
Tom Lane wrote:
> Richard Huxton <[EMAIL PROTECTED]> writes:
>> Hang on - did the US not alter the daylight-saving date recently? I'll
>> bet that's the issue.
>
> We're well past both the old and new change dates though, so for any
> combination of OS and Postgres knowing/not knowing about the l
Cyril VELTER wrote:
> No I'm not. It's not even complied in the server nor in the pg_dump
> binary.
>
> The server is built on windows using MSYS simply with ./configure &&
> make all
> && make install
>
>
> I've been able to reproduce the problem 6 times (at random po
Cyril VELTER wrote:
>> Cyril VELTER wrote:
>>> No I'm not. It's not even complied in the server nor in the pg_dump
> binary.
>>> The server is built on windows using MSYS simply with ./configure &&
>>> make
> all
>>> && make install
>>>
>>>
>>> I've been able to reproduce the p
Marek Lewczuk wrote:
> I understand that most of PostgreSQL core team aren't fans of Java,
> however ignoring this language (most popular programing language) and
> developers that uses Java in everyday work is not advisable if we want
> to make PostgreSQL more popular. Look at competing RDBMS - Or
Marek Lewczuk wrote:
> Magnus Hagander pisze:
>> Being a fan or not of the language really isn't the issue, and nobody is
>> *ignoring* the language and platform. We all know "the others" have it.
>> And we want it. But the core team (or more importantly in th
> Please forgive me if I'm posting to the wrong mailing list. I
> am working with Windows XP and the beta2-dev3 version of
> PostgreSQL. The issue I am having is under a login name that
> has administrative rights to the machine the program is
> running on (a program I wrote), database access i
L PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 14, 2004 9:34 AM
> To: [EMAIL PROTECTED]
> Cc: Magnus Hagander
> Subject: Re: [GENERAL] beta3 winxp initdb problems
>
> Magnus, et al.,
>
> This is, what initdb -d says:
>
>
>
> D:\tmp
>Hi,
>
>Most (but not all) of the time when I drop a database I receive the
>following warning:
>
>WARNING: could not remove database directory "c:/program
>files/PostgreSQL/8.0.0-beta3-dev1/data/base/X"
>
>Where X is the directory name of for the database being
>dropped. It's
>not a re
> Well, they were generated by MySQL and I can open them with
> e.g. the Windows Editor Notepad. But I don't know if they are
> actually encoded in UNICODE.
> Since I can open the file with Notepad and read the
> statements, I assume, it is not UNICODE. They look just like
> in the email below.
Title: Message
Some wishes
:
- The win32 install let choose an alternate disk
for the data ...
Already
supported. Just click the "Data Directory" entry in the feature tree, click
"Browse" and pick where you want the data directory.
-
The win32 install use the user variable P
> Hi all,
> I am throughly enjoying using Postgres 8.0 on Windows, so
> I can develop my Windows client against Postgres.
> I would like to write some pl/perl functions, and I'm a
> little stumped.
> Now comes the sad confession - I installed PG from the
> Windows installer rather than bu
> I have gone through the documentation that come with version
> 8 beta 4 and I have a number of questions.
>
> (1) backup/restore
> I notice that in the documentation, it seems to suggest that
> an online backup, made via pg_start_backup() and
> pg_stop_backup() functions would back up all dat
>> When I tried to subscribe I got:
>>
>>
>> Not Found
>>
>> The requested URL /mj/mj_wwwusr was not found on this server.
>
>How/where did you subscribe from? We made some changes this
>past weekend
>to deal with some issues that were reported, so the URL should be
>http://mail.postgresql.org/
When I tried to subscribe I got:
Not Found
The requested URL /mj/mj_wwwusr was not found on this server.
>>>
>>> How/where did you subscribe from? We made some changes this
>>> past weekend
>>> to deal with some issues that were reported, so the URL should be
>>> http
> Hi all,
>
> I'm using psql 8.0.0 on a client's site who's running win server 2003.
> We've had him on beta 3 for some time, and no problems at all
> (yes, in a sense, he is a beta tester as well, but doesn't
> know it!). Today I tried to upgrade the db to RC1 and had
> some problems.
>
> Re
your server log should point at what the actual issue is.
//Magnus
> -Original Message-
> From: A. Mous [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 22, 2004 5:41 PM
> To: Magnus Hagander; pgsql-general@postgresql.org
> Subject: RE: [GENERAL] 8.0 Beta3 worked, RC1 d
Title: Message
Please
check this: http://archives.postgresql.org/pgsql-hackers-win32/2004-12/msg00133.php
and report success/failure.
(I am
assuming the same problem. Please verify that the output in the postgres log is
the one about failure to attach to shared memory)
//Magnus
The MSI installer for RC3 is not yet ready. We expect it to
go out in the next couple of days.
//Magnus
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John
DoggettSent: Wednesday, January 05, 2005 6:13 PMTo:
pgsql-general@postgresql.orgSubject: [GENERAL] prob
>my team and I have to work with postgresql, apache and the umn
>mapserver for
>a student project. The only problem is that not one of us has
>ever worked
>with postgresql and now, after having installed the rc2
>Version for windows
>we don't know how to configure the software. After searching
The cancel function is implemented. See
http://developer.postgresql.org/docs/postgres/functions-admin.html#FUNCT
IONS-ADMIN-SIGNAL-TABLE.
Kill function was considered too dangerous.
//Magnus
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Tony Ca
You should run the Cygwin tools from Cygwin. They work fine against a
native backend.
//Magnus
> -Original Message-
>
> I have many database build scripts written for cygwin bash.
> These scripts use the cygwin port of postgres 7.4 and its
> client tools like psql, pg_dump etc.
> I hav
> > You should run the Cygwin tools from Cygwin. They work fine
> against a
> > native backend.
>
> Thanks, I'll have to wait for the port of P8.0.0 rc4 to
> cygwin as the current cygwin port of pg_dump is 8.0.0 B2 and
> does not work correctly for reason of the error 'column
> "nsptablespace
>rc5-2 msi will not install at all on a fat32 filesystem
>even without initialising the database.
Really? The code for checking the filesystem type is only executed if
you chose to initdb, so I really don't see this happening. Exactly what
message do you get?
>sorry but whole purpose of putting i
801 - 900 of 998 matches
Mail list logo
