pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
help me
19+ messages / 16 participants
[nested] [flat]

* help me
@ 2000-08-16 17:58  Baley OUATTARA <ouattara@ivoiris.ci>
  0 siblings, 1 reply; 19+ messages in thread

From: Baley OUATTARA @ 2000-08-16 17:58 UTC (permalink / raw)
  To: pgsql-bugs@postgresql.org

i have a problems for deploying database POSTGRESQL ON MY OS linux

first point is :
i want to  put the data of database in another location, what can i do at
installation and after installation


second point is:
when the location is full what can i do for extend the database in the nex
location

third point is
i have a file whom is containt the texte in ascii with delimiters the field
is ";" , when i use:
	 "COPY mytable From file delimiters ";"
this command return error
"COPY command, running in backend with effective uid 40 , could not open
file '/home/ouatt/yyy208' for reading errno=permission denied (13)"

baley@ivoiris.ci




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

* Re: [BUGS] help me
@ 2000-08-17 06:19  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  parent: Baley OUATTARA <ouattara@ivoiris.ci>
  0 siblings, 0 replies; 19+ messages in thread

From: Stephan Szabo @ 2000-08-17 06:19 UTC (permalink / raw)
  To: Baley OUATTARA <ouattara@ivoiris.ci>; +Cc: pgsql-admin


[Set mailing list to admin, since admin seems more appropriate than
bugs]

On Wed, 16 Aug 2000, Baley OUATTARA wrote:

> i have a problems for deploying database POSTGRESQL ON MY OS linux
> 
> first point is :
> i want to  put the data of database in another location, what can i do at
> installation and after installation

Do you mean all databases or a specific one?
I believe initdb takes an argument that will let it set the data directory
(although you will also have to tell the backend where it is).  For
a specific database, there is a mechanisms for saying create
in this location, but it seems a little hard to use.  You can also use
symlinks (Big problem with symlinks is restoring the database, since you
have to remember that you moved it in the first place)

> second point is:
> when the location is full what can i do for extend the database in the nex
> location

As of 7.0 it's fairly wierd.  You need to use symlinks to move the 
databases (tables, indexes, etc) around.  And, I'm not sure if it's safe
to make the symlinks for non-existant segments, so new segments would
probably be created in the databases directory until moved.  There's
been some talk on -hackers about changing some of this stuff, so you
might want to check out the archives.
 
> third point is
> i have a file whom is containt the texte in ascii with delimiters the field
> is ";" , when i use:
> 	 "COPY mytable From file delimiters ";"
> this command return error
> "COPY command, running in backend with effective uid 40 , could not open
> file '/home/ouatt/yyy208' for reading errno=permission denied (13)"

You probably really wanted \copy not COPY.  IIRC COPY runs as the postgres
user (and on the server), who may not have access to the file in another
user's home directory, whereas \copy is from the client and uses the
client's file permissions.





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

* Help me!
@ 2002-04-16 14:22  Dieudonne Nanga <nanga@compilion.de>
  0 siblings, 2 replies; 19+ messages in thread

From: Dieudonne Nanga @ 2002-04-16 14:22 UTC (permalink / raw)
  To: pgsql-admin

How do i insert a file in the database?



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

* Re: Help me!
@ 2002-04-16 20:39  Sonia Sanchez Diaz <sonny@piaget.dgsca.unam.mx>
  parent: Dieudonne Nanga <nanga@compilion.de>
  1 sibling, 0 replies; 19+ messages in thread

From: Sonia Sanchez Diaz @ 2002-04-16 20:39 UTC (permalink / raw)
  To: Dieudonne Nanga <nanga@compilion.de>; +Cc: pgsql-admin



Hello there!

psql# \copy "table_name" from /path/from/file/to_copy

Regards

Sonny



On Tue, 16 Apr 2002, Dieudonne Nanga wrote:

> How do i insert a file in the database?
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 




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

* Re: Help me!
@ 2002-04-17 05:29  Bhuvan A <bhuvansql@yahoo.com>
  parent: Dieudonne Nanga <nanga@compilion.de>
  1 sibling, 0 replies; 19+ messages in thread

From: Bhuvan A @ 2002-04-17 05:29 UTC (permalink / raw)
  To: Dieudonne Nanga <nanga@compilion.de>; +Cc: pgsql-admin


On Apr 16, Dieudonne Nanga wrote:

