min" or "up2date install
> phppgadmin"
> Or webmin if you want to admin all server without having to use command
> line. http://www.webmin.com/
>
>
>
>
> -Original Message-
> From: Major Services
> To: Iñigo Martinez Lasala
> Cc: pgsql-admin@
sword" since you will
> have to enter password for any local operation in your server, but anyway,
> it's your decision.
>
> -Original Message-
> From: Major Services
> To: Iñigo Martinez Lasala
> Cc: [email protected]
> Subject: Re: [ADMIN] pass
reate a new user called dbadmin. It will ask you for a password
> for this user and some extra options. Response YES to all.
>
> Now you can connect remotely with this dbadmin user.
>
>
>
> -Original Message-
> From: Major Services
> To: Iñigo Martinez Lasala
ts. But anyway it's a requirement if you are goint to
> access remotely.
>
> Add this line in first place to your pg_hba.conf
> local all postgres ident sameuser
>
>
> Reload postgresql and launch createuser as postgres user.
>
>
>
- as postgres user "su - postgres", run "pg_ctl start -D /var/lib/pgsql"
>
>
> -Original Message-
> From: Major Services
> To: Paul Anderson
> Cc: [email protected]
> Subject: Re: [ADMIN] Restart failed with 'service postgresql restart'
'pg_ctl status' returns 'neither postmaster nor postgres running'.
Looking for help restart postgres.
Thanks
On Wed, Mar 3, 2010 at 9:58 AM, Major Services wrote:
> Where to look for postmaster.pid?
> It is not in the data directory. There is one file postmaster.op
id remove the
> postmaster.pid file, right?
>
> FATAL: lock file "postmaster.pid"already exists
>
>
> On 3/2/10 11:43 AM, Major Services wrote:
>>
>> Help me start the server.
>> As I mentioned in an earlier post today (subject: password
>> authenticati
Help me start the server.
As I mentioned in an earlier post today (subject: password
authentication failed for user postgres), 'service postgresql restart'
had stopped the server but *server
start failed*.
Step wise list of commands to be given would be great!
Do I need to login as postgres?
Bei
'*'.
>
> Cheers,
> Ken
>
> On Tue, Mar 02, 2010 at 07:19:47PM +0530, Major Services wrote:
> > pgstartup.log:
> >
> > The files belonging to this database system will be owned by user
> > "postgres".
> >
> >
> >
&
t;
[email protected]> wrote:
> Ah... ok.
> In /var/lib/pgsql you will find a file called pgstartup.log
> Could you post here last lines of this file ?
>
>
>
> -Original Message-
> *From*: Major Services
>
> >
> *To*: Iñigo Martinez Lasala
&
oes not have ident enabled...
>
> local all postgres trust
>
>
>
> -Original Message-
> *From*: Major Services
>
> >
> *To*: Iñigo Martinez Lasala
>
> >
> *Subject*: Re: [ADMIN] password authentication failed for user postgres
> *Date*: T
t place to your pg_hba.conf
> local all postgres ident sameuser
>
>
> Reload postgresql and launch createuser as postgres user.
>
>
> -Original Message-
> From: Major Services
> To: [email protected]
> Subject: [ADMIN] passwor
Hi,
1. I have added listen_addresses = '*' ; in postgresql.conf
2. And have made the following changes to pg_hba.conf
local DATABASEUSER METHOD
localsamegroup all password
hostDATABASEUSERCIDR-ADDRESS METHOD [OPTION]
host all all
13 matches
Mail list logo
