Instalação do PostgreSQL 13 e PostGIS 3.1

[@alexiaribeiro9704]

Faço a instalação como vc fez, porém quando vou procurar o pgadmin não aparece.

[@geocursos]

Alexia, você tentou reinstalar? Pode ter acontecido algum problema na instalação!

[@alexiaribeiro9704]

@@geocursos sim. E não aparece do mesmo jeito. Tentei até editar o ambiente de variáveis, mas ao abrir o prompt de comando dá que não é reconhecido como arquivo interno

[@lellowbrasil]

amigo, o meu deu essa informação
'"C:\Program Files\PostgreSQL\13\bin\createdb.exe"' nÆo ‚ reconhecido como um comando interno
ou externo, um programa oper vel ou um arquivo em lotes.
Sabe me dizer como devo proceder?

[@geocursos]

Olá Fabian, esse erro deu onde?

[@luismendes2482]

@@geocursos quando abro o pgAdmin aparece esse erro.
.
.
.
pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe"
Runtime Config File: "C:\Users\Luis\AppData\Roaming\pgadmin
untime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe -s C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\Luis\AppData\Roaming
- CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_936_VEAAMWYKTCDUKPLL
- CHROME_RESTART: NW.js|O NW.js travou. Reiniciar agora?|LEFT_TO_RIGHT
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: DESKTOP-3TPI6IU
- ComSpec: C:\WINDOWS\system32\cmd.exe
- DriverData: C:\Windows\System32\Drivers\DriverData
- HOMEDRIVE: C:
- HOMEPATH: \Users\Luis
- LOCALAPPDATA: C:\Users\Luis\AppData\Local
- LOGONSERVER: \\DESKTOP-3TPI6IU
- NUMBER_OF_PROCESSORS: 4
- OneDrive: C:\Users\Luis\OneDrive
- OS: Windows_NT
- Path: C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Docker\Docker
esources\bin;C:\ProgramData\DockerDesktop\version-bin;C:\Program Files
odejs\;C:\Program Files (x86)\Yarn\bin\;C:\Users\Luis\AppData\Local\Microsoft\WindowsApps;;C:\Users\Luis\AppData\Local\Programs\Microsoft VS Code\bin
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: 924f00fb-7d23-46e0-ac7d-c3ec699979b8
- PGADMIN_INT_PORT: 53435
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 58 Stepping 9, GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: 3a09
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
- PUBLIC: C:\Users\Public
- SESSIONNAME: Console
- SystemDrive: C:
- SystemRoot: C:\WINDOWS
- TEMP: C:\Users\Luis\AppData\Local\Temp
- TMP: C:\Users\Luis\AppData\Local\Temp
- USERDOMAIN: DESKTOP-3TPI6IU
- USERDOMAIN_ROAMINGPROFILE: DESKTOP-3TPI6IU
- USERNAME: Luis
- USERPROFILE: C:\Users\Luis
- windir: C:\WINDOWS
--------------------------------------------------------
Traceback (most recent call last):
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: server
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py", line 98, in
app = create_app()
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\__init__.py", line 365, in create_app
db_upgrade(app)
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
flask_migrate.upgrade(migration_folder)
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\flask_migrate\__init__.py", line 96, in wrapped
f(*args, **kwargs)
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\flask_migrate\__init__.py", line 271, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\alembic\command.py", line 294, in upgrade
script.run_env()
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\alembic\script\base.py", line 490, in run_env
util.load_python_file(self.dir, "env.py")
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\alembic\util\pyfiles.py", line 97, in load_python_file
module = load_module_py(module_id, path)
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\alembic\util\compat.py", line 182, in load_module_py
spec.loader.exec_module(module)
File "", line 783, in exec_module
File "", line 219, in _call_with_frames_removed
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 93, in
run_migrations_online()
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\setup\..\..\migrations\env.py", line 86, in run_migrations_online
context.run_migrations()
File "", line 8, in run_migrations
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\alembic
untime\environment.py", line 813, in run_migrations
self.get_context().run_migrations(**kw)
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\alembic
untime\migration.py", line 561, in run_migrations
step.migration_fn(**kw)
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\migrations\versions\7c56ea250085_.py", line 23, in upgrade
db.engine.execute("ALTER TABLE server RENAME TO server_old")
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\base.py", line 2235, in execute
return connection.execute(statement, *multiparams, **params)
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\base.py", line 1003, in execute
return self._execute_text(object_, multiparams, params)
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\base.py", line 1172, in _execute_text
ret = self._execute_context(
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\base.py", line 1316, in _execute_context
self._handle_dbapi_exception(
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\base.py", line 1510, in _handle_dbapi_exception
util.raise_(
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
raise exception
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\default.py", line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: server
[SQL: ALTER TABLE server RENAME TO server_old]
(Background on this error at: sqlalche.me/e/13/e3q8)

[@geocursos]

@@luismendes2482 tentou reinstalar o PostgreSQL, ou até mesmo instalar uma nova versão do pgAdmin?