> How do i insert a file in the database?

You mean large objects?
If yes, try

# select lo_import('<filename>');

this will return a OID.
and to access the same, try

# select lo_export(<oid>, '<filename>');

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 




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

* help me!!
@ 2003-02-12 10:41  XIE, Rong <rong.xie@stud.tu-muenchen.de>
  0 siblings, 1 reply; 19+ messages in thread

From: XIE, Rong @ 2003-02-12 10:41 UTC (permalink / raw)
  To: "Undisclosed-Recipient:;"@postgresql.org

Hello, 

My name is rong xie. I am a Student at TU-Munich.
I have a question to Postgresql an Linux. 
e.g:
for IBM DB2: I can write a test.sql file.

--test.sql
connect to database1;
set schema xie;
select * from table1;
insert table1 value('rong','xie',22);
select * from table1;
terminate;

Then I can execute the file "test.sql" in terminal.
db2 -tvf test.sql

In mysql: I can execute it so.
mysql > test.sql

How can I execute it in Postgresql?
is there similar command in linux for Postgresql?

Thank you very mach!

Best wish!

rong xie 

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

* Re: [ADMIN] help me!!
@ 2003-02-13 19:21  Andres Ledesma <aledes@telefonica.net>
  parent: XIE, Rong <rong.xie@stud.tu-muenchen.de>
  0 siblings, 0 replies; 19+ messages in thread

From: Andres Ledesma @ 2003-02-13 19:21 UTC (permalink / raw)
  To: rx <rong.xie@stud.tu-muenchen.de>; +Cc: pgsql-general@postgresql.org

hi rong...

well...is the postmaster running ? 

there are a couple of postintallation steps ...

    first, you must create and prepare the data files.
    lets assume your pgSQL is installed on /usr/local/pgsql, right ? 

    1 . make dir where your data files are going to live, say data
        root# mkdir /usr/local/pgsql/data

    2 . lets make user postgres the owner of this dir
        root# chown postgres /usr/local/pgsql/data    

    3 . let postgres init dababase on this dir
        root# su postgres
        postgres# /usr/local/pgsql/bin/initdb -D  /usr/local/pgsql/data

    4 . start the postmaster..
        set the environment var PGDATA=/usr/local/pgsql/data
        postgres# /usr/local/pgsql/bin/postmaster -i

        -i allows tcp  connections to the db. 

    5 .start the client 
        postgres# /usr/local/pgsql/bin/psql

        There is are various front end GUI's to postgres..one I use is pgAccess-- go to their page and lurk a bit .. 

  If you don't have the postgresql docs, you should take it on the postgresql.org site because there are a lot of options to postgresql be compiled with depending on further use you are going to do..to conect via  Java, C++... and any way...printing this docs you'll find most of your answers faster. There are the admin, programmer, user...guides..and a small tutorial..

    Good luck .. and best regards,

Andrew

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

* Re: Help me
@ 2003-09-13 01:58  Tran Anh Tu <trantu@vnu.edu.vn>
  0 siblings, 1 reply; 19+ messages in thread

From: Tran Anh Tu @ 2003-09-13 01:58 UTC (permalink / raw)
  To: scott.marlowe <scott.marlowe@ihs.com>; pgsql-php@postgresql.org

Hi all!
I had started postgresql perfecly, thank you very much.
After I start postgresql with command:
/etc/init.d/postgresql start
and I created a database: "waterdb" and a user: "trantu" with 
password "xxxx".Then I installed phpPgAdmin 3.0.1 with following lines in 
config.inc.php:
$conf['servers'][0]['desc'] = 'gis-iti'; 
$conf['servers'][0]['host'] = '10.6.1.61'; // or ''
$conf['servers'][0]['port'] = 5432;
$conf['servers'][0]['defaultdb'] = 'waterdb'; 

When I run phpPgAdmin and login with the user "postgres" or "trantu", all 
are failed. I had try to start postgres with command:
postmaster -i
and run phpPgAdmin but there is no change.
Please hepl me!
*******************************************************
Tran Anh Tu
Vien CNTT - DHQG Ha Noi
Phone: 047680417-25   Email trantu@vnu.edu.vn
*******************************************************


-----Original Message-----
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Tran Anh Tu <trantu@vnu.edu.vn>
Date: Fri, 12 Sep 2003 09:09:19 -0600 (MDT)
Subject: Re: [PHP] Help me

