» »

Težave s POSTGRESQL 8.0 (TCP/IP)

Težave s POSTGRESQL 8.0 (TCP/IP)

nejcpirc ::

POZDRAVLJENI

Namestil sem POSTGRESQL 8.0 na WIN XP. Ko preverim delovanje, recimo v komandni vrstici mi javi naslednje:

C:\Program Files\PostgreSQL\8.0\bin>psql -h localhost
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

izsek iz posrgresql.conf:

listen_addresses = 'localhost'
port = 5432

To so pa tudi edini vrstici v postgresql.conf, ki sem jih odkomentiral.

Je težava v moji konfiguraciji ali je prišlo do napake pri sami namestitvi?

LP, Nejc
  • spremenilo: nejcpirc ()

frke ::

Ali je server sploh pognan?

nejcpirc ::

Kje ga poženem??
Start-programs-postgresql 8.0- START DATABASE?

Kako preverim?

LP, N

nejcpirc ::

Poskušal sem startati server:
C:\Program Files\PostgreSQL\8.0\bin>postmaster -d "c:\Program Files\PostgreSQL\8.0"\data
Execution of PostgreSQL by a user with administrative permissions is not
permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromises.

pa smo spet tam... kje sploh lahko vidim svoj uporabniški ID in kako potem izgleda ukaz za start serverja?

LP

nejcpirc ::

C:\Program Files\PostgreSQL\8.0\bin>createuser.exe
Enter name of user to add: nejc
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) n
createuser: could not connect to database template1: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?

WTF??

darh ::

najbrž zaganjaš stvar kot administrator... ccc...


http://archives.postgresql.org/pgsql-bugs/2004-09/msg00304.php
Excuses are useless! Results are priceless!

Zgodovina sprememb…

  • spremenil: darh ()

nejcpirc ::

"""najbrž zaganjaš stvar kot administrator... ccc..."""
hmmm.....

C:\Program Files\PostgreSQL\8.0\bin>initdb vajabaza
The files belonging to this database system will be owned by user "Nejc".
This user must also own the server process.

The database cluster will be initialized with locale Slovenian_Slovenia.1250.

creating directory vajabaza ... ok
creating directory vajabaza/global ... ok
creating directory vajabaza/pg_xlog ... ok
creating directory vajabaza/pg_xlog/archive_status ... ok
creating directory vajabaza/pg_clog ... ok
creating directory vajabaza/pg_subtrans ... ok
creating directory vajabaza/base ... ok
creating directory vajabaza/base/1 ... ok
creating directory vajabaza/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in vajabaza/base/1 ... Execution of PostgreSQL by a
user with administrative permissions is not
permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromises. See the documentation for
more information on how to properly start the server.
child process was terminated by signal 1
initdb: removing data directory "vajabaza"
????

Poskušam spremeniti uporabniško ime iz administratorja v navadnega userja......???
start->run-> in poženem: "runas /user:postgres cmd"

pridem v komandno vrstico, kjer me vpraša po passwordu(Enter the password for postgres: (ne vpišem ničesar, samo potrdim))
-ali ga sploh potrebujem(geslo), oziroma saj ga sploh nisem nastavil???)
Ko potrdim geslo(gesla ne vpišem) sem še vedno prijavljen kot administrator.....

LP

nejcpirc ::

pa zakaj se mi komandna vrstica v trenutku ko potrdim geslo zapre, kljub temu, da imam v windows direktoriju kjer imem ms_dos datoteko v properties, kjer imaš close on exit nimam obkljukano, se pravi da se konzola ne bi smela avtomatsko zapreti...???

darh ::

nwe zaganjaj programa iz windowsov... najprej start->run, notri napiši CMD in potem zaženi program ki teče v konzoli.
Excuses are useless! Results are priceless!


Vredno ogleda ...

TemaSporočilaOglediZadnje sporočilo
TemaSporočilaOglediZadnje sporočilo
»

Microsoftov SQL Server prihaja na Linux (strani: 1 2 3 )

Oddelek: Novice / Ostala programska oprema
12627957 (22642) noraguta
»

Nova različica podatkovne baze PostgreSQL 9.5 prinaša obilico novosti (strani: 1 2 )

Oddelek: Novice / Ostala programska oprema
5716944 (13810) McAjvar
»

PostgreSQL

Oddelek: Programiranje
101574 (1178) AaBoy
»

PostgreSQL 8.0 Beta

Oddelek: Novice / Ostala programska oprema
172318 (2318) krho
»

problemi

Oddelek: Slo-Tech
131134 (951) OZZY

Več podobnih tem