[ADMIN] reloading config files pg_ctl reload

[Rajesh Kumar Mallah]

Hi,

Will it be a good feature to have pg_ctl check the syntaxes of
the config files before sending a SIGHUP to postmaster ?

Suppose a DBA does somes typos in the files, he shall be confused
not to see the changes in server even after pg_ctl reload .

Regds
mallah.

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [ADMIN] Should duplicate indexes on same column and same table be allowed?

[Tom Lane]

"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> Suppose an index get corrupted. And you need create a new index
> with exact specs and then drop the old index. Is it better to
> have a performing corrupted index or not have it at all and temporarily
> suffer some performance degradation ?

The case that was being discussed just a day or two ago was where you
wanted to do the equivalent of REINDEX because of index bloat, not any
functional "corruption".  In that case it's perfectly clear that
temporarily not having the index isn't acceptable ... especially if
it's enforcing a unique constraint.

regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [ADMIN] Should duplicate indexes on same column and same table be allowed?

[Rajesh Kumar Mallah]

On 12/9/06, Tom Lane <[EMAIL PROTECTED]> wrote:

"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> Suppose an index get corrupted. And you need create a new index
> with exact specs and then drop the old index. Is it better to
> have a performing corrupted index or not have it at all and temporarily
> suffer some performance degradation ?

The case that was being discussed just a day or two ago was where you
wanted to do the equivalent of REINDEX because of index bloat, not any
functional "corruption".  In that case it's perfectly clear that
temporarily not having the index isn't acceptable ... especially if
it's enforcing a unique constraint.


Sorry ,
i guess i digressed .
Lemme put the question once again.

psql> CREATE INDEX x on test (col1);
psql> CREATE INDEX y on test (col1);

What is (are) the downsides of disallowing the
second index. which is *exactly* same as
previous?

Regds
mallah.



regards, tom lane



---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [ADMIN] Should duplicate indexes on same column and same table

[Daniel Cristian Cruz]

Em Dom, 2006-12-10 às 00:47 +0530, Rajesh Kumar Mallah escreveu:
> psql> CREATE INDEX x on test (col1);
> psql> CREATE INDEX y on test (col1);
> 
> What is (are) the downsides of disallowing the
> second index. which is *exactly* same as
> previous?

What if PostgreSQL make a NOTICE about this? The user could see it and
take some action about it.

Sincerely,
-- 
Daniel Cristian Cruz
クルズ クリスチアン ダニエル


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [ADMIN] Advice on loading celko sql script

[Richard Broersma Jr]

--- Philippe Salama <[EMAIL PROTECTED]> wrote:
> I am new to these things.  I have the command line prompt now, to postgresql 
> on windows.  I also
> have a free admin program.   Do I simply RUN THE sql script to create the 
> celko test tables. 

The script that I made is from the postgresql pg_dump program.  It created a 
dump of a database
that I was using for my celko book.  If you run the script it will restore the 
database I created
into your postgresql cluster.

The following link gives some examples how you can restore this dumpfile into 
your database
cluster.
http://www.postgresql.org/docs/8.1/interactive/app-pgdump.html#PG-DUMP-EXAMPLES

If you are not sure how to use pg_dump you can read the rest of the document or 
you can run
"pg_dump.exe --help" from your command line.

Also, other people on the postgresql mailing list can benifit from our 
discussion.  In addition to
this, there are others on the list that might have better answers than the ones 
that I give.  So
it is important that you always send your emails to the mailing list.  The 
easiest way to do this
is to reply-all when you respond to emails from the list.

Regards,

Richard Broersma Jr.

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [ADMIN] Advice on loading celko sql script

[Philippe Salama]

I was a little confused about how to reply, but now I see the yahoo option 
REPLY TO EVERYONE, so I shall try it right now, and see if it works, and comes 
back from the majordomo listserve.

I have an older version of Postgresql 8.1 I think or 8.0.  So your script did 
not work perfectly.  I guess there are some new commands.

I tried to make your script work on MySQL,... but, at work I have the latest 
install of PostgreSQL done last week, so, I am sure your script will work 
there.  And once installed there, I can get the tables into Microsoft Access, 
and do my exercises there if I wish, and share the exercise tables at 
utteraccess.com

Richard Broersma Jr <[EMAIL PROTECTED]> wrote: --- Philippe Salama  wrote:
> I am new to these things.  I have the command line prompt now, to postgresql 
> on windows.  I also
> have a free admin program.   Do I simply RUN THE sql script to create the 
> celko test tables. 

