[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: 42883:ERROR; expected 1.3.12 error

On Mon, Mar 12, 2012 at 06:38:31PM +0900, billy akazawa wrote:
> I've tried the following, but I'm definitely doing something wrong.
> ..hidden..:/home/billy# su postgres
> ..hidden..:/home/billy$ ALTER USER ledgersmb SUPERUSER;
> bash: ALTER: command not found
> Any help is greatly appreciated.

The ALTER USER command is a postgresql database command but is being run
from the shell, hence the error. You need to connect to the database as
the postgres user before issuing this command. eg:

	# su postgres
	$ psql
	postgres=# ALTER USER ledgersmb SUPERUSER;


Openstrike - improving business through open source
http://www.openstrike.co.uk/ or call 01722 770036 / 07092 020107

Attachment: pgpjwCpSd5PmJ.pgp
Description: PGP signature

Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
Ledger-smb-users mailing list