> P.s. you should be able to get it so start as root with:
> 
> service pgsql start
> 




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

* Re: Help me
@ 2003-09-13 13:50  Martin Marques <martin@bugs.unl.edu.ar>
  parent: Tran Anh Tu <trantu@vnu.edu.vn>
  0 siblings, 1 reply; 19+ messages in thread

From: Martin Marques @ 2003-09-13 13:50 UTC (permalink / raw)
  To: Tran Anh Tu <trantu@vnu.edu.vn>; +Cc: pgsql-php@postgresql.org

El Vie 12 Sep 2003 22:58, escribió:
> Hi all!
> I had started postgresql perfecly, thank you very much.
> After I start postgresql with command:
> /etc/init.d/postgresql start
> and I created a database: "waterdb" and a user: "trantu" with
> password "xxxx".Then I installed phpPgAdmin 3.0.1 with following lines in
> config.inc.php:
> $conf['servers'][0]['desc'] = 'gis-iti';
> $conf['servers'][0]['host'] = '10.6.1.61'; // or ''
> $conf['servers'][0]['port'] = 5432;
> $conf['servers'][0]['defaultdb'] = 'waterdb';
>
> When I run phpPgAdmin and login with the user "postgres" or "trantu", all
> are failed. I had try to start postgres with command:
> postmaster -i
> and run phpPgAdmin but there is no change.

Error messages?
PostgreSQL logs?
Apache, or PHP logs?
Did you check your pg_hba.conf file to see if you have access to that database 
from the IP you have the Apache running?

-- 
 10:48:01 up 22 days,  2:38,  3 users,  load average: 0.15, 0.26, 0.27
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------




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

* Re: Help me
@ 2003-09-14 01:23  Tran Anh Tu <trantu@vnu.edu.vn>
  parent: Martin Marques <martin@bugs.unl.edu.ar>
  0 siblings, 1 reply; 19+ messages in thread

From: Tran Anh Tu @ 2003-09-14 01:23 UTC (permalink / raw)
  To: Martin Marques <martin@bugs.unl.edu.ar>; pgsql-php@postgresql.org

I started postgresql with command:
/etc/init.d/postgresql start
I created user 'trantu' with password 'hanoi' and this user have 
privileges fully to create database and create user.
when I type a command:
psql -U trantu -p hanoi
or
psql -U trantu -p hanoi waterdb
have a same error:
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.0"?

With phpPgAdmin, apache and php are configured perfecly.
Please help me to debug it. Thank you very much.
*******************************************************
Tran Anh Tu
Vien CNTT - DHQG Ha Noi
Phone: 047680417-25   Email trantu@vnu.edu.vn
*******************************************************




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

* Re: [PHP] Help me
@ 2003-09-14 01:27  Kent L. Nasveschuk <kent@wareham.k12.ma.us>
  parent: Tran Anh Tu <trantu@vnu.edu.vn>
  0 siblings, 1 reply; 19+ messages in thread

From: Kent L. Nasveschuk @ 2003-09-14 01:27 UTC (permalink / raw)
  To: Tran Anh Tu <trantu@vnu.edu.vn>; +Cc: pgsql-admin

Are you connecting on the local machine? If so try without the -U and -p

ex.: psql waterdb

You can also use telnet or ssh and connect from a remote machine and do
the same.

Kent N

On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote:
> I started postgresql with command:
> /etc/init.d/postgresql start
> I created user 'trantu' with password 'hanoi' and this user have 
> privileges fully to create database and create user.
> when I type a command:
> psql -U trantu -p hanoi
> or
> psql -U trantu -p hanoi waterdb
> have a same error:
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.0"?
> 
> With phpPgAdmin, apache and php are configured perfecly.
> Please help me to debug it. Thank you very much.
> *******************************************************
> Tran Anh Tu
> Vien CNTT - DHQG Ha Noi
> Phone: 047680417-25   Email trantu@vnu.edu.vn
> *******************************************************
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
-- 
Kent L. Nasveschuk <kent@wareham.k12.ma.us>
.




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

* Re: Help me
@ 2003-09-14 02:19  Tran Anh Tu <trantu@vnu.edu.vn>
  parent: Kent L. Nasveschuk <kent@wareham.k12.ma.us>
  0 siblings, 1 reply; 19+ messages in thread