The script that I made is from the postgresql pg_dump program.  It created a 
dump of a database
that I was using for my celko book.  If you run the script it will restore the 
database I created
into your postgresql cluster.

The following link gives some examples how you can restore this dumpfile into 
your database
cluster.
http://www.postgresql.org/docs/8.1/interactive/app-pgdump.html#PG-DUMP-EXAMPLES

If you are not sure how to use pg_dump you can read the rest of the document or 
you can run
"pg_dump.exe --help" from your command line.

Also, other people on the postgresql mailing list can benifit from our 
discussion.  In addition to
this, there are others on the list that might have better answers than the ones 
that I give.  So
it is important that you always send your emails to the mailing list.  The 
easiest way to do this
is to reply-all when you respond to emails from the list.

Regards,

Richard Broersma Jr.


 
-
Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates.

Re: [ADMIN] Advice on loading celko sql script

[Richard Broersma Jr]

> I was a little confused about how to reply, but now I see the yahoo option 
> REPLY TO EVERYONE, so
> I shall try it right now, and see if it works, and comes back from the 
> majordomo listserve.
> 
> I have an older version of Postgresql 8.1 I think or 8.0.  So your script did 
> not work
> perfectly.  I guess there are some new commands.
> 
> I tried to make your script work on MySQL,... but, at work I have the latest 
> install of
> PostgreSQL done last week, so, I am sure your script will work there.  And 
> once installed there,
> I can get the tables into Microsoft Access, and do my exercises there if I 
> wish, and share the
> exercise tables at utteraccess.com

I am using Postgresql 8.1.5.

you could upgrade your home server to 8.2.0 or 8.1.5 and it would work fine.

Regards,

Richard Broersma Jr.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

[ADMIN] What is best link to install latest postgresql on windows xp

[Philippe Salama]

I just uninstalled at home, because what I had is old and I want the latest.

I installed at work, but I forgot the best link to install the latest 
postgresql and also the odbc for windows so I can link to tables with MS Access.

Thanks!

 
-
Everyone is raving about the all-new Yahoo! Mail beta.

Re: [ADMIN] Advice on loading celko sql script

[Philippe Salama]

OK. I just uninstalled my old postgresql 8.0 and the odbc, and now I am 
installing the 8.2.1 and will install the odbc driver, and then I shall run 
your script.

Installation seems easier now than it was 2 or 3 years ago.

Thanks

Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > I was a little confused about 
how to reply, but now I see the yahoo option REPLY TO EVERYONE, so
> I shall try it right now, and see if it works, and comes back from the 
> majordomo listserve.
> 
> I have an older version of Postgresql 8.1 I think or 8.0.  So your script did 
> not work
> perfectly.  I guess there are some new commands.
> 
> I tried to make your script work on MySQL,... but, at work I have the latest 
> install of
> PostgreSQL done last week, so, I am sure your script will work there.  And 
> once installed there,
> I can get the tables into Microsoft Access, and do my exercises there if I 
> wish, and share the
> exercise tables at utteraccess.com

I am using Postgresql 8.1.5.

you could upgrade your home server to 8.2.0 or 8.1.5 and it would work fine.

Regards,

Richard Broersma Jr.



-
Everyone is raving about the all-new Yahoo! Mail beta.

Re: [ADMIN] What is best link to install latest postgresql on windows xp

[Shoaib Mir]

You can get that from here -->
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.2.0%2Fwin32%2Fpostgresql-8.2.0-1.zip

Regards,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:


I just uninstalled at home, because what I had is old and I want the
latest.

I installed at work, but I forgot the best link to install the latest
postgresql and also the odbc for windows so I can link to tables with MS
Access.

Thanks!

--
Everyone is raving about the all-new Yahoo! Mail 
beta.

[ADMIN] Installing postgres now. What is a good shareware admin program?

[Philippe Salama]

Thanks for install link.

Can anyone recommend a good freeware admin program for posgresql. Thanks!

Anyone use navicat (which is not free i know). Any opinions?  Thanks!

Shoaib Mir <[EMAIL PROTECTED]> wrote: You can get that from here --> 
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.2.0%2Fwin32%2Fpostgresql-8.2.0-1.zip
 

Regards,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06, Philippe Salama  <[EMAIL PROTECTED]> wrote:I just uninstalled at 
home, because what I had is old and I want the latest. 

I installed at work, but I forgot the best link to install the latest 
postgresql and also the odbc for windows so I can link to tables with MS Access.

