User Profile

Collapse

Profile Sidebar

Collapse
varathasiva
varathasiva
Last Activity: May 29 '08, 10:29 AM
Joined: Sep 2 '06
Location: china
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Reg MySQL server work as local network or remote server

    Dear All,
    I am new in MySQL.I installed mysql-5.0.51b-win32 version.How to configure in MySQL server work as local network or remote server.PostgreS QL we did configuration in pghba.conf host all all 0.0.0.0 0.0.0.0 md5.How we can do settings in MySQL 5.0 server.Please Help me.Advance thanks to all.
    Kindly Regards
    varathasiva
    See more | Go to post

  • varathasiva
    started a topic Reg Update Local Server to Remote Server

    Reg Update Local Server to Remote Server

    Hi,
    I have delphi database application through delphi7 database postgresSQL8.1 and zeos6.1.I have two postgreSQL8.1 database server.One is windows server working local network another one is linux remote server.When i make the data entries want update the local and remote server.How it is possible through Zeos component.I am apperciate your replies.Advance thanks to all
    Siva
    See more | Go to post

  • varathasiva
    replied to Reg Windows Master Linux Slave
    Dear rsk,
    thanks for ur relpy.I can't instal Slony-I 1.2.12 on my windows XP laptop showing error Module C:\Program Files\PostgreSQ L\8.1\lib\sleve nt.dll failed to register.HRESUL T-2147023898.Cont act your personal like this.How resolve this error and after instal the Slony-I.How to make the settings for replication can u send brief mail.Pls help me.Advance thanks.
    Kindly Regards
    Siva
    See more | Go to post

    Leave a comment:


  • varathasiva
    started a topic Reg Windows Master Linux Slave

    Reg Windows Master Linux Slave

    Dear All,
    I have two postgreSQL server one is windows another one is linux.My clients making data entry in windows server this all the data want to replicat in linux postgreSQL server every hour.How i can do this concept in postgreSQL.Pls advice me.Advance thanks to all.
    Kindly Regards
    Siva
    See more | Go to post

  • Reg Incremental Backup and Restore In Postgres 8.1

    Dear All,
    I want take a incremental backup and restore in postgres sql throught command.If you have any ideas reply me.Advance thanks to all.

    Kindly Regards
    Siva
    See more | Go to post

  • can u try to instal as Administrator
    See more | Go to post

    Leave a comment:


  • varathasiva
    started a topic Reg Postgres Data Base Server Will Be slow

    Reg Postgres Data Base Server Will Be slow

    Dear All,
    I have one Delphi 7 application software.In that software i am using backend for PostgreSQL 8.1 with linux server fedura version.I am using this software through internet.After getting more data in PostgreSQL database server will be slow.In delphi 7 i am using data access component Zeos Lib.I cann't fund where is the problem.Please advice where is the problem.Advance thanks to all.
    Kindly Regards
    Siva
    See more | Go to post

  • varathasiva
    started a topic Reg Postgres Data Base Server Will Be slow

    Reg Postgres Data Base Server Will Be slow

    Dear All,
    I have one Delphi 7 application software.In that software i am using backend for PostgreSQL 8.1 with linux server fedura version.I am using this software through internet.After getting more data in PostgreSQL database server will be slow.In delphi 7 i am using data access component Zeos Lib.I cann't fund where is the problem.Please advice where is the problem.Advance thanks to all.
    Kindly Regards
    Siva
    See more | Go to post

  • Hi Nilart,
    I am siva from china.Before i am also facing this same problem before.In windows vista you want instal as Adminstrator.Af ter Its working fine for me.Here i mention the steps

    1. Start/All Programs/Accessories
    2. Right-click on Command Prompt
    3. Select "Run as Administrator"
    4. Click OK on the dialog that appears
    5. cd \[The directory where you put the install files]
    ...
    See more | Go to post

    Leave a comment:


  • Dear All,
    Please reply my posting.Any body know about question.Still i am strugling i cannot connect the internet IP.Windows XP postgresSQL 8.1 server

    KIndly Regards
    Siva
    See more | Go to post

    Leave a comment:


  • Here mentioned pg_hba.conf files.Can you find for have problem in pg_hba.conf files

    # PostgreSQL Client Authentication Configuration File
    # =============== =============== =============== ======
    #
    # Refer to the PostgreSQL Administrator's Guide, chapter "Client
    # Authentication" for a complete description. A short synopsis
    # follows.
    #
    # This file controls: which hosts are allowed...
    See more | Go to post

    Leave a comment:


  • very very thanks.This way working fine for me.I am very happy about your posting.Because i am held up on last 15 days for instaling postgres in vista.

    Kindly Regards
    Siva
    See more | Go to post

    Leave a comment:


  • I think there is no firrewal problem.Because i can connect the system from oustside through remote destop and PCAnwhere software.

    I put the setting ip in pg_hba.onfig file like this
    host all all 202.153.125.184 255.255.255.0 md5.Pls advice where is the problem.Advance thanks to u

    Kindly Regards
    Siva
    See more | Go to post

    Leave a comment:


  • varathasiva
    replied to import Excel to postgreSQL
    Here i enclosed my sample codings.If you need you can use the coding like in delphi programing
    Code:
     var strFileName,cnt_str:string;
     flcid,cnt,scnt,i :integer;
     Temp_Worksheet : _WorkSheet;
    begin
      if chk_ch then
        begin
         try
          ExcelApplication1.Disconnect;
         finally
        end;
        end;
        ExcelApplication1.Connect;
        ExcelApplication1.Visible[0]:=True;
    ...
    See more | Go to post
    Last edited by michaelb; Jun 5 '07, 07:38 AM. Reason: Added the CODE tags

    Leave a comment:


  • I think there is no firrewal problem.Because i can connect the system from oustside through remote destop and PCAnwhere software.

    I put the setting ip in pg_hba.onfig file like this
    host all all 202.153.125.184 255.255.255.0 md5.Pls advice where is the problem.Advance thanks to u

    Kindly Regards
    Siva
    See more | Go to post

    Leave a comment:


  • How to configure static ip PostgresSQL 8.1 for windows XP system

    Dear All,
    I have instaled PostgresSQL 8.2 in windows xp system.That windows xp system have a static ip.I already update that static ip in pg_hba.config files after stop start postgresql service.Still i can't connect the postgressql database from outside.How to solve this problem.Pls adice me.Advance thanks

    With Kindly Regards
    Siva
    See more | Go to post

  • varathasiva
    replied to import Excel to postgreSQL
    U can use the excel application through by coding u can excport data to postgres sql table to excel like verse visa
    See more | Go to post

    Leave a comment:


  • varathasiva
    started a topic Reg Postgres Sql Replication Concept

    Reg Postgres Sql Replication Concept

    Dear All,
    I am using postgres sql 8.1 version.That version have a replication conecept.
    Hw to use the replication concept in postgres sql.I need to replicate one database server to another one server database.Pls help to me

    With Kindly Regards
    Siva
    See more | Go to post

  • Reg Postgres Sql Database Instal On Windows 2000

    Hi Every Body,
    Can i instal postgres sql database in windows 2000 server.Hw i can instal.Pls help to me.

    With Regards
    Siva
    See more | Go to post

  • Need Clarification About Replication Concept In Postgres Sql

    Dear All,
    Hw to use the replication concept in postgres sql.Pls help for me.
    With Regards
    Siva
    See more | Go to post
No activity results to display
Show More
Working...