We have a Oracle 9i installed consisting of a number of tablespaces. The platform is SUn solaris.Accidentally one of the datafile in a particula tablespace has been removed. There is an export backup of the user who is a default user of the tablespace. the database has been shut down and is not...
Hi all,
At long last I have been able to create a database.Thanks but one issue still remains. I am able to connect to the database through a linux user(not postgres)from the command line.
However when I am trying to connect to the same database through pgaccess the application is giving an...
Hi all,
I am a newcomer to postgreSQl. I have mandrake 9 installed in my machine and postgreSQL up and running as seen through ps -ef|grep postmaster.I am running su - postgres and running the command "psql" wherby it is showing "not in system catalogue". Do i have to enter...
I have created a new database in my system through the initdb command. When I issue pg_ctl start the postmaster is starting properly. However when I am issuing the command
psql dbname
the system is saying
"the database name does not exist in the system catalogue."
Even when I am the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.