Thanks!


-
Everyone is raving about the all-new Yahoo! Mail beta.  


 

 
-
Everyone is raving about the all-new Yahoo! Mail beta.

Re: [ADMIN] Installing postgres now. What is a good shareware admin program?

[Shoaib Mir]

Windows installer has pgAdmin bundled in, which can serve as a very easy to
use database administration software.

Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:


Thanks for install link.

Can anyone recommend a good freeware admin program for posgresql. Thanks!

Anyone use navicat (which is not free i know). Any opinions?  Thanks!

*Shoaib Mir <[EMAIL PROTECTED]>* wrote:

You can get that from here --> 
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.2.0%2Fwin32%2Fpostgresql-8.2.0-1.zip


Regards,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
>
> I just uninstalled at home, because what I had is old and I want the
> latest.
>
> I installed at work, but I forgot the best link to install the latest
> postgresql and also the odbc for windows so I can link to tables with MS
> Access.
>
> Thanks!
> --
> Everyone is raving about the all-new Yahoo! Mail beta.
> 

>


--
Everyone is raving about the all-new Yahoo! Mail 
beta.

[ADMIN] which ODBC to install

[Philippe Salama]

I just installed 8.2.1 postgresql. Now I want an odbc driver to work on my Dell 
XP with MS Access.  The choices are very confusing. Please advise. I am not a 
rocket scientist.  Thanks!

 
-
Want to start your own business? Learn how on Yahoo! Small Business.

Re: [ADMIN] which ODBC to install

[imad]

Use this ODBC driver to connect to PostgreSQL.

http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

Windows versions already contain ODBC drivers for MS Access.

--Imad
Rocket Scientist :-)

On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:

I just installed 8.2.1 postgresql. Now I want an odbc driver to work on my
Dell XP with MS Access.  The choices are very confusing. Please advise. I am
not a rocket scientist.  Thanks!


 
Want to start your own business? Learn how on Yahoo! Small Business.




---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] which ODBC to install

[Shoaib Mir]

Once you have installed PostgreSQL you can now use the ANSI or Unicode ODBC
driver from the ODBC driver manager in Windows as it gets installed
automatically during installation.

Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:


I just installed 8.2.1 postgresql. Now I want an odbc driver to work on my
Dell XP with MS Access.  The choices are very confusing. Please advise. I am
not a rocket scientist.  Thanks!

--
Want to start your own business? Learn how on Yahoo! Small 
Business.

Re: [ADMIN] which ODBC to install

[Joshua D. Drake]

On Sat, 2006-12-09 at 12:48 -0800, Philippe Salama wrote:
> I just installed 8.2.1 postgresql. Now I want an odbc driver to work
> on my Dell XP with MS Access.  The choices are very confusing. Please
> advise. I am not a rocket scientist.  Thanks!

http://projects.commandprompt.com/public/odbcng/browser/binaries/mODBC_Installer%28beta_00.99.0088%29.msi

Sincerely,

Joshua D. Drake

> 
> 
> 
> __
> Want to start your own business? Learn how on Yahoo! Small Business.
-- 

  === 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/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

[ADMIN] Installed postgresql8.2, ran the celko script

[Philippe Salama]

But now, the admin program is showing me EVERYTHING UNDER THE SUN, except the 
tables that were created by the script I ran.  I need to find some other admin 
program.  I dont understand why this admin program is so obscure.  I find 
others which are quite intuitive


 
-
Want to start your own business? Learn how on Yahoo! Small Business.

Re: [ADMIN] which ODBC to install

[Philippe Salama]

Thanks Joshua, but that link is about as clear as mud to a beginner like me. 
And another post explains that the ODBC was already installed along with 
postgresql. All I want to do is connect with MS Access.

By the way. I already have PGExplorer, and right away, it connected and showed 
me the Celko tables installed by the script I was given. BUT, there seems to be 
no data in the tables.??



"Joshua D. Drake" <[EMAIL PROTECTED]> wrote: On Sat, 2006-12-09 at 12:48 -0800, 
Philippe Salama wrote:
> I just installed 8.2.1 postgresql. Now I want an odbc driver to work
> on my Dell XP with MS Access.  The choices are very confusing. Please
> advise. I am not a rocket scientist.  Thanks!

http://projects.commandprompt.com/public/odbcng/browser/binaries/mODBC_Installer%28beta_00.99.0088%29.msi

Sincerely,

Joshua D. Drake

