> Here are the results from reversing the arguments.
>
> >hesco@biko:~$ su postgres
> >Password:
> >postgres@biko:/home/hesco$ cd
> >postgres@biko:~$ cd /usr/bin
> >postgres@biko:/usr/bin$ psql tempate1 -U postgres
> >Could not execv /usr/lib/postgresql/bin/psql
> >postgres@biko:/usr/bin$ psql tem
Thank you Tom Lane and Oliver Elphick.
Here is the latest shell dialogue.
postgres@biko:/home/hesco$ ./usr/lib/postgresql/bin/psql -d template1
sh: ./usr/lib/postgresql/bin/psql: No such file or directory
postgres@biko:/home/hesco$ /usr/lib/postgresql/bin/psql -d template1
sh: /usr/lib/postgresq
On Wed, 2002-11-20 at 15:03, Tom Lane wrote:
> Oliver Elphick <[EMAIL PROTECTED]> writes:
> > execv() is a system call to run another executable in place of the
> > current process. If the other executable is not present, or does not
> > have permissions, you will not be able to run it. Find out
Oliver Elphick <[EMAIL PROTECTED]> writes:
> execv() is a system call to run another executable in place of the
> current process. If the other executable is not present, or does not
> have permissions, you will not be able to run it. Find out why.
Aside from access problems for the executable i
On Wed, 2002-11-20 at 14:23, Hugh Esco wrote:
> Everything in the path is executable for others.
> That is true for:
> /usr/lib/postgresql/bin
> and for:
> /usr/bin
> where psql is located.
So can you run the executable directly?
/usr/lib/postgresql/bin/psql -d template1
-
On Wed, 2002-11-20 at 13:52, Hugh Esco wrote:
> However, when I again attempt to invoke the psql client, I get this:
> >biko:/usr/bin$ ./psql -U postgres template1
> >Could not execv /usr/lib/postgresql/bin/psql
Pay attention to the exact message and do not flounder around
aimlessly. There is no
Everything in the path is executable for others.
That is true for:
/usr/lib/postgresql/bin
and for:
/usr/bin
where psql is located.
-- Hugh
At 12:49 PM 11/20/02 +, Oliver Elphick wrote:
There is something wrong with permissions here.
You ought to be able, as _any_ user, to r
Mr. Lane:
pg_wrapper permits Others to Execute it.
biko:/usr/bin$ ls -al | grep pg_wrapper
lrwxrwxrwx1 root root 10 Oct 10 16:24 createdb -> pg_wrapper
lrwxrwxrwx1 root root 10 Oct 10 16:24 createuser ->
pg_wrapper
lrwxrwxrwx1 root root 10 O
My continued appreciation to Tom Lane,
Michael Lange, Luis Sousa and Cameron Spitzer:
Apologies for the length of this, but I've tried everything suggested and
most f this is the shell dialogues of when I did so.
At 08:40 AM 11/20/02 +0100, Michiel wrote:
That is indeed true. Also I see you do e
On Wed, 2002-11-20 at 06:30, Hugh Esco wrote:
> I did this tonight
>
> dpkg --purge postgresql
> apt-get install postgresql
>
> and am now still getting the following:
>
> >biko:/usr/bin# psql -U postgres
> >No database specified
> >biko:/usr/bin# psql -U postgres template1
> >Could not execv /u
biko:/usr/bin# psql -U postgres
No database specified
Instead, do: su - postgres
Then do: psql template1 or psql -h template1
My pg_hba.conf temporarily reads:
local all trust
host all 127.0.0.1 255.255.255.255 trust
host template1 192.168.2.21 255.255.255.0 trust
For now, just remove
> Here are the results from reversing the arguments.
>
> >hesco@biko:~$ su postgres
> >Password:
> >postgres@biko:/home/hesco$ cd
> >postgres@biko:~$ cd /usr/bin
> >postgres@biko:/usr/bin$ psql tempate1 -U postgres
> >Could not execv /usr/lib/postgresql/bin/psql
> >postgres@biko:/usr/bin$ p
That is indeed true. Also I see you do everything as root, try creating a
new user especially for postgres databases. create a directory with root in
/usr/loca/pgsql/ named data, or any other directory that is in $PGDATA.
chown the directory to the postgres user, log in as the postgres user and
Hugh Esco <[EMAIL PROTECTED]> writes:
>> biko:/usr/bin# ls -al | grep psql
>> lrwxrwxrwx1 root root 10 Oct 10 16:24 psql -> pg_wrapper
> This seems to say that Other users, like postgres, should be able to
> execute it. I'm confused, here.
The permissions attached to a symboli
Here are the results from reversing the arguments.
hesco@biko:~$ su postgres
Password:
postgres@biko:/home/hesco$ cd
postgres@biko:~$ cd /usr/bin
postgres@biko:/usr/bin$ psql tempate1 -U postgres
Could not execv /usr/lib/postgresql/bin/psql
postgres@biko:/usr/bin$ psql template1 -U postgres
Could
Does "Could not execv" mean that I do not have rights to execute this script?
biko:/usr/bin# ls -al | grep psql
lrwxrwxrwx1 root root 10 Oct 10 16:24 psql -> pg_wrapper
biko:/usr/bin#
This seems to say that Other users, like postgres, should be able to
execute it. I'm confuse
>> biko:/usr/bin# psql -U postgres template1
Maybe try : biko:/usr/bin# psql tempate1 -U postgres
I use PG on Debian too. I much prefer to compile from source. It's very
easy why don't you give it a try.
I've never had a problem compiling from source, just make sure to follow
the instruction's
I did this tonight
dpkg --purge postgresql
apt-get install postgresql
and am now still getting the following:
biko:/usr/bin# psql -U postgres
No database specified
biko:/usr/bin# psql -U postgres template1
Could not execv /usr/lib/postgresql/bin/psql
biko:/usr/bin# psql -U postgres template0
Co
Did you install your package using apt-get ?
All the instalations that I do are using those tools from debian. You
have to see all the packages that you have instaled in your computer like:
dpkg -l | grep postgresql
ii postgresql 7.2.1-2Object-relational SQL database,
descended fr
i
I have reinstalled before. I wonder though, how I ensure that I have
cleanly un-installed it first, so that I leave no residue from the
previously botched installation around to mess things up the next time.
-- Hugh Esco
At 09:03 AM 11/19/02 +, Luis Sousa wrote:
Tom Lane wrote:
Start over:
Tom Lane wrote:
Hugh Esco <[EMAIL PROTECTED]> writes:
Any ideas on what my next steps should be would be greatly appreciated.
Start over: delete your PG installation and reinstall the Debian
package. It seems very clear that you've got an incomplete package.
regards, tom lane
I a
Uz.ytkownik Hugh Esco napisa?:
Thank you so much, Mallah, Tomasz Myrta, Luis Sousa,
Achilleus Mantzios, Tom Lane, Bill Eaton and Oliver Elphick.
I have chmod 755 my readpgenv file, and then copied the
shell script suggested by Tomasz Myrta into that file,
yielding these results:
biko:/usr/li
Hugh Esco <[EMAIL PROTECTED]> writes:
> Any ideas on what my next steps should be would be greatly appreciated.
Start over: delete your PG installation and reinstall the Debian
package. It seems very clear that you've got an incomplete package.
regards, tom lane
Thank you so much, Mallah, Tomasz Myrta, Luis Sousa,
Achilleus Mantzios, Tom Lane, Bill Eaton and Oliver Elphick.
I have chmod 755 my readpgenv file, and then copied the
shell script suggested by Tomasz Myrta into that file,
yielding these results:
biko:/usr/lib/postgresql/bin# cd /usr/bin
biko:
On Sun, 2002-11-17 at 20:24, [EMAIL PROTECTED] wrote:
> > You seem to have a very bizarre setup there --- there is no such thing
> > as "readpgenv" in the standard Postgres distribution, and
> > /usr/lib/postgresql/bin/ isn't the standard place to put the executable
> > files either. Perhaps the a
Hi there,
I'm using debian woody. If you post your configuration files that are in
/etc/postgresql/ maybe i can help you.
Regards,
Luis Sousa
Hugh Esco wrote:
Hey folks:
I am able to consistently start and stop the postgreSQL server and to
access it across our office network with pgAdmin II.
> You seem to have a very bizarre setup there --- there is no such thing
> as "readpgenv" in the standard Postgres distribution, and
> /usr/lib/postgresql/bin/ isn't the standard place to put the executable
> files either. Perhaps the above is normal for the Debian package of
> Postgres, but I'm a
Hugh Esco <[EMAIL PROTECTED]> writes:
>> postgres@biko:/home/hesco$ psql
>> env: /usr/lib/postgresql/bin/readpgenv: Permission denied
>> No database specified
>> postgres@biko:/home/hesco$ psql ggp_test
>> env: /usr/lib/postgresql/bin/readpgenv: Permission denied
>> Could not execv /usr/lib/postgre
On Sat, Nov 16, 2002 at 02:11:58PM -0500, Hugh Esco wrote:
> Hey folks:
>
> I've copied the shell dialogue below.
> Everything in: /usr/lib/postgresql/bin is owned by root:root.
It's default instalation in Debian Woody and it works fine
> >postgres@biko:/home/hesco$ psql
> >env: /usr/lib/postgres
One more note: when I first got the error:
env: /usr/lib/postgresql/bin/readpgenv: Permission denied
I looked and determined that no such file existed, so I created an empty
(one character) file by that name with a shell level echo command and set
the permissions to match those of every other
Hey folks:
I am able to consistently start and stop the postgreSQL server and to
access it across our office network with pgAdmin II. I have had no luck
invoking the psql command line prompt, from where I can enter queries and
start to surmount the learning curve from background with mySQL to
31 matches
Mail list logo
