U can also start Postgres with skip-grant-tables option and thenafter
change the password
fore.g;
bin/psql -Upostgres --skip-grant-tables
Tim wrote:
Hi Rick,
Firstly there are likely to be an OS postgres user and a DB postgres user.
How you reset the OS user depends on if you are using windo
Hi Rick,
Firstly there are likely to be an OS postgres user and a DB postgres user.
How you reset the OS user depends on if you are using windows or linux, and
should be learned elsewhere.
Removing PostgreSQL was not the correct thing to do but If you reset or
remove the postgres user from your OS
Hi,
127001
today I wanted to login on Holdem Manager when the message popped up that my
computer "failed to connect server 127001". I looked the net for sollutions,
tried a few, including deleting postregql wich i tried and all didn;t work.
While I tried to reinstall postregql it asked for my pass
Craig James writes:
> On 6/17/11 11:51 AM, Shianmiin wrote:
>> We have a PostgreSQL 9.0.4 on CentOs for performance testing and we are
>> seeing the similar issue.
>> we have a "crazy" setup it has 1 database with 1000 identical schemas. There
>> are occasional I/O write storm
>> of over 100 MB/se
On 6/17/11 11:51 AM, Shianmiin wrote:
Tom Lane-2 wrote:
What's not apparent however is why the stats collector is writing disk
so much. 8.4 does have the logic change to not write stats out unless
something is asking to see them. So either it's really pre-8.4, or you
have a monitoring task tha