> 
> 
> 
> __
> Want to start your own business? Learn how on Yahoo! Small Business.
-- 

  === 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/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate





 
-
Everyone is raving about the all-new Yahoo! Mail beta.

Re: [ADMIN] which ODBC to install

[Joshua D. Drake]

On Sat, 2006-12-09 at 13:15 -0800, Philippe Salama wrote:
> Thanks Joshua, but that link is about as clear as mud to a beginner
> like me. And another post explains that the ODBC was already installed
> along with postgresql. All I want to do is connect with MS Access.

O.k. your question is a little broad. If you want to connect with MS
Access, you need to configure a DSN within Windows that uses a
PostgreSQL ODBC driver. Once your DSN is configured, you should be able
to connect to PostgreSQL.

That is of course assuming that you have configured PostgreSQL to allow
connections, but one step at a time. Here are some docs to help you on
the Windows side.

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.odbc.doc/odbcmst71.htm

Sincerely,

Joshua D. Drake



> 
> By the way. I already have PGExplorer, and right away, it connected
> and showed me the Celko tables installed by the script I was given.
> BUT, there seems to be no data in the tables.??
> 
> 
> 
> "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> On Sat, 2006-12-09 at 12:48 -0800, Philippe Salama wrote:
> > I just installed 8.2.1 postgresql. Now I want an odbc driver
> to work
> > on my Dell XP with MS Access. The choices are very
> confusing. Please
> > advise. I am not a rocket scientist. Thanks!
> 
> 
> http://projects.commandprompt.com/public/odbcng/browser/binaries/mODBC_Installer%28beta_00.99.0088%29.msi
> 
> Sincerely,
> 
> Joshua D. Drake
> 
> > 
> > 
> > 
> >
> __
> > Want to start your own business? Learn how on Yahoo! Small
> Business.
> -- 
> 
> === 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/
> 
> Donate to the PostgreSQL Project:
> http://www.postgresql.org/about/donate
> 
> 
> 
> 
> 
> 
> 
> __
> Everyone is raving about the all-new Yahoo! Mail beta.
-- 

  === 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/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

[ADMIN] pgexplorer cannot see data in tables

[Philippe Salama]

and yet, the script I ran clearly has inserts of data to the tables.  And there 
was no indication that something failed when I ran the script

Here is an excerpt from the script file

ALTER TABLE format.statuscodes OWNER TO postgres;

SET search_path = define, pg_catalog;

--
-- Data for Name: absenteeism; Type: TABLE DATA; Schema: define; Owner: postgres
--

INSERT INTO absenteeism VALUES (1, 1, '2006-06-30', 'DA', 1);


--
-- Data for Name: badges; Type: TABLE DATA; Schema: define; Owner: postgres
--

INSERT INTO badges VALUES (1, 1, '2006-06-30', 'A');
INSERT INTO badges VALUES (2, 1, '2006-06-30', 'I');


--
-- Data for Name: departments; Type: TABLE DATA; Schema: define; Owner: postgres
--

INSERT INTO departments VALUES (1, 'Piping');
INSERT INTO departments VALUES (2, 'Electrical');
INSERT INTO departments VALUES (3, 'Instrumentation');
INSERT INTO departments VALUES (4, 'Process');
INSERT INTO departments VALUES (5, 'Mechanical');


--
-- Data for Name: doctors; Type: TABLE DATA; Schema: define; Owner: postgres
--

INSERT INTO doctors VALUES ('Baker');
INSERT INTO doctors VALUES ('Dow');
INSERT INTO doctors VALUES ('DOW');



 
-
Need a quick answer? Get one in minutes from people who know. Ask your question 
on Yahoo! Answers.

Re: [ADMIN] which ODBC to install

[Philippe Salama]

Thanks Shoaib. You are perfectly correct! After I installed postgresql, but 
without installing any odbc driver, I went to MS Access, and found both the 
ANSI and the Unicode driver. I think I chose ANSI, ...  I was able to link to 
all the tables which the Celko script defined, and I was able to browse the 
test data in those tables, and yet PG explorer gave some kind of error when I 
tried to browse, and I could not for the life of me see where PGAdmin allows me 
to browse tables.

But, anyway I am making progress, and I have the latest postgresql installed, 
and MS Access can link to the tables.  Thanks, all!

Shoaib Mir <[EMAIL PROTECTED]> wrote: Once you have installed PostgreSQL you 
can now use the ANSI or Unicode ODBC driver from the ODBC driver manager in 
Windows as it gets installed automatically during installation.

Thanks,
--
Shoaib Mir
 EnterpriseDB (www.enterprisedb.com)

On 12/10/06,  Philippe Salama <[EMAIL PROTECTED]> wrote: I just installed 8.2.1 
postgresql. Now I want an odbc driver to work on my Dell XP with MS Access.  
The choices are very confusing. Please advise. I am not a rocket scientist.  
Thanks!
   

-
Want to start your own business? Learn how on Yahoo! Small Business.  


 

 
-
Need a quick answer? Get one in minutes from people who know. Ask your question 
on Yahoo! Answers.

Re: [ADMIN] which ODBC to install

[Shoaib Mir]

Glad to hear that it worked out good for you :-)

Thanks,
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:


Thanks Shoaib. You are perfectly correct! After I installed postgresql,
but without installing any odbc driver, I went to MS Access, and found both
the ANSI and the Unicode driver. I think I chose ANSI, ...  I was able to
link to all the tables which the Celko script defined, and I was able to
browse the test data in those tables, and yet PG explorer gave some kind of
error when I tried to browse, and I could not for the life of me see where
PGAdmin allows me to browse tables.

But, anyway I am making progress, and I have the latest postgresql
installed, and MS Access can link to the tables.  Thanks, all!

*Shoaib Mir <[EMAIL PROTECTED]>* wrote:

Once you have installed PostgreSQL you can now use the ANSI or Unicode
ODBC driver from the ODBC driver manager in Windows as it gets installed
automatically during installation.

Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
>
> I just installed 8.2.1 postgresql. Now I want an odbc driver to work on
> my Dell XP with MS Access.  The choices are very confusing. Please advise. I
> am not a rocket scientist.  Thanks!
> --
> Want to start your own business? Learn how on Yahoo! Small Business.
> 
>


--
Need a quick answer? Get one in minutes from people who know. Ask your
question on Yahoo! 
Answers.

[ADMIN] Command line struggles

[Philippe Salama]

Of course now, I am in psql command line, and trying in vain to make the 
examples work in "Beginning Databasses with POSTGRESQL" by Matthew and Stones.

I can type \H and see help
I can type \? and read the list that results, of commands

I see a prompt template1-#

yet when I type at that prompt

createuser 


AH wait! Light dawns on marblehead.

A more careful reading of the textbook reveals that createuser.exe is a program 
in \program files\postgresql\8.2\bin 

If I click on that createuser.exe icon in explorer, it prompts me for the name 
of the new user, the password, are they superuser.

If at the dos prompt, in \8.2\bin  I type createuser -U postgres -P neil

then, it also works, slightly differently than clicking the Icon, and echos 
something about a new role.

But, at least, I surmounted this hurdle, and can make some more progress with 
the textbook.

Hmmm... it tells me to also create a user named rick, who can create databases, 
but does not have permission to create new users.  I am not certain how to do 
this, since the createuser program does not respond exactly as the book 
describes



Shoaib Mir <[EMAIL PROTECTED]> wrote: Glad to hear that it worked out good for 
you :-)

Thanks,
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06,  Philippe Salama <[EMAIL PROTECTED]> wrote: Thanks Shoaib. You are 
perfectly correct! After I installed postgresql, but without installing any 
odbc driver, I went to MS Access, and found both the ANSI and the Unicode 
driver. I think I chose ANSI, ...  I was able to link to all the tables which 
the Celko script defined, and I was able to browse the test data in those 
tables, and yet PG explorer gave some kind of error when I tried to browse, and 
I could not for the life of me see where PGAdmin allows me to browse tables. 

But, anyway I am making progress, and I have the latest postgresql installed, 
and MS Access can link to the tables.  Thanks, all!

Shoaib Mir < [EMAIL PROTECTED]> wrote: Once you have installed PostgreSQL you 
can now use the ANSI or Unicode ODBC driver from the ODBC driver manager in 
Windows as it gets installed automatically during  installation.

Thanks,
--
Shoaib Mir
 EnterpriseDB (www.enterprisedb.com)

 On 12/10/06,  Philippe Salama <[EMAIL PROTECTED] > wrote: I just installed 
8.2.1 postgresql. Now I want an odbc driver to work on my Dell XP with MS 
Access.  The choices are very confusing. Please advise. I am not a rocket 
scientist.  Thanks! 
   

-
Want to start your own business? Learn how on  Yahoo! Small  Business.  


 
   

-
Need a quick answer? Get one in minutes from people who know. Ask your question 
on  Yahoo! Answers . 


 

 
-
Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get 
things done faster.

[ADMIN] New roles?

[Philippe Salama]

When I try clicking on the icon createuser.exe in \bin  ... if I create the new 
user rick, and say no to superuser, but yes to create databases, but no to 
create users, then it asks me about creating new ROLES, which my textbook does 
not mention


Just curious, which obviously, I may google on : POSTGRESQL ROLES, but just 
thought I would mention it here.

I should be on my feet shortly with the textbook exercises, and shall not have 
to ask quite so many questions.  Thanks!

 
-
Everyone is raving about the all-new Yahoo! Mail beta.

Re: [ADMIN] Command line struggles

[imad]

See this link from PostgreSQL 8.2 official documentation.

http://www.postgresql.org/docs/8.2/interactive/app-createuser.html

It clearly describes the details and sitches of the createuser binary.
And also, I would recommend using this documentation rather than
a book which may (actually will) contain references from older versions.

--Imad
www.EnterpriseDB.com


On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:

Of course now, I am in psql command line, and trying in vain to make the
examples work in "Beginning Databasses with POSTGRESQL" by Matthew and
Stones.

I can type \H and see help
I can type \? and read the list that results, of commands

I see a prompt template1-#

yet when I type at that prompt

createuser


AH wait! Light dawns on marblehead.

A more careful reading of the textbook reveals that createuser.exe is a
program in \program files\postgresql\8.2\bin

If I click on that createuser.exe icon in explorer, it prompts me for the
name of the new user, the password, are they superuser.

If at the dos prompt, in \8.2\bin  I type createuser -U postgres -P neil

then, it also works, slightly differently than clicking the Icon, and echos
something about a new role.

But, at least, I surmounted this hurdle, and can make some more progress
with the textbook.

Hmmm... it tells me to also create a user named rick, who can create
databases, but does not have permission to create new users.  I am not
certain how to do this, since the createuser program does not respond
exactly as the book describes



Shoaib Mir <[EMAIL PROTECTED]> wrote:
 Glad to hear that it worked out good for you :-)

Thanks,
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/10/06, Philippe Salama <[EMAIL PROTECTED]> wrote:
> Thanks Shoaib. You are perfectly correct! After I installed postgresql,
but without installing any odbc driver, I went to MS Access, and found both
the ANSI and the Unicode driver. I think I chose ANSI, ...  I was able to
link to all the tables which the Celko script defined, and I was able to
browse the test data in those tables, and yet PG explorer gave some kind of
error when I tried to browse, and I could not for the life of me see where
PGAdmin allows me to browse tables.
>
> But, anyway I am making progress, and I have the latest postgresql
installed, and MS Access can link to the tables.  Thanks, all!
>
> Shoaib Mir < [EMAIL PROTECTED]> wrote:
> Once you have installed PostgreSQL you can now use the ANSI or Unicode
ODBC driver from the ODBC driver manager in Windows as it gets installed
automatically during installation.
>
> Thanks,
> --
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
>
> On 12/10/06, Philippe Salama <[EMAIL PROTECTED] > wrote:
> > I just installed 8.2.1 postgresql. Now I want an odbc driver to work on
my Dell XP with MS Access.  The choices are very confusing. Please advise. I
am not a rocket scientist.  Thanks!
> >
> > 
Want to start your own business? Learn how on Yahoo! Small Business.
> >
>
>
>
> 
Need a quick answer? Get one in minutes from people who know. Ask your
question on Yahoo! Answers .
>




 
Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and
get things done faster.




---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

[ADMIN] Difference between ROLE and USER1

[Philippe Salama]

Ok, I found something on ROLE, but I am still puzzled on how ROLE differs from 
USER

http://www.postgresql.org/docs/8.1/interactive/sql-createrole.html


 
-
Want to start your own business? Learn how on Yahoo! Small Business.

[ADMIN] Well, I am making some progress with createdb/dropdb

[Philippe Salama]

The textbook wanted me to create-db -U neil bpsimple, but I accidentally 
created it as postgres.  I want to follow directions so future exercises will 
work ok.

It has taken me a  while to figure out that there are , in bin, programs such 
as createdb.exe which look for parameters on command line such as 
-U neil bpsimple

So, I had to figure out how to dropdb.exe -U postgres bpsimple

And then recreate it as createdb.exe -U neil bpsimple

It is confusing for me to keep straight which things are .exe in bin, and which 
are command lines in psql.



 
-
Have a burning question? Go to Yahoo! Answers and get answers from real people 
who know.

