Taber, Mark (mark...@dof.ca.gov)

User Information

Display Name:

Taber, Mark

Partial Email Address:

mark...@dof.ca.gov

Posts:

19	total
3	in PostgreSQL - Admin
9	in PostgreSQL - General
6	in PostgreSQL - Novice
1	in PostgreSQL - ODBC

5 Most Recent

All Posts

1) Taber, Mark Re: Front end?

+1 vote

Sorry...I jumped the gun. phpPgAdmin is for administering. After I went back and read the original...

PostgreSQL - Novice

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

Sorry...I jumped the gun.  phpPgAdmin is for administering.  After I went
back and read the original post (yes, I know, I should have done that before
I wrote), I see you're looking for something programmable.  Sorry.  


Mark Taber
State of California
Department of Finance
Infrastructure & Architecture

916.323.3104 x 2945
mark.taber@dof.ca.gov


-----Original Message-----
From: Afton & Ray Still [email protected: ra...@shaw.ca] 
Sent: Thursday, December 23, 2004 1:53 PM
To: [email protected: pgsql-n...@postgresql.org]
Subject: Re: [NOVICE] Front end?

Thanks to all for your suggestions.
RealBasic may be good, but It's too expensive for the moment, I'll definatly
keep Access in mind for letting others use the database, but as I don't have
Access....

I've got Apache, PHP, and PostGreSQL up and operational so we'll see what
happens.
I should try to provide a summry of what I've learned to the group, but I'm
not sure where to start.
Probably, other than make sure you read the manuals, the main things are to
install the three programs, and then test Apache by itself (can you see the
Apache test page?), and then test PHP with Apache(a good test is phpinfo().
) and finally get PHP to talk to PostgreSQL.
Thanks everyone
Ray

>
>>>>Now I need to figure out how to use the database. Is what I'm 
>>>>looking for the front end?
>
>>>>I'm looking for a front end(?) that is relativly easy, cheap or 
>>>>preferably free, and has fairly good abilities for formated output. 
>>>>I would also like to be able to create a standalone application if 
>>>>possible.
>
>>So what I'm looking for is a way to enter data and get fairly good 
>>looking (well formated) reports.
>>
>>I'd also like to be able
>>to create an aplication that I can give to a co-worker who is only 
>>semi-computer literate. It doesn't really matter if it's all self 
>>contained, as long as it's all transperent to the end user.
>
>
> I had only back-end experience for a while, and then wanted to make an 
> application also--perhaps similar to you.
>
> I like REALbasic.  It has some quirks, but it's quite easy to use for 
> someone who is not a professional programmer.  However you're looking 
> at a cost of a few hundred dollars.  It will compile a standalone 
> application for Mac, Windows, or Linux using the same code.  I've done 
> some crossplatform Mac/Windows stuff.  Again, there are some quirks, 
> but I think you're going to find those everywhere.
>
> As a free option, I believe you can use postgres with php with a web 
> browser as the environment.  THere are tons of books on php.  However 
> I found the syntax of REALbasic easier.  I think RB is also more 
> powerful when it comes to some things, although there are probably 
> people who would argue with me about that.  THe REALbasic "networked user
group" or "nug"
> is a fabulous resource.  You can get a free demo of RB.  If you try 
> it, start by writing some "hello world" applications (the tutorial is 
> reasonably good) BEFORE jumping straight into database programming.
>
> HTH.  I am also not a professional programmer.
>
> -Allan
>
> --
> Allan Berger, DVM, PhD, MBA
> Bright Eyes & Bushy Tails Veterinary Service <http://www.BrEBT.com>
> -and-
> Dept. of Internal Medicine
> University of Iowa, 500 EMRB
> Iowa City, IA  52242
> (319) 351-4256 (voice)
> (319) 341-8445 (fax)



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004


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

2) Taber, Mark Re: Front end?

+1 vote

