pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Fedora core 10: tcpip_socket = True
6+ messages / 3 participants
[nested] [flat]

* Fedora core 10: tcpip_socket = True
@ 2011-04-01 12:11 bilal ghayyad <bilmar_gh@yahoo.com>
  2011-04-01 15:43 ` Re: Fedora core 10: tcpip_socket = True raghu ram <raghuchennuru@gmail.com>
  2011-04-03 21:57 ` Re: Fedora core 10: tcpip_socket = True Devrim GÜNDÜZ <devrim@gunduz.org>
  0 siblings, 2 replies; 6+ messages in thread

From: bilal ghayyad @ 2011-04-01 12:11 UTC (permalink / raw)
  To: pgsql-admin

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



      



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fedora core 10: tcpip_socket = True
  2011-04-01 12:11 Fedora core 10: tcpip_socket = True bilal ghayyad <bilmar_gh@yahoo.com>
@ 2011-04-01 15:43 ` raghu ram <raghuchennuru@gmail.com>
  1 sibling, 0 replies; 6+ messages in thread

From: raghu ram @ 2011-04-01 15:43 UTC (permalink / raw)
  To: bilal ghayyad <bilmar_gh@yahoo.com>; +Cc: pgsql-admin

On Fri, Apr 1, 2011 at 5:41 PM, bilal ghayyad <bilmar_gh@yahoo.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fedora core 10: tcpip_socket = True
  2011-04-01 12:11 Fedora core 10: tcpip_socket = True bilal ghayyad <bilmar_gh@yahoo.com>
@ 2011-04-03 21:57 ` Devrim GÜNDÜZ <devrim@gunduz.org>
  2011-04-06 11:07   ` Re: Fedora core 10: tcpip_socket = True bilal ghayyad <bilmar_gh@yahoo.com>
  1 sibling, 1 reply; 6+ messages in thread

From: Devrim GÜNDÜZ @ 2011-04-03 21:57 UTC (permalink / raw)
  To: bilal ghayyad <bilmar_gh@yahoo.com>; +Cc: 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

Attachments:

  signature.asc (application/pgp-signature, 197B) download

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fedora core 10: tcpip_socket = True
  2011-04-01 12:11 Fedora core 10: tcpip_socket = True bilal ghayyad <bilmar_gh@yahoo.com>
  2011-04-03 21:57 ` Re: Fedora core 10: tcpip_socket = True Devrim GÜNDÜZ <devrim@gunduz.org>
@ 2011-04-06 11:07   ` bilal ghayyad <bilmar_gh@yahoo.com>
  2011-04-06 11:10     ` Re: Fedora core 10: tcpip_socket = True Devrim GÜNDÜZ <devrim@gunduz.org>
  0 siblings, 1 reply; 6+ messages in thread

From: bilal ghayyad @ 2011-04-06 11:07 UTC (permalink / raw)
  To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: pgsql-admin

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


      



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fedora core 10: tcpip_socket = True
  2011-04-01 12:11 Fedora core 10: tcpip_socket = True bilal ghayyad <bilmar_gh@yahoo.com>
  2011-04-03 21:57 ` Re: Fedora core 10: tcpip_socket = True Devrim GÜNDÜZ <devrim@gunduz.org>
  2011-04-06 11:07   ` Re: Fedora core 10: tcpip_socket = True bilal ghayyad <bilmar_gh@yahoo.com>
@ 2011-04-06 11:10     ` Devrim GÜNDÜZ <devrim@gunduz.org>
  2011-04-06 11:38       ` Re: Fedora core 10: tcpip_socket = True bilal ghayyad <bilmar_gh@yahoo.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Devrim GÜNDÜZ @ 2011-04-06 11:10 UTC (permalink / raw)
  To: bilal ghayyad <bilmar_gh@yahoo.com>; +Cc: pgsql-admin

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

Attachments:

  signature.asc (application/pgp-signature, 197B) download

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Fedora core 10: tcpip_socket = True
  2011-04-01 12:11 Fedora core 10: tcpip_socket = True bilal ghayyad <bilmar_gh@yahoo.com>
  2011-04-03 21:57 ` Re: Fedora core 10: tcpip_socket = True Devrim GÜNDÜZ <devrim@gunduz.org>
  2011-04-06 11:07   ` Re: Fedora core 10: tcpip_socket = True bilal ghayyad <bilmar_gh@yahoo.com>
  2011-04-06 11:10     ` Re: Fedora core 10: tcpip_socket = True Devrim GÜNDÜZ <devrim@gunduz.org>
@ 2011-04-06 11:38       ` bilal ghayyad <bilmar_gh@yahoo.com>
  0 siblings, 0 replies; 6+ messages in thread

From: bilal ghayyad @ 2011-04-06 11:38 UTC (permalink / raw)
  To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: pgsql-admin

You are right, it has been fixed.
Thanks.

Regards
bilal

--- On Wed, 4/6/11, Devrim GÜNDÜZ <devrim@gunduz.org> wrote:

> From: Devrim GÜNDÜZ <devrim@gunduz.org>
> Subject: Re: [ADMIN] Fedora core 10: tcpip_socket = True
> To: "bilal ghayyad" <bilmar_gh@yahoo.com>
> Cc: pgsql-admin@postgresql.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
> 


      



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2011-04-06 11:38 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-01 12:11 Fedora core 10: tcpip_socket = True bilal ghayyad <bilmar_gh@yahoo.com>
2011-04-01 15:43 ` raghu ram <raghuchennuru@gmail.com>
2011-04-03 21:57 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2011-04-06 11:07   ` bilal ghayyad <bilmar_gh@yahoo.com>
2011-04-06 11:10     ` Devrim GÜNDÜZ <devrim@gunduz.org>
2011-04-06 11:38       ` bilal ghayyad <bilmar_gh@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox