Re: backup script

Hi

Am 11.05.2012 21:38, schrieb Vo, Catherine CTR DTIC Z:
> We are using Sun Solaris 64bits version 10.
> postgresql-9.1.3-S10.sparc-6
>
> Don't know how to create a backup user (I know the
> syntax but where should I create it?)
I don't know Solaris, but with the installation of Postgres on Linux
there usually comes a user "postgres". That user is by default a
superuser on the primary database called "postgres" and can connect to
it without a password.

So you could use that default superuser - or better create a new user
for backups:
http://www.postgresql.org/docs/9.1/static/sql-createuser.html
http://www.postgresql.org/docs/9.1/static/app-createuser.html

> Normall, we goes to sqlplus / as
> sysdba on oracle and mysql -u root -p on mysql, but where should I
> create it on postgres?
>
> Also, when I start the postgres, I saw 5 processes running... this is
> odd isn't it? Beside that, don't see port running on /tmp directory.
>
> Thanks,
>
>
> Bach-Nga Catherine Vo
> 703-767-7009
> mailto: bvo(dot)ctr(at)dtic(dot)mil
>
>
> -----Original Message-----
> From: Raymond O'Donnell [mailto:rod(at)iol(dot)ie]
> Sent: Friday, May 11, 2012 12:35 PM
> To: Vo, Catherine CTR DTIC Z
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] backup script
>
> On 11/05/2012 16:23, Vo, Catherine CTR DTIC Z wrote:
>> GM,
>>
>> First where can I post my question on the forum? Couldn't find the
>> forum for discussion.
> Hi there,
>
> Not sure what forum you mean.... you're writing to the pgsql-general
> mailing list, so you're already in the right place.
>
>> Second, I'm new with postgres. Try to evaluate this new db software
>> before the company can switch all oracle and mysql to postgres. I
>> don't understand the concept how to create backup user, tablespace,
> etc....
>
> Welcome!
>
> Some of this happens in the database, some in the operating system. If
> you give details of your platform - hardware and software - people will
> be able to help you.
>
> Ray.
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod(at)iol(dot)ie
>

--
wikisquare Softwareentwicklung
Stefan Tzeggai
Straßburger Weg 26
53113 Bonn

email tzeggai(at)wikisquare(dot)de
webpage wikisquare.de
skype alfonx
phone 0228 24 000 528
mobile 0176 40 38 9559

reclaim your net - http://tor.eff.org
enforce privacy - http://www.pgpi.org
pgp key id: 51B576FD - http://pgp.mit.edu

Please note that according to the German law on data retention,
information on every electronic information exchange with me is
retained for a period of six months.