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@xxxxxxxx > > > -----Original Message----- > From: Raymond O'Donnell [mailto:rod@xxxxxx] > Sent: Friday, May 11, 2012 12:35 PM > To: Vo, Catherine CTR DTIC Z > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxx > -- wikisquare Softwareentwicklung Stefan Tzeggai Straßburger Weg 26 53113 Bonn email tzeggai@xxxxxxxxxxxxx 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
