MySQL and PGSQL and Hostname Question

Jeff Skeith

first, i would like the thoughts of some folks with more experience
than i have.

i want to learn pgsql. i have some vb and msaccess experience and
would like to learn how to use php and pgsql to develop some nice
website / application functionality.

however, i'm not sure the hurdle of relatively miniscule documentation
and tutorials is worth the effort. i'm now thinking i should just use
mysql to start and, if the need really arises, move over to pgsql.

i'm busy with a lot of stuff right now - regular job, starting a
business, developing a web site for the business, learning graphics
programs, living life, blah, blah, blah.

what is your opinion? go with the better documented db and develop
more quickly but have to possibly switch over later when time may be
more available and retain my hair or bite the bullet and go with
pgsql?

differing opinions are appreciated and encouraged so i can evaluate
them based on my own set of values.

also i am trying to set up localhost as my url so my hardcoded links
work on my local win98 machine (actual webserve is linux).

host.sam is as follows...

127.0.0.1 localhost www.easyautodeals.com

my apache httpd.conf file shows the following for ServerName:

ServerName www.easyautodeals.com

however, when i type easyautodeals into my web browser, i go straight
to my actual web server and not to my "localhost" location.

any guidance or direction w/b greatly appreciated.

Jul 16 '05 #1

Subscribe Reply

2179

Jeff Skeith

of course, i meant when i type "easyautodeals. com" toward the end of
my last note. a funny thing has happened. when i type
"www.easyautode als.com" into my web browser, it doesn't find my sight.
i have to type "easyautdoeals. com" or "http://easyautodeals.c om"

does anyone have any ideas why?

js******@san.rr .com (Jeff Skeith) wrote in message news:<ce******* *************** ****@posting.go ogle.com>...

first, i would like the thoughts of some folks with more experience
than i have.

i want to learn pgsql. i have some vb and msaccess experience and
would like to learn how to use php and pgsql to develop some nice
website / application functionality.

however, i'm not sure the hurdle of relatively miniscule documentation
and tutorials is worth the effort. i'm now thinking i should just use
mysql to start and, if the need really arises, move over to pgsql.

i'm busy with a lot of stuff right now - regular job, starting a
business, developing a web site for the business, learning graphics
programs, living life, blah, blah, blah.

what is your opinion? go with the better documented db and develop
more quickly but have to possibly switch over later when time may be
more available and retain my hair or bite the bullet and go with
pgsql?

differing opinions are appreciated and encouraged so i can evaluate
them based on my own set of values.

also i am trying to set up localhost as my url so my hardcoded links
work on my local win98 machine (actual webserve is linux).

host.sam is as follows...

127.0.0.1 localhost www.easyautodeals.com

my apache httpd.conf file shows the following for ServerName:

ServerName www.easyautodeals.com

however, when i type easyautodeals into my web browser, i go straight
to my actual web server and not to my "localhost" location.

any guidance or direction w/b greatly appreciated.

Jul 16 '05 #2

Sugapablo

Jeff Skeith wrote:

of course, i meant when i type "easyautodeals. com" toward the end of
my last note. a funny thing has happened. when i type
"www.easyautode als.com" into my web browser, it doesn't find my sight.
i have to type "easyautdoeals. com" or "http://easyautodeals.c om"

does anyone have any ideas why?

DNS issues probably. Your DNS entry has to have the following line in
order for www. to work:

www.easyautodeals.com. IN CNAME easyautodeals.c om.

P.S. I love postgres and highly recommend it. I think the docs are
quite good.

--
Sugapablo :: ru********@suga pablo.com
http://www.sugapablo.com | ICQ:902845

Jul 16 '05 #3

Similar topics

15459

MYSQL Backup & Restore using PHP ?

by: James | last post by:

HI, I'm looking for a script that will allow users/admins to have a one click backup solution for a MYSQL Database.. 'BACK DATABASE' button, click and its done... The a restore option, that shows all current backups, and restores the selected one with one click...

PHP

4984

Mysql User management

by: Lord Asriel | last post by:

I'm a newbie in mysql and I've a question about user definition in Mysql. According to informations collected from manuals I believed that a user definition specifying host="%" on mysql server 'A' granted me connection from whatever client (with command "mysql -hA -uuser -p"); but executing that command from server, to say, 'B', mysql denies access to user@B. The matter can be solved defining a new user with host B (it's to say...

MySQL Database

5436

Concurrent testing PostgreSQL Vs MySQL

by: Durai | last post by:

Hi All, I tested "concurrent testing" in MySQL. It works fine. But I couldn't do in PostgreSQL 7.3.4 on HPUX IPF. I got deadlock problem. I used the PHP script to update table( one script increment the column & another one decrement the column). Is the postgres support the concurrent access to update database? I got the following errors: test=# ERROR: deadlock detected ERROR: deadlock detected ERROR: deadlock detected .....

PostgreSQL Database

175

11348

Is my MySQL Gaining ?

by: Sai Hertz And Control Systems | last post by:

Dear all, Their was a huge rore about MySQL recently for something in java functions now theirs one more http://www.mysql.com/doc/en/News-5.0.x.html Does this concern anyone. What I think is PostgreSQL would have less USP's (Uniqe Selling Points

PostgreSQL Database

12496

Postgress and MYSQL

by: Bob Powell | last post by:

To whom it may concern: I find the recent articles in various trade publications a little disturbing due to the lack of PostgrSQL mention. I continue to see articles about how IBM may be considering MYSQL for development an open_source web database. Why isn't PostgreSQL being considered or talked about by major industry giants? As a DBA I know that Postgres is far superior to MYSQL but if the industry directs it's energies towards...

PostgreSQL Database

5035

Moving from MySQL to PGSQL....some questions

by: Karam Chand | last post by:

Hello I have been working with Access and MySQL for pretty long time. Very simple and able to perform their jobs. I dont need to start a flame anymore :) I have to work with PGSQL for my companies current project. I have been able to setup postgresql in my rh box and

PostgreSQL Database

5624

Hostname change - pgsql won't start

by: Andrew Melton | last post by:

I had to reboot my RH9 server, now Postmaster won't start: I had to change my hostname recently, I am guessing that had something to do with it. I have tried modifying to the pg_hba.conf file to allow any host to connect, but that doesn't seem to help. Are there any other places where the hostname or IP address is specified and would restrict access? Thanks.

PostgreSQL Database

5082

Cannot connect to MySql server on Fedora linux

by: smatta | last post by:

I have just installed MySql version 5.0-18 on Red Hat Fedora Core 4. It is running but I cant connect to it using MySql Query Browser running on my pc. >From my pc, I can telnet to the sql server / port. I get back a garbled message: 5.0.18-standardÂ§}WxyuadT,â˜»V6F?J5i1YMT= Should this be garbled ? or is there a problem ?

MySQL Database

15396

Why are databases created in /var/lib/mysql ???

by: linuxlover992000 | last post by:

I am a newbie in the world of MySQL. In fact I enabled it in my Linux box only because it is required to run WordPress (the blogging software). I was trying to plan ahead and figure out a way to backup (and restore) a database, should my Linux machine ever goes belly up. I disovered that the databases are stored in subdirectories under /var/lib/mysql. My questions are basically three: (1) Why /var/lib? Why not some /home/mysql or...

MySQL Database

8262

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8196

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8701

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8364

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6122

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5571

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4196

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2623

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1507

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General