Re: Fedora core 10: tcpip_socket = True

Hi All;

I am root and when I do ls /var/lib/pgsql/data, I do not see anything.

Why?

I need to find the pg_h.conf file but not able.

Any help?
Regards
Bilal

Zitat von bilal ghayyad <bilmar_gh(at)yahoo(dot)com>:

> Hi All;
>
> I am root and when I do ls /var/lib/pgsql/data, I do not see anything.
>
> Why?
>
> I need to find the pg_h.conf file but not able.

"find / -name pg_hba.conf" is your friend...

Regards

Andreas

On Thu, 2011-03-31 at 04:17 -0700, bilal ghayyad wrote:
> I am root and when I do ls /var/lib/pgsql/data, I do not see
> anything.
>
> Why?

You need to initdb first. I think this is an RPM installation. If so,

service postgresql initdb
(or service postgresql-9.0 initdb , depending on the version) would
work.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

bilal ghayyad <bilmar_gh(at)yahoo(dot)com> writes:

> Hi All;
>
> I am root and when I do ls /var/lib/pgsql/data, I do not see anything.

Try the 'locate' command is it's on your system.

If you are able to connect to the DB, show data_directory;

Or, sudo su - postgres and see if $PGDATA is set.

ps -ef might even show something after the -D option for some sites if
DB is running also.

> Why?
>
> I need to find the pg_h.conf file but not able.

Do you mean pg_hba.conf?

> Any help?
> Regards
> Bilal

--
Jerry Sievers
e: gsievers19(at)comcast(dot)net
p: 305.321.1144

Mine is Fedora 10, how it will be?

regards
bilal

--- On Thu, 3/31/11, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> wrote:

> From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
> Subject: Re: [ADMIN] ls /var/lib/pgsql/data nothing
> To: "bilal ghayyad" <bilmar_gh(at)yahoo(dot)com>
> Cc: pgsql-admin(at)postgresql(dot)org
> Date: Thursday, March 31, 2011, 7:27 AM
> On Thu, 2011-03-31 at 04:17 -0700,
> bilal ghayyad wrote:
> > I am root and when I do ls  /var/lib/pgsql/data,
> I do not see
> > anything.
> >
> > Why?
>
> You need to initdb first. I think this is an RPM
> installation. If so,
>
> service postgresql initdb
> (or service postgresql-9.0 initdb  , depending on the
> version) would
> work.
>
> Regards,
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified
> Engineer
> Community: devrim~PostgreSQL.org,
> devrim.gunduz~linux.org.tr
> http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
>

On Thu, 2011-03-31 at 04:37 -0700, bilal ghayyad wrote:
> Mine is Fedora 10, how it will be?

I already wrote what you need to do.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

Thanks a lot.

And how to make it started automatically when the machine booted? Without need to type the command to start manuall?

Regards
Bilal

--- On Thu, 3/31/11, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> wrote:

> From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
> Subject: Re: [ADMIN] ls /var/lib/pgsql/data nothing
> To: "bilal ghayyad" <bilmar_gh(at)yahoo(dot)com>
> Cc: pgsql-admin(at)postgresql(dot)org
> Date: Thursday, March 31, 2011, 7:27 AM
> On Thu, 2011-03-31 at 04:17 -0700,
> bilal ghayyad wrote:
> > I am root and when I do ls  /var/lib/pgsql/data,
> I do not see
> > anything.
> >
> > Why?
>
> You need to initdb first. I think this is an RPM
> installation. If so,
>
> service postgresql initdb
> (or service postgresql-9.0 initdb  , depending on the
> version) would
> work.
>
> Regards,
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified
> Engineer
> Community: devrim~PostgreSQL.org,
> devrim.gunduz~linux.org.tr
> http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
>

On Thu, 2011-03-31 at 05:52 -0700, bilal ghayyad wrote:
> And how to make it started automatically when the machine booted?
> Without need to type the command to start manuall?

chkconfig postgresql on
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

Hi All;

I read that I have to set the tcpip_socket = True in postgresql.conf file, but when I am setting it, the postgresql database failed to start.

My linux is fedora core 10, so what I have to do?

tcpip_socket = True

Regards
Bilal

On Fri, Apr 1, 2011 at 5:41 PM, bilal ghayyad <bilmar_gh(at)yahoo(dot)com> wrote:

> Hi All;
>
> I read that I have to set the tcpip_socket = True in postgresql.conf file,
> but when I am setting it, the postgresql database failed to start.
>
> My linux is fedora core 10, so what I have to do?
>
> tcpip_socket = True
>

Could you please share below information::

1. Which version of PostgreSQL running on your Environment.

psql=# select version();

--Raghu Ram

>
> Regards
> Bilal
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

On Fri, 2011-04-01 at 05:11 -0700, bilal ghayyad wrote:
> I read that I have to set the tcpip_socket = True in postgresql.conf
> file, but when I am setting it, the postgresql database failed to
> start.

tcpip_socket was a < 8.0 parameter IIRC. You are using 8.4 IIRC, and by
default it listens to localhost. See listen_addresses parameter.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

Dear Devrim;

Thanks a lot, u r right.

But it look like that now the postgresql has been crashed (really I do not know why suddenly I found it stop .. but what I expect that there were a lot of wrong queries are running).

I am not sure if a block happened due to something wrong ..

I ran yum remove postgresql postgresql-devel postgresql-server, also I remove the directory /var/lib/pgsl and I reinstall, then I ran again service postgresql initdb.

But still I am not able to start the postgresql (it is giving fail).

What could be the reason for the fail to start the postgresql? How I can do a complete remove for it (what other than pgsql directory need to be removed?) Where could be the problem?

Appreciate ur kindly help.
Regards
Bilal

On Wed, 2011-04-06 at 04:07 -0700, bilal ghayyad wrote:
> I ran yum remove postgresql postgresql-devel postgresql-server, also I
> remove the directory /var/lib/pgsl and I reinstall, then I ran again
> service postgresql initdb.
>
> But still I am not able to start the postgresql (it is giving fail).
>
> What could be the reason for the fail to start the postgresql?

Please see

/var/lib/pgsql/pgstartup.log

and tell us what's inside that log file.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

You are right, it has been fixed.
Thanks.

Regards
bilal

--- On Wed, 4/6/11, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> wrote:

> From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
> Subject: Re: [ADMIN] Fedora core 10: tcpip_socket = True
> To: "bilal ghayyad" <bilmar_gh(at)yahoo(dot)com>
> Cc: pgsql-admin(at)postgresql(dot)org
> Date: Wednesday, April 6, 2011, 7:10 AM
> On Wed, 2011-04-06 at 04:07 -0700,
> bilal ghayyad wrote:
> > I ran yum remove postgresql postgresql-devel
> postgresql-server, also I
> > remove the directory /var/lib/pgsl and I reinstall,
> then I ran again
> > service postgresql initdb.
> >
> > But still I am not able to start the postgresql (it is
> giving fail).
> >
> > What could be the reason for the fail to start the
> postgresql?
>
> Please see
>
> /var/lib/pgsql/pgstartup.log
>
> and tell us what's inside that log file.
>
> Regards,
> --
> Devrim GÜNDÜZ
> Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
> PostgreSQL Danışmanı/Consultant, Red Hat Certified
> Engineer
> Community: devrim~PostgreSQL.org,
> devrim.gunduz~linux.org.tr
> http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
>