[ADMIN] issue pgsql_tmp keeps increasing

Hi, I use psql (PostgreSQL) 8.1.10 on my box, there is a postmater process running automatically to make temp files in pgsql_tmp folder, I don't do any query on my database. Anybody knows what's wrong with it? and how to find what the postmater process is for Thanks Dong He -- Sent via pgsq

[ADMIN] postgres query is very slow

Hi, I built a database on postgres8.1, then I did VACUUM FULL ANALYZE, but the query is still slow. Has anybody an idea ? Thanks Dong -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] access to non public schema

Thank you! one more question, how can I know if one database has several schema? > wrote: > >> when I use #\d, it only list tables of public schema, how can I >> see/access non-public schema in a database? > > Include the schema on your search_path or specify it on your \d > command. For example

[ADMIN] access to non public schema

Hello, when I use #\d, it only list tables of public schema, how can I see/access non-public schema in a database? Thanks Dong -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] can not create user name in Capital letter

Hi, I have a trouble in creating user and database in postgres. whenever I create user or databases in capital letters, the names are always converted into names in lower case letter. what's wrong with it? Thanks Dong -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make ch

Re: [ADMIN] Restiring pg_dump text file

> I've backed up my DB via 'pg_dump dbname' using no options. In order to > restore it via psql, do I first need to drop the db instance and recreate > it? > > Thanks in advance for your help. > > -Mike > > > yes, you have to drop the original db, then use psql -f to restore it. -- Sent via pgsq

Re: [ADMIN] PHP cann't access to postgres databse

Yes, the issue is from SELinux. thank everybody for help > don...@caltech.edu writes: You do have a point on the "Permission denied", though. If the problem was where I was suggesting, it would probably say "Connection refused". Perhaps some OS security restriction is in play here

Re: [ADMIN] PHP cann't access to postgres databse

I can run this php script from commandline and psql remote access works > What does your connect string for each look like (with passwords bleeped > out)? > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mai

Re: [ADMIN] PHP cann't access to postgres databse

i use fedora 11 > >> If it was trying to get that sort of connection, rather than TCP/IP, >> the message would be different. Something like: >> >> # could not connect to server: No such file or directory >> # Is the server running locally and accepting >> # connections on Unix domain socket "

Re: [ADMIN] PHP cann't access to postgres databse

the default port 5432 is associated with postgres and localhost is connected # netstat -plunta | grep 5432 tcp0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 3962/postgres tcp0 0 ::1:5432:::* LISTEN 3

Re: [ADMIN] PHP cann't access to postgres databse

the error message in Apache error-log is " PHP Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server: Permission denied\n\tIs the server running on host "localhost" and accepting\n\tTCP/IP connections on port 5432? " > > It will be good

Re: [ADMIN] PHP cann't access to postgres databse

Yes, I did configured these two files, so, PHP can talk with postgres, but Apache-owned PHP can not. > On Thu, Jun 25, 2009 at 6:54 PM, wrote: >> Hi gurus! >> >> my PHP scripts don't call upon the postgres database from within HTML >> files served to web browsers by Apache, but PHP scritps itself

[ADMIN] PHP cann't access to postgres databse

Hi gurus! my PHP scripts don't call upon the postgres database from within HTML files served to web browsers by Apache, but PHP scritps itself can access to database. I guess some configuration between PHP and Apache is wrong. Do anybody have any idea? Thanks! Dong He -- Sent via pgsql-admi