From: Tran Anh Tu @ 2003-09-14 02:19 UTC (permalink / raw)
  To: Kent L. Nasveschuk <kent@wareham.k12.ma.us>; pgsql-php@postgresql.org

If I type: psql waterdb I must login as postgres user.
So what can I do to login using phpPgAdmin 3.0.1?
*******************************************************
Tran Anh Tu
Vien CNTT - DHQG Ha Noi
Phone: 047680417-25   Email trantu@vnu.edu.vn
*******************************************************


-----Original Message-----
From: "Kent L. Nasveschuk" <kent@wareham.k12.ma.us>
To: Tran Anh Tu <trantu@vnu.edu.vn>
Cc: Postgres-Admin list <pgsql-admin@postgresql.org>
Date: 13 Sep 2003 21:27:39 -0400
Subject: Re: [PHP] Help me

> Are you connecting on the local machine? If so try without the -U and
> -p
> 
> ex.: psql waterdb
> 
> You can also use telnet or ssh and connect from a remote machine and do
> the same.
> 
> Kent N
> 
> On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote:
> > I started postgresql with command:
> > /etc/init.d/postgresql start
> > I created user 'trantu' with password 'hanoi' and this user have 
> > privileges fully to create database and create user.
> > when I type a command:
> > psql -U trantu -p hanoi
> > or
> > psql -U trantu -p hanoi waterdb
> > have a same error:
> > psql: could not connect to server: No such file or directory
> >         Is the server running locally and accepting
> >         connections on Unix domain socket "/tmp/.s.PGSQL.0"?
> > 
> > With phpPgAdmin, apache and php are configured perfecly.
> > Please help me to debug it. Thank you very much.
> > *******************************************************
> > Tran Anh Tu
> > Vien CNTT - DHQG Ha Noi
> > Phone: 047680417-25   Email trantu@vnu.edu.vn
> > *******************************************************
> > 
> > 
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> > 
> >                http://www.postgresql.org/docs/faqs/FAQ.html
> -- 
> Kent L. Nasveschuk <kent@wareham.k12.ma.us>
> .




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

* Re: Help me
@ 2003-09-14 04:57  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  parent: Tran Anh Tu <trantu@vnu.edu.vn>
  0 siblings, 0 replies; 19+ messages in thread

From: Christopher Kings-Lynne @ 2003-09-14 04:57 UTC (permalink / raw)
  To: Tran Anh Tu <trantu@vnu.edu.vn>; +Cc: Kent L. Nasveschuk <kent@wareham.k12.ma.us>; pgsql-php@postgresql.org

Login as the postgres user to phpPgAdmin user, and create a new user for
yourself.

Also, set a password for the postgres user.

Then, edit your pg_hba.conf and set password access to 'md5', not 'trust'.

Chris


On Sun, 14 Sep 2003, Tran Anh Tu wrote:

> If I type: psql waterdb I must login as postgres user.
> So what can I do to login using phpPgAdmin 3.0.1?
> *******************************************************
> Tran Anh Tu
> Vien CNTT - DHQG Ha Noi
> Phone: 047680417-25   Email trantu@vnu.edu.vn
> *******************************************************
>
>
> -----Original Message-----
> From: "Kent L. Nasveschuk" <kent@wareham.k12.ma.us>
> To: Tran Anh Tu <trantu@vnu.edu.vn>
> Cc: Postgres-Admin list <pgsql-admin@postgresql.org>
> Date: 13 Sep 2003 21:27:39 -0400
> Subject: Re: [PHP] Help me
>
> > Are you connecting on the local machine? If so try without the -U and
> > -p
> >
> > ex.: psql waterdb
> >
> > You can also use telnet or ssh and connect from a remote machine and do
> > the same.
> >
> > Kent N
> >
> > On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote:
> > > I started postgresql with command:
> > > /etc/init.d/postgresql start
> > > I created user 'trantu' with password 'hanoi' and this user have
> > > privileges fully to create database and create user.
> > > when I type a command:
> > > psql -U trantu -p hanoi
> > > or
> > > psql -U trantu -p hanoi waterdb
> > > have a same error:
> > > psql: could not connect to server: No such file or directory
> > >         Is the server running locally and accepting
> > >         connections on Unix domain socket "/tmp/.s.PGSQL.0"?
> > >
> > > With phpPgAdmin, apache and php are configured perfecly.
> > > Please help me to debug it. Thank you very much.
> > > *******************************************************
> > > Tran Anh Tu
> > > Vien CNTT - DHQG Ha Noi
> > > Phone: 047680417-25   Email trantu@vnu.edu.vn
> > > *******************************************************
> > >
> > >
> > > ---------------------------(end of
> > broadcast)---------------------------
> > > TIP 5: Have you checked our extensive FAQ?
> > >
> > >                http://www.postgresql.org/docs/faqs/FAQ.html
> > --
> > Kent L. Nasveschuk <kent@wareham.k12.ma.us>
> > .
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>




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

