General :: Shell Script To Back Up A Postgresql Database?
Jun 4, 2010I need a shell script to back up and restore a postgresql database.
View 1 Replies
ADVERTISEMENT
Programming :: Right The Shell Script Which Talk To Postgresql Database?
Jul 22, 2010i want to right the on linux box which have postgresql and i what some data from the different table and put it in .csv file.
View 2 Replies View RelatedGeneral :: Sharing Postgresql Database
Oct 1, 2010Am using mandriva 2008 i developed one simple application using cross platform = Qt3 Database = PostgreSQL
I want to share my database over peer to peer network.
server ip = 192.168.1.5
client ip = 192.168.1.6
Now how to share data over those ip?
Ubuntu :: Add Database To PostgreSQL Daemon
Feb 24, 2011While watching the text scroll by as I shut down I noticed that there is a PostgreSQL Daemon running somewhere. The question I have is, how do I add myself and my own database to this daemon or do I need to run one on my own user?
View 2 Replies View RelatedSecurity :: Securing My Postgresql Database ?
Jan 5, 2010I run Slackware 13.0 and I have an apache server 2.2.13 with a postgresql 8.4.1 database attached to it via php 5.3.0. Both the apache server and the postgresql database are on the same machine.
I have the apache server port 80 exposed to the WAN. It is not a fqdm, it's just a simple IP address. On my index page, a user can login with a user/password that encrypts to md5 via postgresql and takes them into the database.
Here is the vulnerability. Can't a hacker just scan port 80 and find my ip address running apache. Go to my index page, see that I accept user/password for authentication into my postgresql database. Then they could setup a script to simply inject html GET requests of random users and passwords and use those values on the php page(the one where the action link is pointing to in the form tag) that contains user login/password in php to login to my postgresql database. There's nothing stopping that. It would be a simple dictionary attack.
I checked out postgresql documentation and it suggested using ldap, kerberos, or md5 and not trust. I'm using md5 already. I currently use fail2ban for proftpd and sshd and it works great. After 6 failed user/pass attempts on either of these services, the IP gets banned via iptables for 24 hours. I love it. I was wondering if I could use that. Of course postgresql port is not exposed to the WAN which is a good thing. I know that when I put in a wrong user/pass from my index page, I get sent to a default postgresql pg_connect warning page. Perhaps I can increase the verbosity of postgresql's logger, find the phrase that it spits out when there's been a bad login and create a filter using that.
I understand that the way it is currently setup, my server is pretty secure, but where there's a will there's a way. I just feel that my postgresql database is unprotected even tho the postgresql port is not exposed to the WAN. They could just bruteforce from the apache server.
Server :: Cannot Create Database In PostgreSQL
Dec 26, 2010i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password
createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
General :: PostgreSql Error "database Disk Image Is Malformed" After Db Dump
Dec 9, 2010i created a db_dump from PostgreSql-8.2 and trying to dump it into PostgreSql-8.4 new install. 2 of the 3 databases are fine, except for minor issues, but the 3rd database is giving me the following error message when i start a service calling on it, assist: "database disk image is malformed"
View 1 Replies View RelatedUbuntu Servers :: How To Clear Postgresql Database Cache
Jan 16, 2010I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies View RelatedServer :: Can't Insert A Record In A Table On Postgresql Database?
Sep 2, 2010my database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening
View 2 Replies View RelatedServer :: Unable To Connect To Remote PostgreSQL Database With Java.derby
Aug 26, 2010Trying to get OpenbavoPOS to connect to my remote Postgresql database, but so far i've only been able to connect to the local postgres installation. I _am_ able to access the remote databases with psql. I've read literally dozens of pages, and am pulling my hair out. I'm trying jdbc:derby.//192.168.15.10:5432/bravo I get back java.sql.SQLException no suitable driver found for jdbc:derby.//192.168.15.10:5432/bravo If I use jdbc:derby./root/bravo - all is OK, using a local database created in /root I have jdk installed on the client; does it need to be on the server also?
Server = CentOS 5.4 PostgreSQL version 8.1.21
Client = CentOS 4.8 PostgreSQL version 8.1.4
[code]....
General :: Restore 200+ Mysql Database With Shell Script?
Jul 22, 2011I have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction.
View 1 Replies View RelatedGeneral :: Bash - Get ' Quote ` Back-tic Through The Shell Into Sed?
Aug 3, 2011In linux how do I to get the ascii decimal/hex/oct code from a char or a ascii char from a decimal/hex/oct code. I see from the gnu sed user manual that I can use the d# o# x# to specify a character but I am not sure how to use that. If some one has a better way to get the the ` and ' chars through I want to sed with the backtick '`' character and ''' single quote character.
sed '/`/p'
these don't work
sed '/'/p'
sed '/`/p'
General :: Place A Shell Script With Tail -f In The Back Ground?
Oct 6, 2010Following script name is 123.sh and I need to put this in the background if I do 123.sh -bg this will not bring me back to the prompt but echoes what ever I put (using echo hello >> /tmp/123) in to the /temp/123 file. the only way that I have found doing this is to do "nohup 123.sh &" to put this in to the background. Is this okay or is there any better way of doing this?
#!/bin/bash
# file name is 123.sh
tail -f /temp/123 | while read line
[code]...
General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?
Aug 7, 2010How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedGeneral :: Change To Shell Type That From SH To TCH And Back Again And Lost Coloring Of File System
Nov 18, 2010after i made the change to my shell type, that from SH to TCH, and back again, i lost my coloring for my file system, if you know what i mean, folders always come in blue, and devices in yellow hope you understand? now everything i do can't seem to differentiated between files colors anymore.
View 7 Replies View RelatedServer :: Database Back Up Not Working Perfectly?
Jul 19, 2011I an running a script Database backup script in my server.It is thworing error ,i have checked permissions for root@localhost , root has all privileges.
### MySQL Server Login Info ###
MUSER="user"
MPASS="password"
MHOST="localhost"
[code]....
and it is throwing error
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
Programming :: Checking Database It Running Or Not By Using Shell Script?
Jul 21, 20111. i need to check whether the oracle database is running or not if it is running it will run auto mount script.nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt&nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt &2. For every 1 hour i need to check above mount points is mounted or not if it is not mounted it should be mounted.
View 3 Replies View RelatedServer :: Change The Owner Of The Mysql Database With Shell Commands?
Jun 19, 2010i want to know how can i change the owner of the mysql data base with shell commands.
View 3 Replies View RelatedProgramming :: Shell Script To Copy Database Archivelogs Sequentially From One Directory To Another?
Jun 2, 2009want to write a shell script to copy database archivelog files sequential from one directory to another directory within a server. I am hereby enclosing the sample archivelog file name. Archive log filename : log_0000118432_1.arc (Here number 0000118432 will be sequentially incremented by 1 for next filename). Here the catch is all Archivelogs must be copied to destination directory. Previously copied files should not be copied.
View 3 Replies View RelatedProgramming :: Make Shell Script To Use Sqlplus To Update Some Database Table?
Feb 8, 2010How can I make shell script to use sqlplus to update some database table? This is what I'd like to make:
- login to db server (I have create ssh-keygen to bypass the login session)
- login sqlplus / as sysdba
- update status set status='END' where status='BEGIN';
- commit;
- quit;
I'm using oracle 10g database and SLES 9.0
General :: Monitor Database IO And Available Database Threads?
Mar 7, 2011am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies View RelatedOpenSUSE Install :: System Resets And Just Boots Back To The EFI Shell Again
Oct 13, 2010I am trying to install OpenSuse 11.3 x64 via EFI. I successfully performed a Windows 7 install and I'm trying to do the same thing with OpenSuse now. My system boots into the EFI shell. I can cd into the /efi/boot/ folder and run bootx64.efi. Immediately after I press enter I am presented with an ELILO boot: prompt which either eventually times out and continues or I can press enter and have it continue. Either way my system resets and just boots back to the EFI shell again.
Running bootx64.efi worked for starting the Windows 7 setup but it doesn't appear to be working with OpenSuse. Is this a broken feature or am I doing something wrong?
General :: Application Running As User Foo Log Onto Database As (database) User Foobar?
Jan 5, 2011I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies View RelatedGeneral :: Postgresql 9 En OpenSuse 11.3 Starting Failed
Jan 8, 2011Postgresql 9 en OpenSuse 11.3 Starting Failed
[Code]....
General :: Trying To Test PHP Connectivity To Postgresql 8.3.9 Setup
Aug 4, 2010I'm learning via baptism by fire method here, and need to test PHP connectivity to a local postgresql 8.3.9 setup. (CentOS 5.5 x86_64). I have got PHP and Postgres both working; I can pull up a test PHP page via web browser, and I can login to postgres via the command line. What I can't figure out is how to test PHP connectivity to the local DB.
I found this test script:
Code:
<?php
$conn = pg_connect ('dbname=template1');
?>
Which I've named, testdb.php - when I run ./testdb.php from the CLI though, I get:
Code:
./testdb.php: line 2: ?php: No such file or directory
./testdb.php: line 3: syntax error near unexpected token '"dbname=template1"'
./testdb.php: line 3: `$database=pg_connect ("dbname=template1");'
I've seen a LOT of pages describing the internal code of the PHP file, but as a newb to this, I don't know how to execute this test. I've ran chmod 755 against the file to verify permissions, but this didnt effect the results. I've also done a "chmod +x testdb.php"
Code:
PHP 5.1.6 (cli) (built: Mar 31 2010 02:39:17)
I realized I wasn't doing this:
Code:
php testdb.php
but when I do, I get this error message now:
"PHP Fatal error: Call to undefined function pg_connect() in /var/www/html/testdb.php on line 3"
General :: Uninstall Postgresql On System Redhat?
Nov 5, 2010I want to uninstall Postgresql on LINUX redhat. I have installed it from source. how do i do it?
View 5 Replies View RelatedGeneral :: How To Start Postgresql Server Automatically When Boot?
Aug 5, 2010I'm wondering how I start it automatically when I boot up the ubuntu 10.04? especially, when I created the user "postgres", I set a password to it. every time I issued "su - postgres" command, I need to give it a password.
View 2 Replies View RelatedGeneral :: PostgreSQL Service Failed To Start Or Stop
Jan 6, 2010I am using RHEL 5.0. I am having problem with postgresql service it is not starting, not stopping, not restarting.
View 5 Replies View RelatedGeneral :: [CentOs - Cluster Suite] Works For IP But Not For Tomcat , Postgresql / Sort It?
May 18, 2010I have made a cluster between two server.
In luci I can see that my cluster is green and the two nodes to.
I have make an IP resource and associate it to a service : green : I can relocate the service from a node to the other one and the IP appears in the list of IP addresses
The problem is that I have made the same in order to configure tomcat and postgresql and it does not work...
I put my configuration only for ip and tomcat:
My host configuration code...
General :: $HOME/.bashrc Disabled When User Shell Is 'rbash' (restricted Shell)?
Jun 15, 2011MACHINE: HP Proliant DL260G5OS: SLES 11 SP1kernel: Linux xserver 2.6.32.12-0.7-default #1 SMP 2010-05-20 11:14:20 +0200 x86_64 x86_64 x86_64 GNU/LinuxIt is used as remote xserver in a LAN.I have configured /usr/lib/restricted/bin/.rbashrc with some environment variables but when the users logon in the system finally is executed $HOME/.bashrc and some environment vars are overwritten.
View 2 Replies View Related