Re: [BUGS] problems instaling

[gildas prime]

You have a previous postgres user installed in your computer, you can delete it 
(if no longer used…) with the command : net.exe user postgres /delete

  _  

De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de filipe moreira
Envoyé : mardi 8 juillet 2008 01:06
À : pgsql-bugs@postgresql.org
Objet : [BUGS] problems instaling

 

Hello support
 
Im having problem instaling postgresql.
 
I nead the program to use poker tracker in windows vista.
 
when im finishin the instalation apears this message: (User "postegres" could 
not be created: The user account already exists.!)
 
Can you help me??
 
thanks



 
Filipe Moreira



  _  

Conheça já o Windows Live Spaces, o site de relacionamentos do Messenger! Crie 
já o seu!  

Re: [BUGS] BUG #4562: ts_headline() adds space when parsing url

[gildas prime]

Same thing on 8.3.5 Win32


ester=# SELECT ts_headline('http://some.url/path', to_tsquery('sometext'));
  ts_headline
---
 http:// some.url/path
(1 row)

ester=# SELECT ts_headline('http://some.url', to_tsquery('sometext'));
   ts_headline
-
 http://some.url
(1 row)

ester=#

Gildas

-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Denis Monsieur
Envoyé : jeudi 4 décembre 2008 00:33
À : pgsql-bugs@postgresql.org
Objet : [BUGS] BUG #4562: ts_headline() adds space when parsing url


The following bug has been logged online:

Bug reference:  4562
Logged by:  Denis Monsieur
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.3.4
Operating system:   Debian etch
Description:ts_headline() adds space when parsing url
Details: 

My system is 8.3.4, but people in #postgresql with 8.3.5 have confirmed the
issue.

The problem is a space being added to text in the form of
http://some.url/path
Compare the output:

shs=# SELECT ts_headline('http://some.url', to_tsquery('sometext'));
   ts_headline
-
 http://some.url
(1 row)

shs=# SELECT ts_headline('http://some.url/path', to_tsquery('sometext'));
  ts_headline
---
 http:// some.url/path
(1 row)

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #4108: PgInstaller Update modify install paths in Registry

[Gildas PRIME]

The following bug has been logged online:

Bug reference:  4108
Logged by:  Gildas PRIME
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system:   XP Professionnal
Description:PgInstaller Update modify install paths in Registry
Details: 

On the update of an existing PostGreSQL install 8.3.1 to 8.3.1 version
causes some bad modifications in the  Windows registry.

To reproduce this bug : 
1 - install PostGreSQL 8.3.1 into a directory different from the default
directory (by example : C:\Program Files\My Install\My PostGreSQL Install).I
insatll it with command line to have a slient install.
2 - Check in
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\{B823632F-3B72-4514-886
1-B961CE263224}\
the keys "Base Directory" and "Data Directory" and in
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\pgsql-8.3
the key Data Directory the Directories must be the path where you install
the PostGreSQL
3 - Launch the update.bat file present in the PostGreSQL installer archive
4 - Check again the different Keys, the values have changed to the "by
default" directory of PostGreSQL installation (C:\Program
Files\PostgreSQL\8.3\)...

PC : XP Professional French SP2 - Pentium 4 3.2Ghz - 1,5 Go RAM

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4108: PgInstaller Update modify install paths in Registry

[gildas prime]

To reproduce it quickly type in a MSDOS command to install :

msiexec /i "C:\Documents and Settings\gildas\Bureau\postgresql-8.3-int.msi" 
/qb! INTERNALLAUNCH=1 ADDLOCAL=server,psql BASEDIR="C:\Program Files\TOTO" 
DATADIR="C:\Program Files\TOTO\data" SERVICEDOMAIN="GILDAS" CREATESERVICEUSER=1 
SERVICEPASSWORD="postgresql" SERVICEPASSWORDV="postgresql" 
SUPERUSER="superuser" SUPERPASSWORD="superuser" SUPERPASSWORDV="superuser" 
ENCODING="WIN1252" PERMITREMOTE=1 PL_PGSQL=1 NOSHORTCUTS=1 ADMINPACK=0"

 

This will install silently Postgres to C:\Program Files\TOTO and datas will be 
in C:\Program Files\TOTO\data, this could be verified in the service 
parameters, for that click properties on the postgres service and see at the 
end of the command line, or go into registry 
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgsql-8.3 and see the 
ImagePath key (in the two cases the -D option is set to the correct postgresql 
data path).

 

Then, update the version that you have installed (imagine that you have a 
problem... imagine...) with the command line :

msiexec /i "C:\Documents and Settings\gildas\Bureau\postgresql-8.3-int.msi" 
REINSTALLMODE=vamus REINSTALL=ALL /qb!

 

this will reinstall the postgresql, but, your postgresql data path will be 
erased by tha by default postgresql data directory in the command line of the 
service... (C:\Program Files\TOTO\bin\pg_ctl.exe" runservice -w -N "pgsql-8.3" 
-D "C:\Program Files\PostgreSQL\8.3\data\)