* help me
@ 2003-10-20 08:01  Ashok Chauhan <ashok@kalculate.com>
  0 siblings, 1 reply; 19+ messages in thread

From: Ashok Chauhan @ 2003-10-20 08:01 UTC (permalink / raw)
  To: pgsql-admin

after login into pgsql through a user, when i try to connect some other
database it always says that permission denied. 
what do i do?




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

* Re: help me
@ 2003-10-20 08:10  Mailing List <list@1006.org>
  parent: Ashok Chauhan <ashok@kalculate.com>
  0 siblings, 0 replies; 19+ messages in thread

From: Mailing List @ 2003-10-20 08:10 UTC (permalink / raw)
  To: Ashok Chauhan <ashok@kalculate.com>; +Cc: pgsql-admin


> after login into pgsql through a user, when i try to connect some other
> database it always says that permission denied. 
> what do i do?

Read this about pg_hba.conf:
http://www.postgresql.org/docs/7.3/static/client-authentication.html

And this about DB users:
http://www.postgresql.org/docs/7.3/static/user-manag.html

Bye, Chris.





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

* Help Me !
@ 2005-12-20 09:44  zhuge xiao <zhuge@Rinaix.cn>
  0 siblings, 1 reply; 19+ messages in thread

From: zhuge xiao @ 2005-12-20 09:44 UTC (permalink / raw)
  To: pgsql-admin

Help me!

I have edited the program testlibpq.c which is copied from the 
PostgreSQL document to make it become a CGI program. And I have 
succeeded to compile the programme, testlibpq.c from the command line:
   [zhuge@xiao2 src]$ cc -o testlibpq testlibpq.c -lpq

And it can run from the command line:
   [zhuge@xiao2 src]$ ./testlibpq

Then, I copied the excuteable program to the CGI directory, 
/var/www/cgi-bin. And let it run from the Mozilla Firefox browser whose 
URL was http://localhost/cgi-bin/testlibpq. But I failed. The result was 
that the below message was displayed in the browser:
could not connect to server: Permission denied
Is the server running locally and accepting connections on Unix domain 
socket "/tmp/.s.PGSQL.5432"?

The above message was produced by the below code:
if (PQstatus(conn) != CONNECTION_OK)
        {
        fprintf(stdout, PQerrorMessage(conn));
                exit_nicely(conn);
        }

How can I do? Please help me!

Thank you very much.

zhuge@Rinaix.cn




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

* Re: Help Me !
@ 2005-12-21 20:02  Jim C. Nasby <jnasby@pervasive.com>
  parent: zhuge xiao <zhuge@Rinaix.cn>
  0 siblings, 1 reply; 19+ messages in thread

From: Jim C. Nasby @ 2005-12-21 20:02 UTC (permalink / raw)
  To: zhuge xiao <zhuge@Rinaix.cn>; +Cc: pgsql-admin

On Tue, Dec 20, 2005 at 05:44:44PM +0800, zhuge xiao wrote:
> Is the server running locally and accepting connections on Unix domain 
> socket "/tmp/.s.PGSQL.5432"?

So what are the permissions on /tmp/.s.PGSQL.5432? Can apache write to
it?

Actually, I think apache normally chroot's to ServerRoot (httpd.conf)
when it starts. So you probably need to create a symlink from
/tmp/.s.PGSQL.5432 to "ServerRoot"/tmp.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



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

* Re: Help Me !
@ 2005-12-21 20:11  Scott Marlowe <smarlowe@g2switchworks.com>
  parent: Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 1 reply; 19+ messages in thread

From: Scott Marlowe @ 2005-12-21 20:11 UTC (permalink / raw)
  To: Jim C. Nasby <jnasby@pervasive.com>; +Cc: zhuge xiao <zhuge@Rinaix.cn>; pgsql-admin