We use phpPgAdmin (http://phppgadmin.sourceforge.net/) ...it's free, and a decent web-based front...

PostgreSQL - Novice

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

We use phpPgAdmin (http://phppgadmin.sourceforge.net/) ...it's free, and a
decent web-based front end.  Easy as pie to set up, too.  You've got all the
other parts in place (Apache, Postgres). 


Mark Taber
State of California
Department of Finance
Infrastructure & Architecture

916.323.3104 x 2945
mark.taber@dof.ca.gov


-----Original Message-----
From: Afton & Ray Still [email protected: ra...@shaw.ca] 
Sent: Thursday, December 23, 2004 1:53 PM
To: [email protected: pgsql-n...@postgresql.org]
Subject: Re: [NOVICE] Front end?

Thanks to all for your suggestions.
RealBasic may be good, but It's too expensive for the moment, I'll definatly
keep Access in mind for letting others use the database, but as I don't have
Access....

I've got Apache, PHP, and PostGreSQL up and operational so we'll see what
happens.
I should try to provide a summry of what I've learned to the group, but I'm
not sure where to start.
Probably, other than make sure you read the manuals, the main things are to
install the three programs, and then test Apache by itself (can you see the
Apache test page?), and then test PHP with Apache(a good test is phpinfo().
) and finally get PHP to talk to PostgreSQL.
Thanks everyone
Ray

>
>>>>Now I need to figure out how to use the database. Is what I'm 
>>>>looking for the front end?
>
>>>>I'm looking for a front end(?) that is relativly easy, cheap or 
>>>>preferably free, and has fairly good abilities for formated output. 
>>>>I would also like to be able to create a standalone application if 
>>>>possible.
>
>>So what I'm looking for is a way to enter data and get fairly good 
>>looking (well formated) reports.
>>
>>I'd also like to be able
>>to create an aplication that I can give to a co-worker who is only 
>>semi-computer literate. It doesn't really matter if it's all self 
>>contained, as long as it's all transperent to the end user.
>
>
> I had only back-end experience for a while, and then wanted to make an 
> application also--perhaps similar to you.
>
> I like REALbasic.  It has some quirks, but it's quite easy to use for 
> someone who is not a professional programmer.  However you're looking 
> at a cost of a few hundred dollars.  It will compile a standalone 
> application for Mac, Windows, or Linux using the same code.  I've done 
> some crossplatform Mac/Windows stuff.  Again, there are some quirks, 
> but I think you're going to find those everywhere.
>
> As a free option, I believe you can use postgres with php with a web 
> browser as the environment.  THere are tons of books on php.  However 
> I found the syntax of REALbasic easier.  I think RB is also more 
> powerful when it comes to some things, although there are probably 
> people who would argue with me about that.  THe REALbasic "networked user
group" or "nug"
> is a fabulous resource.  You can get a free demo of RB.  If you try 
> it, start by writing some "hello world" applications (the tutorial is 
> reasonably good) BEFORE jumping straight into database programming.
>
> HTH.  I am also not a professional programmer.
>
> -Allan
>
> --
> Allan Berger, DVM, PhD, MBA
> Bright Eyes & Bushy Tails Veterinary Service <http://www.BrEBT.com>
> -and-
> Dept. of Internal Medicine
> University of Iowa, 500 EMRB
> Iowa City, IA  52242
> (319) 351-4256 (voice)
> (319) 341-8445 (fax)



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004


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

3) Taber, Mark Re: Phantom user in db--'128'

+1 vote

Thanks! Worked like a charm. Mark Taber State of California Department of Finance Infrastructure &...

PostgreSQL - General

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

Thanks!  Worked like a charm. 


Mark Taber
State of California
Department of Finance
Infrastructure & Architecture

916.323.3104 x 2945
mark.taber@dof.ca.gov


-----Original Message-----
From: Tom Lane [email protected: t...@sss.pgh.pa.us] 
Sent: Friday, November 19, 2004 7:42 AM
To: Taber, Mark
Cc: [email protected: pgsql-ge...@postgresql.org]
Subject: Re: [GENERAL] Phantom user in db--'128' 

"Taber, Mark" <Mark.Taber@dof.ca.gov> writes:
> While using pg_dump and pg_restore (or attempting to restore, more 
> precisely), the process failed because of a missing user, user '128'. 
> I never created such a user, and when going to Privileges, such a user 
> does not exist in the list. However, while going out and checking some 
> of the tables, this user shows up as a user with privileges on them 
> (however, not on all tables). How do I get rid of this user? And how 
> do I ensure that it doesn't get created again?  I'd like to understand 
> what is really going on

You had a user with usesysid 128, whom you dropped, but he still had
privileges on some tables --- DROP USER is not good about detecting dangling
references.

I'd suggest recreating the user (CREATE USER foo WITH SYSID 128) and then
being careful to REVOKE all his privileges before you drop him again.  Or
you can just manually edit the dump file to remove the attempts to GRANT him
privileges.

   regards, tom lane

4) Taber, Mark Phantom user in db--'128'

