RE: [GENERAL] PostgreSQL, Inc Site Redone ...
Shawn, You must be logged in as the "root" or "postgres" user. Otherwise the "ps aux" can't work proper way. The fact, that the files postmaster are in the directory/folder doesn't mean that it is properly instaled. shaman dan peder -Original Message- From: Shawn Pursley [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 24, 1999 6:38 PM To: Simon Drabble Cc: [EMAIL PROTECTED] Subject:Re: [GENERAL] PostgreSQL, Inc Site Redone ... More info, hopefully helpful... [powner@pusher template1]$ ps aux | grep postmaster [powner@pusher template1]$ cd /usr/bin [powner@pusher bin]$ ls -la pos* -r-xr-xr-x 1 root root 1074180 May 22 22:28 postgres* lrwxrwxrwx 1 root root8 Jul 26 12:16 postmaster -> postgres* -rwxr-xr-x 1 root root 5760 May 11 12:01 postprint* Shawn - Original Message - From: Simon Drabble <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 1999 9:24 AM Subject: Re: [GENERAL] PostgreSQL, Inc Site Redone ... > On Tue, 24 Aug 1999, The Hermit Hacker wrote: > > > > > Morning ... > > > > After spending the past while looking at the pitiful creation I > > created, we've finally taken the time to redo the site so that, in our > > opinion, it looks professional... > > > > "Take a look at us now" - http://www.pgsql.com > > > > Feel free to send comments/suggestions to [EMAIL PROTECTED] > > > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy > > > Just a couple of quick niggles: > > Compliance - Are you converting from a different system ? > PostgreSQL is on /you/ side. If /you/ old applications were SQL92 > compliant, then chances are the migration will be simple and quick. > > > both highlighted `you's should be `your' > > > Simon. > > -- > "This message will expire soon. Please contact your vendor for an update." > >Simon Drabble It's like karma for your brain. >[EMAIL PROTECTED] > > > > >
Re: [GENERAL] Boneheaded Setup?
Simon -- Thanks for all the help so far...please don't kill me... For anyone else doing this exercise...I had to use the -R instead of -r on Mandrake. [root@pusher bin]# chown -R postgres /usr/local/pgsql/ [postgres@pusher pgsql]$ nohup postmaster > regress.log 2>&1 & [1] 1443 [postgres@pusher pgsql]$ createuser Connection to database 'template1' failed. FATAL 1: SetUserId: user 'postgres' is not in 'pg_shadow' createuser: database access failed. [postgres@pusher pgsql]$ cd /usr/local/pgsql/data [postgres@pusher data]$ ls -la total 62 -rw--- 1 postgres postgres 8195 Aug 24 12:09 #pg_shadow# drwxrwsr-x 3 postgres postgres 1024 Aug 24 12:09 ./ drwxrwsr-x 8 postgres postgres 1024 Aug 18 09:10 ../ -rw--- 1 postgres postgres4 Aug 12 16:12 PG_VERSION drwx--S--- 4 postgres postgres 1024 Aug 17 11:27 base/ -rw--- 1 postgres postgres 8192 Aug 17 11:27 pg_database -r 1 postgres postgres 3407 Aug 12 16:12 pg_geqo.sample -rw--- 1 postgres postgres0 Aug 12 16:12 pg_group -rw--w 1 postgres postgres 5191 Aug 12 17:05 pg_hba.conf -rw--w 1 postgres postgres 5192 Aug 12 16:12 pg_hba.conf~ -rw--- 1 postgres postgres 8192 Aug 18 11:00 pg_log -rw-rw-rw- 1 postgres postgres 51 Aug 12 16:12 pg_pwd -rw--- 1 postgres postgres 8192 Aug 12 16:12 pg_shadow -rw--- 1 postgres postgres 8192 Aug 18 11:00 pg_variable Do you spot anything else wrong? I tried to emacs pg_shadow, but that is one ugly files that looks compiled. I did see that powner resides in there. Shawn
Re: [GENERAL] Boneheaded Setup?
On Tue, 24 Aug 1999, Shawn Pursley wrote: > Simon -- > > Thanks for all the help so far...please don't kill me... > > For anyone else doing this exercise...I had to use the -R instead of -r on > Mandrake. Yeah, my bad - it is indeed -R > > [root@pusher bin]# chown -R postgres /usr/local/pgsql/ > [postgres@pusher pgsql]$ nohup postmaster > regress.log 2>&1 & > [1] 1443 > [postgres@pusher pgsql]$ createuser > Connection to database 'template1' failed. > FATAL 1: SetUserId: user 'postgres' is not in 'pg_shadow' > > createuser: database access failed. > [postgres@pusher pgsql]$ cd /usr/local/pgsql/data > [postgres@pusher data]$ ls -la > total 62 > > Do you spot anything else wrong? I tried to emacs pg_shadow, but that is > one ugly files that looks compiled. I did see that powner resides in there. Oops. Looks like you installed as powner, which will cause powner to be the postgres super user. My advice to you if you haven't created any databases yet is to blow away the postgres directory completely and re-run the installation, this time as postgres. Once you have done this, you can add powner as a postgres user and assign rights as necessary. the postgres super-user should really be only used to start/ stop the back-end, and create new users (i.e. admin tasks). Use powner to create databases and work with them. Simon. -- "This message will expire soon. Please contact your vendor for an update." Simon Drabble It's like karma for your brain. [EMAIL PROTECTED]
[GENERAL] Web master Please remove me as ralli@poboxes.com
The Hermit Hacker wrote:
>
> Morning ...
>
> After spending the past while looking at the pitiful creation I
> created, we've finally taken the time to redo the site so that, in our
> opinion, it looks professional...
>
> "Take a look at us now" - http://www.pgsql.com
>
> Feel free to send comments/suggestions to [EMAIL PROTECTED]
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
>
>
begin:vcard
n:Ralli;Rakesh
tel;work:011-6425765, 642 6391
x-mozilla-html:FALSE
url:http://www.iPropertyExchange.com
org:Ralli Estate Pvt Ltd ;http://welcome.to/ralli
adr:;;E-11- East of Kailash ;New Delhi ;ND ;110065;India
version:2.1
email;internet:[EMAIL PROTECTED] http://welcome.to/ralli
title:Director
note:-1
x-mozilla-cpt:;-25328
fn:Rakesh Ralli
end:vcard
Re: [GENERAL] PostgreSQL, Inc Site Redone ...
Hmm...tried to submit a suggestion via the contact page, but it reports back Not Found The requested URL /contact.cgi was not found on this server. Cheers, Thomas > Subject: Re: [GENERAL] PostgreSQL, Inc Site Redone ... > > > On Tue, 24 Aug 1999, The Hermit Hacker wrote: > > > > > > > > Morning ... > > > > > > After spending the past while looking at the pitiful creation I > > > created, we've finally taken the time to redo the site so that, in our > > > opinion, it looks professional... > > > > > > "Take a look at us now" - http://www.pgsql.com > > > > > > Feel free to send comments/suggestions to [EMAIL PROTECTED] > > > > > > Marc G. Fournier ICQ#7615664 IRC Nick: > Scrappy > > > > > > Just a couple of quick niggles: > > > > Compliance - Are you converting from a different system ? > > PostgreSQL is on /you/ side. If /you/ old applications were SQL92 > > compliant, then chances are the migration will be simple and quick. > > > > > > both highlighted `you's should be `your' > > > > > > Simon. > > > > -- > > "This message will expire soon. Please contact your vendor for an > update." > > > >Simon Drabble It's like karma for your brain. > >[EMAIL PROTECTED] > > > > > > > > > > > > > > -- Thomas ReinkeTel: (416) 460-7021 Director of Technology Fax: (416) 598-2319 E-Soft Inc. http://www.e-softinc.com
[GENERAL] installation and pq_recvbuf: unexpected EOF
I have tried to install the PostgreSQL 6.5.1, but I think the installation wasn't done correctly. Firstly, in INSTALLATION step 14 it says that the last line in file make.install.log is gmake[1]: Leaving directory `/usr/src/pgsql/src/man' However in my make.install.log it is gmake[1]: Leaving directory `/home/dgchtch/pgsql/src/pl' and directory /usr/src/pgsql/src/man is never mentioned in make.install.log. Secondly, step 9 of the installation says: $ su $ cd /usr/src $ mkdir pgsql $ chown postgres:postgres pgsql Is this important ? I don't have superuser priveleges so I can't do 'su' command. The installation problem manifests itself like this: When I run first createdb I get: >Segmentation Fault - core dumped >createdb: database creation failed on dgchtch. The postmaster gives following debug info: /home/dgchtch/pgsql/bin/postmaster: BackendStartup: pid 28832 user dgchtch db template1 socket 4 FindExec: found "/home/dgchtch/pgsql/bin/postgres" using argv[0] started: host=localhost user=dgchtch database=template1 InitPostgres pq_recvbuf: unexpected EOF on client connection proc_exit(0) [#0] shmem_exit(0) [#0] exit(0) /home/dgchtch/pgsql/bin/postmaster: reaping dead processes... /home/dgchtch/pgsql/bin/postmaster: CleanupProc: pid 28832 exited with status 0 Same happens if I do: psql template1 If I do: psql -c "create database dgchtch template1" Connection to database 'dgchtch' failed. FATAL 1: Database dgchtch does not exist in pg_database Any clues?? Thanks!
RE: [GENERAL] newbe question
If postmaster is really running, su the user who running postmaster (should not be root). and run the following two commands. $ initdb $ createuser anyuser According to your Linux distribution, initdb may have been performed. (my RedHat 6.0 scripts for postgres in rc.d/ directory runs initdb.) In this case you don't have to run initdb. On Tue, 24 Aug 1999, Daniel Pider wrote: > login as the root and at the linux prompt # type following > ===example=== > ps aux | grep postmaster > = > > then You should get few lines containig one looking like that, notice the text >"postmaster" at the end of line: > =example=== > postgres 345 0.0 2.9 3376 904 ? S12:31 0:00 /usr/bin/postmaster - > === > if not, then the backend server is not running - so it is not installed > > -Original Message- > From: Phil Oelkers [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, August 24, 1999 6:00 PM > To: [EMAIL PROTECTED] > Subject: [GENERAL] newbe question > > Ok I'm and old pro at SQL (DB2, Access) but a total Linux/Unix idiot. > > I have Mandrake RedHat Linux and think I have postgresql installed. > > At the shell I type > > psql template1 > > Linux complains > > connectDB() failed: Is postmaster running and accepting conections at > 'UNIX SOCKET' on port 5432 > > > Being a near complete Linux idiot I have no clue what this means. > > Anybody care to help? > > Thanks > > Phil Oelkers > Database Analyst - Team O > Experian DirectTech > > > > > > > > === Science is the game we play with God to find out what his rules are. --- Doo Suk Yang Research Scientist Voice: 82-42-866- LG Chemical Ltd. Research Park Biotech Research Institute IFAX: 82-42-861-2566 --- A fool hath no delight in understanding, but that his heart may discover itself. (Proverbs 18:2) ===
[GENERAL] Memory leak
Hi all
I have just isolated a big problem in one of my applications and it turns out
to be a memory leak in postgresql on a VERY basic piece of functionality
It just caused a backend to grow to 133 MB in 4 hours running, which is
obviously not good
Simple piece of C code to demonstrate this:
for (loopa=0;loopa < 10;loopa++)
{
result=PQexec(dbase,"create table test_table ( "
"value int,wordnum int,refnum int,word text)");
PQclear(result);
result=PQexec(dbase,"drop table test_table");
PQclear(result);
}
And watch the memory rie
On an aside, any idea how long till there is a fix for the vacuum analyze
crash, as it is cripling me having that happen.
Final question... Is there a really really good reason that when a backend
crashes, all the other backends die and close connection rather than simply
re-initialising their connections. If it just reinitialised transparently that
would make it a LOT easier than having to have an extra test to see if the
backend has mysteriously crashed after EVERY query!
Thanx
M Simms
--
#define z(x,y) for (x=0;x>((3-y)<<3))&(255));
}}}
