[DOCS] Suggested changes to Tutorial
Folks: in tutorial-createdb, it says: "... where your own login name is mentioned. This will happen if the administrator has not created a PostgreSQL user account for you. (PostgreSQL user accounts are distinct from operating system user accounts.) If you are the administrator, see Chapter 18 for help creating accounts. You will need to become the operating system user under which PostgreSQL was installed (usually postgres) to create the first user account. It could also be that you were assigned a PostgreSQL user name that is different from your operating system user name; in that case you need to use the -U switch or set the PGUSER environment variable to specify your PostgreSQL user name." This isn't nearly clear enough for a tutorial. It should say: "... where your own login name is mentioned. This will happen if the administrator has not created a PostgreSQL user account for you. (PostgreSQL user accounts are distinct from operating system user accounts.) It could also be that you were assigned a PostgreSQL user name that is different from your operating system user name; in that case you need to use the -U switch or set the PGUSER environment variable to specify your PostgreSQL user name. If this is a new installation and you are the administrator, then you probably need to connect as the system user who owns the PostgreSQL installation, usually "postgres", but sometimes "pgsql". On POSIX systems you can do this via the command "su - postgres"; otherwise simply log into the system as that system user. Once you are logged in as the installation owner, you can use createuser to add other accounts." -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [DOCS] Suggested changes to Tutorial
If this is a new installation and you are the administrator, then you probably need to connect as the system user who owns the PostgreSQL installation, usually "postgres", but sometimes "pgsql". On POSIX systems you can do this via the command "su - postgres"; otherwise simply log into the system as that system user. Once you are logged in as the installation owner, you can use createuser to add other accounts." Josh... then why didn't you just submit a patch? Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [DOCS] Maintenance and External Projects (try 2)
Patch applied. Thanks.
---
Robert Treat wrote:
> On Friday 14 July 2006 15:23, Joshua D. Drake wrote:
> > Tom Lane wrote:
> > > "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > >> Please let me know if there is anything else you would like me to do or
> > >> add.
> > >
> > > A round of copy-editing seems indicated, at least.
> >
> > Oh, no doubt. I tried to fix as much as I find, including a bunch of
> > stuff already there. However, I do not claim, in any way to be an editor.
> >
>
> The following patches provide some editorializing for Joshua's patches.
>
> --
> Robert Treat
> Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
[ Attachment, skipping... ]
[ Attachment, skipping... ]
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
--
Bruce Momjian [EMAIL PROTECTED]
EnterpriseDBhttp://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Re: [DOCS] Suggested changes to Tutorial
JD, > Josh... then why didn't you just submit a patch? See earlier conversation about the lack of good tools for Docbook/SGML. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [DOCS] Suggested changes to Tutorial
Josh Berkus wrote: JD, Josh... then why didn't you just submit a patch? See earlier conversation about the lack of good tools for Docbook/SGML. I guess this comes back to.. why (really) haven't we switched to what is widely considered the documentation standard, which is Docbook XML. Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