On Wed, 2005-12-21 at 14:02, Jim C. Nasby wrote:
> On Tue, Dec 20, 2005 at 05:44:44PM +0800, zhuge xiao wrote:
> > Is the server running locally and accepting connections on Unix domain 
> > socket "/tmp/.s.PGSQL.5432"?
> 
> So what are the permissions on /tmp/.s.PGSQL.5432? Can apache write to
> it?
> 
> Actually, I think apache normally chroot's to ServerRoot (httpd.conf)
> when it starts. So you probably need to create a symlink from
> /tmp/.s.PGSQL.5432 to "ServerRoot"/tmp.

My apache doesn't do this, and it's a pretty straight forward source
compile of whatever the latest version of the 2.x branch was late this
last summer.

However, I could see SELinux getting in the way.



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

* Re: Help Me !
@ 2005-12-21 21:25  Jim C. Nasby <jnasby@pervasive.com>
  parent: Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 0 replies; 19+ messages in thread

From: Jim C. Nasby @ 2005-12-21 21:25 UTC (permalink / raw)
  To: Scott Marlowe <smarlowe@g2switchworks.com>; +Cc: zhuge xiao <zhuge@Rinaix.cn>; pgsql-admin

On Wed, Dec 21, 2005 at 02:11:18PM -0600, Scott Marlowe wrote:
> On Wed, 2005-12-21 at 14:02, Jim C. Nasby wrote:
> > On Tue, Dec 20, 2005 at 05:44:44PM +0800, zhuge xiao wrote:
> > > Is the server running locally and accepting connections on Unix domain 
> > > socket "/tmp/.s.PGSQL.5432"?
> > 
> > So what are the permissions on /tmp/.s.PGSQL.5432? Can apache write to
> > it?
> > 
> > Actually, I think apache normally chroot's to ServerRoot (httpd.conf)
> > when it starts. So you probably need to create a symlink from
> > /tmp/.s.PGSQL.5432 to "ServerRoot"/tmp.
> 
> My apache doesn't do this, and it's a pretty straight forward source
> compile of whatever the latest version of the 2.x branch was late this
> last summer.

A coworker just confirmed that it in fact does not chroot by default.
Which had I thought about it for 1/2 a second makes perfect sense,
otherwise it would often have a heck of a time getting to
/home/*/public_html.

> However, I could see SELinux getting in the way.

Definately.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



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


end of thread, other threads:[~2005-12-21 21:25 UTC | newest]

Thread overview: 19+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-16 17:58 help me Baley OUATTARA <ouattara@ivoiris.ci>
2000-08-17 06:19 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2002-04-16 14:22 Help me! Dieudonne Nanga <nanga@compilion.de>
2002-04-16 20:39 ` Re: Help me! Sonia Sanchez Diaz <sonny@piaget.dgsca.unam.mx>
2002-04-17 05:29 ` Re: Help me! Bhuvan A <bhuvansql@yahoo.com>
2003-02-12 10:41 help me!! XIE, Rong <rong.xie@stud.tu-muenchen.de>
2003-02-13 19:21 ` Re: [ADMIN] help me!! Andres Ledesma <aledes@telefonica.net>
2003-09-13 01:58 Re: Help me Tran Anh Tu <trantu@vnu.edu.vn>
2003-09-13 13:50 ` Re: Help me Martin Marques <martin@bugs.unl.edu.ar>
2003-09-14 01:23   ` Re: Help me Tran Anh Tu <trantu@vnu.edu.vn>
2003-09-14 01:27     ` Re: [PHP] Help me Kent L. Nasveschuk <kent@wareham.k12.ma.us>
2003-09-14 02:19       ` Re: Help me Tran Anh Tu <trantu@vnu.edu.vn>
2003-09-14 04:57         ` Re: Help me Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2003-10-20 08:01 help me Ashok Chauhan <ashok@kalculate.com>
2003-10-20 08:10 ` Mailing List <list@1006.org>
2005-12-20 09:44 Help Me ! zhuge xiao <zhuge@Rinaix.cn>
2005-12-21 20:02 ` Re: Help Me ! Jim C. Nasby <jnasby@pervasive.com>
2005-12-21 20:11   ` Re: Help Me ! Scott Marlowe <smarlowe@g2switchworks.com>
2005-12-21 21:25     ` Re: Help Me ! Jim C. Nasby <jnasby@pervasive.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