ady installed / running
/ used PostrgeSQL on that computer, you can:
To solve your immediate problem:
within control panel go to management, users and group, and change the
password of the postgres user account to something you remember.
best wishes
Harald
--
Harald Armin Massa www.2ndQu
Please try to change you cuttent working directory to a place you have
Write-Access before pg_upgrade
As in cd \temp or cd %Home%
Harald
Am 12.10.2010 um 01:09 schrieb Chris English :
> In my attempts I changed all pg_hba.conf (8.4 & 9.0) to trusted, turned off
> firewall,
> followed instruc
The following bug has been logged online:
Bug reference: 4678
Logged by: Harald Armin Massa
Email address: haraldarminma...@gmail.com
PostgreSQL version: 8.3.5 / 8.3.6
Operating system: XPSP2, 2003, XP SP3, W7 Beta
Description:codepage UTF8 crashes psql
Details
iling list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009
this may be a real bad thing to do, and without them I would not
recommend it)
net user postgres /delete
- to change password
net user postgres NewPassWord98uL
best wishes
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409
some bad application overwrote some
DLLs..) :)
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!
--
Sent via pgsql-bugs mailing list (pgsq
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier
Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http:/
uid=windows-system-call-to-createguid()
??
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!
--
Sent via pgsql-bugs mailing list (pgsql-bu
with "latest release".
What could we improve on the website to make it more likely for you to
find that installer?
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will
# (same)
>
> Which seems better.
>
> AFAIK, the unit of random_page_cost and cpu_*_cost is now seq_page_cost.
>
> --
> Guillaume
>
> ---(end of broadcast)-------
> TIP 6: explain analyze is your friend
>
--
G
> There is one already:
>
> http://pgfoundry.org/projects/pgtray/
could it be bundled into the installer? There are more uses for a
database server then servers alone...
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
017
se , because some parsers will not
parse it correctly without that space. I guess some pure XML-Parsers may
have the same problem (and be it only the IE-XML-Parser)
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5
http://www.postgresql.org/about/donate
>
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!
--
GHUM Harald
the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!
g_log/ or windows event log on missing
ssl-server-key-files.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
---(end of broa
Leonid,I agree... but where is a descriptive message in the log.
a healthy:) data directory looks like this:baseglobalpg_clogpg_hba.confpg_ident.confpg_logpg_multixactpg_subtranspg_tblspcpg_twophasePG_VERSIONpg_xlogpostgresql.conf
postmaster.optspostmaster.pidand within pg_log there are log filesI
Leonid,It is strange but after I gave postmaster.exe process access to the Internet (changed my personal firewall settings), PostgreSQL service starts OK. Why does
postmaster.exe need access to the Internet?PostgreSQL / postmaster.exe do not need to connect to the Internet. But communication is do
Leonid,System Event Viewer has the follwoing entries:1. The PostgreSQL Database Server
8.1 service was successfully sent a startcontrol.2. The PostgreSQL Database Server 8.1 service entered the running state.3. The PostgreSQL Database Server 8.1 service entered the stopped state.
please look insid
p, asp). and quote is not a standard
Thanks
Asaf.
On 9/25/06, Harald Armin Massa <[EMAIL PROTECTED]
> wrote:
Asaf,this is not a bug. To use identifier names (identfiers = column-names, table-names, view-names...) with capital and small characters, you need to doublequote those names.
So you c
Asaf,this is not a bug. To use identifier names (identfiers = column-names, table-names, view-names...) with capital and small characters, you need to doublequote those names.So you can do select "Asaf" from "Avraham"
but not select Asaf from Avraham. This behaviour is documented and intended.Best
Maciej,this feature is scheduled for PostgreSQL 8.2 and allready in the release notes of that release, coming most likely eoty.HaraldOn 9/24/06,
Maciej Pilichowski <[EMAIL PROTECTED]> wrote:
The following bug has been logged online:Bug reference: 2649Logged by: Maciej PilichowskiEmai
Peter,> G:\pgsql\data\pg_xlog\0001010A00BDpropably a very stupid question: "G" - is that really a LOKAL drive at that server, or rather some NAS or similiar? I had the same error in one logfile one time, but there where a large amount of possible culprits (viral scanner, login script ch
Laurence,that error is correct:CREATE TABLE test.test( a int4 NOT NULL DEFAULT nextval('
test.test_a_seq'::regclass), CONSTRAINT pk PRIMARY KEY (a))WITHOUT OIDS;And then try an update:lstore=> select * from test.test; a 1 2 3 4 5 6 7 8
9 10lstore=> update test.test set a = a + 2 whe
Alvaro,How many database-wide vacuums did you run during these 9 months? I'm
smelling transaction Id wraparound in pg_class or some other systemcatalog.This has been known to happen. Please see the archives."database wide" vacuums have been very very seldom; I fear the only one was at initial db
Hello QuingQing,What is your file system, NTFS or FAT32? Is that table newly created?
File System is NTFS. That table was created with database installation, which was short after after release of PostgreSQL 8.0 - so that database was in use for > 9 months. That table is a central table of the appl
Quingqing,
no, it is definitely NOT a temp table. I know which table it is, because:
that "could not open relation ..." error message was exactly provokable
with "select * from repofeld", which is one of my tables in that
database.
(And that was the way it was passed on to me: my application put
I ran into a very strange disappearance of a postgresql data file.The environment:Windows XP professionalselect version(); PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)All datafiles are within c:\ghum\datathat part of the harddrive is only accessable to u
Denis,
$result = pg_query($db, "SELECT * FROM big_table");
you are reading a big result (as I suspect from big_table) into memory.
It is perfectly normal that this uses large amounts of memory.
[it would be rather suspicious if loading a big file / big resultset would not use big amounts of memo
Ruby,
to my heat-challenged ears and eyes this message looks as if the python
server side scripting "python" is built for python 2.3; and your
installed python is 2.4
So... I recommend installing python 2.3 and try again.
Harald2005/6/23, Ruby Murillo <[EMAIL PROTECTED]>:
Hi,
indows, and postgreSQL-Service-Account
does NOT have privileges to change these rights.
So, maybe this problem which eat much of my time is the same with you..
Harald
--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
ntivir software, with the id-stick
of X-Check Age Verfication and with some specifig VOIP software
distributed by telecom (which part ever)
Problem is with LSP (Layered service providers) grabbing the
Winsock-Conneciton in an "not documented" way.
So there you can start your
.pgadmin.org website.
and finally bugs concerning the core postgres (or all you cannot
direct :) may be sent to the pgsql-bugs mailinglist.
Best wishes,
Harald
--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
--
http://www.postgresql.org/docs/faqs/FAQ.html
>
--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
27;postgres'
> and in cluster I used too 'postgres' but other password, or other user, like
> Administrator. And in finish of installation I take this error.
>
>
>
> Tanks for your help!
>
>
>
> Estevan Rech
>
> Software Developer
> > I have read on the installation note file that postgres server will not
> > run with administrative permissions. I have read on your forum that this
> > happened because i have installed the beta version: is it true that this
> > happen only with the beta version?
It is written by the core dev
James,
that error is well documented in the PGINSTALLER-FAQ on pgfoundry.
Problem: "something" is interfering with socket-inheritance.
"something" most offen is some kind of "Layered service provider" as
is: Antivir software, Age Verfication Software..."
Workaround now: "something" has to be u
>ON UPDATE TO album WHERE new.pls_id != old.pls_id
> It works until new.pls_id or old.pls_id is null. The rule is still called
> (based on my test), but the "DO" query is not executed correctly. The
> values in "album_edit" are not updated.
To compare "NULL" to something is allways a bad ide
I switched "in place" from beta2 to beta3 on windows some weeks ago
(selfcompiled), no notable speed difference.
Did you the usual "analyze" ritual???
Are the indexes used? Did you compare the "explain" outputs?
Are the indexes really present?
Harald
---(end of broadcast
sponsible.
>
> Why not ommiting the administrator security on Windows builds?
>
> Ramzi
>
> -Original Message-
> From: Magnus Hagander [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 29, 2004 12:20 PM
> To: Ramzi Fadel; Harald Armin Massa
ly
--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
particular
installer package, to avoid "corrupted .msi file"?
Are you logged in locally to the server? Local Administrator? There
are various reports about problems with remote-console-installation
(but they do usually appear later :)) )
Harald
--
GHUM Harald Massa
Harald A
.2 (Build
3790.srv03_rtm.030324-2048)
Cheryl Bender
--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Chari,
> 1. All earlier versions of PostgreSQL are able to be editted via an ssh
> Shell or some other Unix-based platform.
within the postgresql directory there is a /bin directory. There you
will find psql.exe, which will allow you that shell access.
Within PG_ADMIN there is also a SQL-Butt
Question: Does the version 8.0 already have programmed date to be thrown?
Thank you
--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
---(end of broadcast)---
TIP 5: Have you checked o
n the same computer.
What can I change to make it work or to help diagnose the problem any further?
--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
---(end of broadcast)---
TIP 8: explain analyze is your friend
> PostgreSQL won't start because I'm logged on as a user with administrative
> rights.
That has be discussed in great detail during the pre-beta period. All
the arguments you do provide are quite correct and all of them have
been considered and discussed.
I myself did argue for "PostgreSQL as Adm
oadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED] )
>
--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Still running Postgresql 8.0 beta1 from the binary MSI Installer,
Windows XP Professional now Sevice Pack 2
Stopped the running service, started Postgresql from the command line
to get some debugging output:
C:\Programme\PostgreSQL\8.0-beta1\bin>postmaster.exe -i
WARNING: could not find a match
"postgres"
also pg_admin fails with the same error.
I was running 7.x pre beta on WIN32 before on the same computer.
What can I change to make it work or to help diagnose the problem any further?
--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
01
50 matches
Mail list logo
