Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 7 of 7

Thread: PostgreSQL

  1. #1
    Senior Member leprechaun13's Avatar
    Join Date
    May 2005
    Location
    Northampton
    Posts
    487
    Member #
    10058
    Ok so since I see many people worshipping it I though I would investigate. While having a look at the psql I noticed there is no function to use a certain database, or at least not simiar to MySQL anyway, any ideas what it is?
    Regards Phil,


  2.  

  3. #2
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    22 times
    You specify it in the connection string to [phpfunction]pg_connect[/phpfunction]. For example:
    PHP Code:
    $handle pg_connect("host=localhost user=somebody password=password dbname=database"); 
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  4. #3
    Senior Member leprechaun13's Avatar
    Join Date
    May 2005
    Location
    Northampton
    Posts
    487
    Member #
    10058
    I was refering to when using 'psql' to postgred rather than through php, might have known it would be you that replied
    Regards Phil,


  5. #4
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    22 times
    Oh. It's a command-line argument when you start it. Type [typethis]psql --help[/typethis].

    Once you're actually inside the psql client, it's nothing like the MySQL client. It's not really better nor worse, just different.
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  6. #5
    Senior Member leprechaun13's Avatar
    Join Date
    May 2005
    Location
    Northampton
    Posts
    487
    Member #
    10058
    another question what module dlls do I need to load in php?
    Regards Phil,


  7. #6
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    22 times
    Don't know; I only use PHP on Linux and FreeBSD. I assume it's just called php_pgsql.dll.
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  8. #7
    Senior Member leprechaun13's Avatar
    Join Date
    May 2005
    Location
    Northampton
    Posts
    487
    Member #
    10058
    yea ive removed the semi colon from in front of the extension=php_pgsql.dll and I read here and it says I need to run the initdb command, I have done this and got the following output
    Code:
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/1, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  start transaction
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/69, nestlvl: 1, children: <>
    DEBUG:  commit transaction
    DEBUG:  StartTransaction
    DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  CommitTransaction
    DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
     1/1/0, nestlvl: 1, children: <>
    DEBUG:  proc_exit(0)
    DEBUG:  shmem_exit(0)
    DEBUG:  exit(0)
    ok
    initializing pg_authid ... ok
    initializing dependencies ... ok
    creating system views ... ok
    loading system objects' descriptions ... ok
    creating conversions ... ok
    setting privileges on built-in objects ... ok
    creating information schema ... ok
    vacuuming database template1 ... ok
    copying template1 to template0 ... ok
    copying template1 to postgres ... ok
    
    WARNING: enabling "trust" authentication for local connections
    You can change this by editing pg_hba.conf or using the -A option the
    next time you run initdb.
    
    Success. You can now start the database server using:
    
        "postgres" -D "dbdata"
    or
        "pg_ctl" -D "dbdata" -l logfile start
    still getting call to undefined function.
    Regards Phil,



Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 10:13 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2021 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com