Re: backup script - Mailing list pgsql-general

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.ctr@dtic.mil
>
>
> -----Original Message-----
> From: Raymond O'Donnell [mailto:rod@iol.ie]
> Sent: Friday, May 11, 2012 12:35 PM
> To: Vo, Catherine CTR DTIC Z
> Cc: pgsql-general@postgresql.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@iol.ie
>


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

email    tzeggai@wikisquare.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.