Обсуждение: Run a create object script ???
Hi, I have written all the script in a db.txt file, how to call the script from the file??? In Oracle one can issue $ @filename and the job get done, whats the relative option in POSTGRES ??? DArshan
On Thu, 26 Apr 2001 Darshan.wakchaure@Vashimail.ltitl.com wrote: > I have written all the script in a db.txt file, how to call the script from the > file??? > In Oracle one can issue $ @filename and the job get done, whats the relative > option in POSTGRES ??? \i filename use \? for a complete list. -- Tod McQuillin
Hi ! Last day, when I did a vacuum, postgres crashes. Now It works fine, but I can't do VACUMM, the error message is something like "Can't get lock. Is another Vacuum running ?" What can I do to reactivate the vacuum ? thank you. ---------------------------------------------------------------- EuroVox 4, place Félix Eboue 75583 Paris Cedex 12 Tel : 01 44 67 05 05 Fax : 01 44 67 05 19 Web : http://www.eurovox.fr ----------------------------------------------------------------
Jean-Arthur Silve <jeanarthur@eurovox.fr> writes:
> Now It works fine, but I can't do VACUMM, the error message is something
> like "Can't get lock. Is another Vacuum running ?"
> What can I do to reactivate the vacuum ?
There's a file named something pretty obvious (pg_vlock, IIRC) in the
$PGDATA/base/yourdb/ directory. Remove it.
Also, consider updating to a more recent version of Postgres ;-)
regards, tom lane
use \i option followed by the path of the file which contains the script ----- Original Message ----- From: <Darshan.wakchaure@Vashimail.ltitl.com> To: <pgsql-general@postgresql.org> Sent: Thursday, April 26, 2001 1:18 PM Subject: [GENERAL] Run a create object script ??? > > > Hi, > I have written all the script in a db.txt file, how to call the script from the > file??? > In Oracle one can issue $ @filename and the job get done, whats the relative > option in POSTGRES ??? > > DArshan > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)