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.2ndQuadrant.com
PostgreSQL Training, Services and Support
2ndQuadrant Deutschland GmbH
GF
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 sgl...@hotmail.com:
In my attempts I changed all pg_hba.conf (8.4 9.0) to trusted, turned off
firewall,
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
/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 will take place in Birmingham - Stay tuned!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make
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 (pgsql-bugs@postgresql.org
@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 will take place in Birmingham
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://www.postgresql.org
-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-bugs@postgresql.org)
To make
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 take place in Vilnius
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
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
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
0173/9409607
fx
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!
---(end of broadcast)---
TIP 7: You can help support 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
/ 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 broadcast
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
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,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
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 PilichowskiEmail address:[EMAIL
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
). 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 can do select Asaf
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
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; a12345678
9 10lstore= update test.test set a = a + 2 where a =
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
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 bulk
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
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
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,
We
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 search,
good luck
HArald
--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
.
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
---(end of broadcast)---
TIP 6
://acm.bridgeovertw.com/hdfc/pl/landingpage/sep04/index.htm?sitecode=611|395
Apply.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
--
GHUM Harald Massa
Harald Armin Massa
Administrator. And in finish of installation I take this error.
Tanks for your help!
Estevan Rech
Software Developer
[EMAIL PROTECTED]
--
GHUM Harald Massa
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
---(end
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
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 idea. The
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
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 developers
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
of that 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 Armin Massa
FAQ of the installer to also find a link to
a tool to check, if this may be the prob. on your computer.
Harald
Failed to connect to database. Contrib files are installed, but are not
activated in any databases.
server closed the connection unexpectedly
--
GHUM Harald Massa
Harald Armin
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 our extensive FAQ
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
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 Admin
] )
--
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\binpostmaster.exe -i
WARNING: could not find a match
is 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
0173/9409607
45 matches
Mail list logo