Re: Fwd: postgresql databases disappearing and reappearing and disappearing on localhost - Postgresql x649.3 on Windows 8.1 (64)

On 4 August 2015 at 17:02, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

> On 08/04/2015 07:48 AM, Killian Driscoll wrote:
>
> CCing list
>
> FYI, I will be away from my computer. Someone else will have to follow up
> to my questions below.
>
>>
>>
> So that is not the server you set up, correct?
>>
>>
>> I am using the postgresql on localhost 5432. The OpenGeo\pgsql is
>> something I set up to test, but ended up not using it. It runs on a
>> localhost 8000, but could uninstall it as I'm not going to use that
>> program.
>>
>>
>> Can you access it and see what is in it?
>>
>>
>> When I access it on localhost 8000 it shows the Geoserver with the test
>> tables I included from my main db
>>
>
> So in pgAdmin do you see both servers?

In pgadmin only one server - 5432 - is listed. (I don't remember how I
imported the table to the 8000 Geoserver: I think it was via QGIS)

>
>
>
>>
>>
>> What does the Postgres log show when you connect? - where can I
>> find the
>> postgres log?
>>
>>
>> http://www.pgadmin.org/docs/1.20/status.html
>>
>>
>> The log shows the main db only:
>>
>> FATAL the database system is starting up
>> LOG database system was interrupted; last known up at 2015-07-31
>> 03:37:41 EDT
>> LOG database system was not properly shut down; automatic recovery in
>> progress
>> LOG record with zero length at 0/5B392220
>> LOG redo is not required
>> LOG database system is ready to accept connections
>> LOG autovacuum launcher started
>> ERROR schema "pgagent" does not exist
>> STATEMENT SELECT pgagent.pgagent_schema_version()
>> ERROR relation "pgagent.pga_jobagent" does not exist at character 59
>> STATEMENT INSERT INTO pga_tmp_zombies (jagpid) SELECT jagpid FROM
>> pgagent.pga_jobagent AG LEFT JOIN pg_stat_activity PA ON jagpid=pid
>> WHERE pid IS NULL
>> ERROR relation "pgagent.pga_jobagent" does not exist at character 13
>> STATEMENT INSERT INTO pgagent.pga_jobagent (jagpid, jagstation)
>> SELECT pg_backend_pid(), 'KillianAcer.homestation'
>> ERROR schema "pgagent" does not exist
>> STATEMENT SELECT pgagent.pgagent_schema_version()
>> LOG could not receive data from client: No connection could be made
>> because the target machine actively refused it.
>>
>> ERROR syntax error at or near " " at character 1
>> STATEMENT
>> l
>> "\l" meta command"\l" meta command"\l" meta command
>> select osm from pg_database
>> select osm from pg_database;
>> LOG could not receive data from client: No connection could be made
>> because the target machine actively refused it.
>>
>
> Well this seems to be your problem.
>
> Have you changed your pg_hba.conf recently?
>

I don't think so: if that file is here C:\Program Files\PostgreSQL\9.3\data
I don't think I made any changes

>
>
>> LOG invalid length of startup packet
>> ERROR relation "public.gt_pk_metadata" does not exist at character 15
>> STATEMENT SELECT * FROM public.GT_PK_METADATA WHERE 1 = 0
>>
>>
>>
>> What user are you connecting as, and what privileges does that
>> user
>> have? - I had set it up as one user/owner.
>>
>>
>> So from here:
>>
>> http://www.pgadmin.org/docs/1.20/main.html
>>
>> You can find the users(roles) and their privileges.
>>
>>
>> The is one user - me as postgres, a superuser
>>
>>
>>
>>
>> Killian Driscoll
>> Banting Postdoctoral Fellow
>> Département d'anthropologie
>> Université de Montréal
>>
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>