Обсуждение: postgres bash prompt error while user creation

hello group
  i want to create a shell script  in that i want to create postgresql
user and database.both this task are created properly and executed
properly but after user and DB creation i am there on ( -bash-3.00$  )
and i wanna come back to [root@localhost:localdomain ~]#  and my
script is
#!/bin/bash
su -l postgres;
psql -U postgres -c "CREATE USER admin27 WITH PASSWORD 'admin27'
CREATEDB;" template1
psql -U admin27 -c "CREATE DATABASE emcc27;" template1 \q exit;
plzz help me to back to root from postgres bash prompt

>   i want to create a shell script  in that i want to create postgresql
> user and database.both this task are created properly and executed
> properly but after user and DB creation i am there on ( -bash-3.00$  )
> and i wanna come back to [root@localhost:localdomain ~]#  and my
> script is
> #!/bin/bash
> su -l postgres;
> psql -U postgres -c "CREATE USER admin27 WITH PASSWORD 'admin27'
> CREATEDB;" template1
> psql -U admin27 -c "CREATE DATABASE emcc27;" template1 \q exit;
> plzz help me to back to root from postgres bash prompt

You should probably start by reading about the basics of
shell programming. Apart from the obvious documentation
the man pages for "su" may help you to create something that
looks like a shell script.

You might consider the use of "here documents" as described
in the "bash" man page.

Yours,
Laurenz Albe

On 10/25/07, Pingale.amol@gmail.com <Pingale.amol@gmail.com> wrote:
> hello group
>   i want to create a shell script  in that i want to create postgresql
> user and database.both this task are created properly and executed
> properly but after user and DB creation i am there on ( -bash-3.00$  )
> and i wanna come back to [root@localhost:localdomain ~]#  and my
> script is
> #!/bin/bash
> su -l postgres;
> psql -U postgres -c "CREATE USER admin27 WITH PASSWORD 'admin27'
> CREATEDB;" template1
> psql -U admin27 -c "CREATE DATABASE emcc27;" template1 \q exit;
> plzz help me to back to root from postgres bash prompt

first off, stop doing things as root that you don't need to be root to
do.  It's dangerous and a bad habit to get into.

Next, how are you calling your bash script?  Normally if it's set to
executable and you just call it by name i.e. ./myscript it should exit
the bash terminal when done.