+1 vote

I posted this earlier, and got no responses. While using pg_dump and pg_restore (or attempting to...

PostgreSQL - General

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

I posted this earlier, and got no responses.
While using pg_dump and pg_restore (or attempting to restore, more
precisely), the process failed because of a missing user, user '128'. I
never created such a user, and when going to Privileges, such a user does
not exist in the list. However, while going out and checking some of the
tables, this user shows up as a user with privileges on them (however, not
on all tables). How do I get rid of this user? And how do I ensure that it
doesn't get created again? I'd like to understand what is really going on
before hacking the user table.
Thanks in advance.

Mark Taber
State of California
Department of Finance
Infrastructure & Architecture

916.323.3104 x 2945
[email protected: mark...@dof.ca.gov] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2655.35">
<TITLE>Phantom user in db--'128'</TITLE>
</HEAD>
<BODY>

I posted this earlier, and got no responses. 
 While using pg_dump and pg_restore (or attempting to restore, more precisely), the process failed because of a missing user, user '128'. I never created such a user, and when going to Privileges, such a user does not exist in the list. However, while going out and checking some of the tables, this user shows up as a user with privileges on them (however, not on all tables). How do I get rid of this user? And how do I ensure that it doesn't get created again? I'd like to understand what is really going on before hacking the user table.

Thanks in advance. 

 

Mark Taber
 State of California
 Department of Finance
 Infrastructure & Architecture


916.323.3104 x 2945
 mark.taber@dof.ca.gov


</BODY>
</HTML>

5) Taber, Mark What is this phantom user 128?

+1 vote

While using pg_dump and pg_restore (or attempting to restore, more precisely), the process failed...

PostgreSQL - Admin

[ Profile | Reply to group ]

[ Flat Thread Threaded ]

While using pg_dump and pg_restore (or attempting to restore, more
precisely), the process failed because of a missing user, user '128'. I
never created such a user, and when going to Privileges, such a user does
not exist in the list. However, while going out and checking some of the
tables, this user shows up as a user with privileges on them (however, not
on all tables). How do I get rid of this user? And how do I ensure that it
doesn't get created again?

Thanks in advance.

Mark Taber
State of California
Department of Finance
Infrastructure & Architecture

916.323.3104 x 2945
[email protected: mark...@dof.ca.gov] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2655.35">
<TITLE>What is this phantom user 128?</TITLE>
</HEAD>
<BODY>

While using pg_dump and pg_restore (or attempting to restore, more precisely), the process failed because of a missing user, user '128'. I never created such a user, and when going to Privileges, such a user does not exist in the list. However, while going out and checking some of the tables, this user shows up as a user with privileges on them (however, not on all tables). How do I get rid of this user? And how do I ensure that it doesn't get created again?

Thanks in advance.


Mark Taber
 State of California
 Department of Finance
 Infrastructure & Architecture


916.323.3104 x 2945
 mark.taber@dof.ca.gov


</BODY>
</HTML>

Highlight

Profile | Posts (19)

Home > People > Taber, Mark