[ADMIN] \c bpsimple rick

[Philippe Salama]

My textbook had me create a user named rick, with the power to create 
databases, but not the power to create new users.

in the next exercise, I am in template1 as user neil, who has the prompt =# 
which means that neil has power to create databases.  I am told to \c bpsimple 
rick, and it says NOTICE THE PROMPT changes to =>, meaning rick has no power to 
create databases.

I am confused, since clearly, I created user/role rick as someone with the 
power to create databases.



 
-
Access over 1 million songs - Yahoo! Music Unlimited.

Re: [ADMIN] Installing postgres now. What is a good shareware admin

[[EMAIL PROTECTED]]

Under windows pgAdmin works very well.
If you install in under Linux I recommends you phpPgAdmin that is a wphp 
web application accessible from everywhere depending sour server accesses


Olivier


Shoaib Mir a écrit :
Windows installer has pgAdmin bundled in, which can serve as a very 
easy to use database administration software.


Thanks,
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com )

On 12/10/06, *Philippe Salama* <[EMAIL PROTECTED] 
> wrote:


Thanks for install link.

Can anyone recommend a good freeware admin program for posgresql.
Thanks!

Anyone use navicat (which is not free i know). Any opinions?  Thanks!

*/Shoaib Mir < [EMAIL PROTECTED] >/*
wrote:

You can get that from here -->

http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.2.0%2Fwin32%2Fpostgresql-8.2.0-1.zip



Regards,
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com )

On 12/10/06, *Philippe Salama * < [EMAIL PROTECTED]
> wrote:

I just uninstalled at home, because what I had is old and
I want the latest.

I installed at work, but I forgot the best link to install
the latest postgresql and also the odbc for windows so I
can link to tables with MS Access.

Thanks!


Everyone is raving about the all-new Yahoo! Mail beta.







Everyone is raving about the all-new Yahoo! Mail beta.






No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.15.14/578 - Release Date: 07/12/2006

  



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] \c bpsimple rick

[Philippe Salama]

I am guessing that my confusion is over something which may be a typo in the 
text book.

I have moved along and have now make good progress in running with \i the sql 
scripts which may be downloaded from 

http://www.apress.com/book/supplementDownload.html?bID=424&sID=2569

the publisher of the book,

to define tables for the exercises, and load the tables with data.

So, thanks for the help here to get me started!

Philippe Salama <[EMAIL PROTECTED]> wrote: My textbook had me create a user 
named rick, with the power to create databases, but not the power to create new 
users.

in the next exercise, I am in template1 as user neil, who has the prompt =# 
which means that neil has power to create databases.  I am told to \c bpsimple 
rick, and it says NOTICE THE PROMPT changes to =>, meaning rick has no power to 
create databases.

I am confused, since clearly, I created user/role rick as someone with the 
power to create databases.


   

-
Access over 1 million songs - Yahoo! Music Unlimited.

 
-
Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates.

Re: [ADMIN] Difference between ROLE and USER1

[Tom Lane]

Philippe Salama <[EMAIL PROTECTED]> writes:
> Ok, I found something on ROLE, but I am still puzzled on how ROLE differs 
> from USER

Users are the same thing as roles, pretty much.  A user is a role with
the LOGIN attribute ... roles with the NOLOGIN attribute correspond to
what we used to call groups.  You can find more about that in the docs:
http://www.postgresql.org/docs/8.1/interactive/user-manag.html

BTW, not to be impolite, but day-zero questions belong on pgsql-novice
not pgsql-admin.

regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [ADMIN] \c bpsimple rick

[Tom Lane]

Philippe Salama <[EMAIL PROTECTED]> writes:
> My textbook had me create a user named rick, with the power to create 
> databases, but not the power to create new users.
> in the next exercise, I am in template1 as user neil, who has the prompt =# 
> which means that neil has power to create databases.  I am told to \c 
> bpsimple rick, and it says NOTICE THE PROMPT changes to =>, meaning rick has 
> no power to create databases.

How old is your textbook?

What the # prompt actually means is that you are a "superuser", which
means you can do anything at all within PostgreSQL (equivalent to root
on a Unix system, and I-dunno-what on Windows).  Creating databases
is a lesser privilege.  It used to be that creating users was only
allowed to a superuser, but now we have a lesser privilege that allows
non-superusers to create more (non-super) users.  In any case, if you
are superuser you can definitely do both of those things.

If the book equates the # prompt to create-database privilege then it's
flat out wrong, or at least has been for as long as I can remember.
If it equates # to create-user privilege then it's only been wrong for
the last release or two.

regards, tom lane

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [ADMIN] Difference between ROLE and USER1

[Philippe Salama]

Oh sorry about posting in the wrong forum. You are perfectly right.  How do I 
navigate to join the novice forum?  I will bookmark the link for future 
reference.  Thanks for the explanation. I will post all future questions in the 
novice forum, once I find out how to join.  

Tom Lane <[EMAIL PROTECTED]> wrote: Philippe Salama  writes:
> Ok, I found something on ROLE, but I am still puzzled on how ROLE differs 
> from USER

Users are the same thing as roles, pretty much.  A user is a role with
the LOGIN attribute ... roles with the NOLOGIN attribute correspond to
what we used to call groups.  You can find more about that in the docs:
http://www.postgresql.org/docs/8.1/interactive/user-manag.html

BTW, not to be impolite, but day-zero questions belong on pgsql-novice
not pgsql-admin.

   regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


 
-
Everyone is raving about the all-new Yahoo! Mail beta.

Re: [ADMIN] \c bpsimple rick

[Philippe Salama]

The book has no date I can see, but I purchased it several years ago, and it 
speaks of PostgreSQL 8 as being new.

As soon as I find the link again to subscribe to the novice forum, I shall do 
so, and not post in Admin.  Thanks!

Tom Lane <[EMAIL PROTECTED]> wrote: Philippe Salama  writes:
> My textbook had me create a user named rick, with the power to create 
> databases, but not the power to create new users.
> in the next exercise, I am in template1 as user neil, who has the prompt =# 
> which means that neil has power to create databases.  I am told to \c 
> bpsimple rick, and it says NOTICE THE PROMPT changes to =>, meaning rick has 
> no power to create databases.

How old is your textbook?

What the # prompt actually means is that you are a "superuser", which
means you can do anything at all within PostgreSQL (equivalent to root
on a Unix system, and I-dunno-what on Windows).  Creating databases
is a lesser privilege.  It used to be that creating users was only
allowed to a superuser, but now we have a lesser privilege that allows
non-superusers to create more (non-super) users.  In any case, if you
are superuser you can definitely do both of those things.

If the book equates the # prompt to create-database privilege then it's
flat out wrong, or at least has been for as long as I can remember.
If it equates # to create-user privilege then it's only been wrong for
the last release or two.

   regards, tom lane


 
-
Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates.

Re: [ADMIN] Difference between ROLE and USER1

[Philippe Salama]

I found the novice subscribe link
http://archives.postgresql.org/pgsql-novice/

and subscribed as Karebac at my other email.

Tomorrow morning, I will unsubscribe her, and subcribe and post only if I have 
a legitimate ADMIN question, which probably wont be for a long time. Thanks!

Philippe Salama <[EMAIL PROTECTED]> wrote: Oh sorry about posting in the wrong 
forum. You are perfectly right.  How do I navigate to join the novice forum?  I 
will bookmark the link for future reference.  Thanks for the explanation. I 
will post all future questions in the novice forum, once I find out how to 
join.  

Tom Lane <[EMAIL PROTECTED]> wrote: Philippe Salama  writes:
> Ok, I found something on ROLE, but I am still puzzled on how ROLE differs 
> from USER

Users are the same thing as roles, pretty much.  A user is a role with
the LOGIN attribute ... roles with the NOLOGIN attribute correspond to
what we used to call groups.  You can find more about that in the docs:
http://www.postgresql.org/docs/8.1/interactive/user-manag.html

BTW, not to be impolite, but day-zero questions belong on pgsql-novice
not  pgsql-admin.

   regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly



-
Everyone is raving about the all-new Yahoo! Mail beta.

 
-
Everyone is raving about the all-new Yahoo! Mail beta.

Re: [ADMIN] Difference between ROLE and USER1

[Richard Broersma Jr]

> Oh sorry about posting in the wrong forum. You are perfectly right.  How do I 
> navigate to join
> the novice forum?  I will bookmark the link for future reference.  Thanks for 
> the explanation. I
> will post all future questions in the novice forum, once I find out how to 
> join.  

http://www.postgresql.org/community/lists/

You should spend some time to get familiar with the postgresql home page.  
There is alot of
information that will do you well to read.

http://www.postgresql.org/docs/techdocs

this link is very useful if you are enterested in learning about SQL and 
postgresql.

Regards,

Richard Broersma Jr.

---(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