reset password
Author Message
HuanXue
Posts: 34
Posted 13:51 Oct 16, 2010 |

It's a litter weird.

It works well the day I installed it. I have created some tables on it.

But right now, when I start the server manually in control panel, it tells me that Error1314: A required privileges is not held by the client.

How to fix that?

I'm using the same Admin user as before.

cysun
Posts: 2935
Posted 10:16 Oct 17, 2010 |

If local PostgreSQL causes you too much trouble, just use the one on CS3. I've configured the PostgreSQL server on CS3 so that it can be accessed from anywhere (i.e. not just from campus computers). You can access it using any of the three clients: psql, pgAdmin, phpPgAdmin. Just use:

  • host: cs3.calstatela.edu (i.e. not localhost)
  • port: 5432
  • username: your cs3 account name (e.g. cs422stu31)
  • password: your cs3 account password
  • database: your cs3 account name (e.g. cs422stu31)
Last edited by cysun at 10:17 Oct 17, 2010.
HuanXue
Posts: 34
Posted 11:15 Oct 17, 2010 |

OK, I'll do that.