10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a situation where I have a list of airplanes that make a series of flights.
Therefore I am looking up the different flights that each airplane makes based on a postgres sql query:
select flightid from plane where airplane='DELTAx'
As a result I get a series of flight numbers... (0 Replies)
Discussion started by: JSNY
0 Replies
2. Shell Programming and Scripting
I made a script to remove Postgres if this is already installed on your system. I have a other script to install Postgres, so this script can be used before you going to install Postgres.
Do you like this script? I would love to hear feedback.
#!/bin/bash
#
#################################... (2 Replies)
Discussion started by: dannyvdberg
2 Replies
3. UNIX for Advanced & Expert Users
Dear Friends,
I need to add the postgres process in monit file ( Debian machine ). How to add that process in monit?. If anyone know the solution for this, pls let me know.
---------- Post updated at 02:27 PM ---------- Previous update was at 12:21 PM ----------
I have found the... (0 Replies)
Discussion started by: rekha_sri
0 Replies
4. Shell Programming and Scripting
I have this 15 postgres sql queries similar to below to run in linux... Its taking a lot of time to run (3hours) .
can any one plz guide me how can i reduce the time of execution
execute 'insert into cc.rpt_cons_sub_ccdb_data(report_date, server_name, report_type, count)
select... (3 Replies)
Discussion started by: nikhil jain
3 Replies
5. Shell Programming and Scripting
hi all,
a have problem to load *.txt to postgres
my database:
id_list_ip (nextval)
list_ip (varchar)
txt file (list_ip.txt)
hasilping_10.8.248.1
hasilping_119.110.112.226
hasilping_119.110.125.33
hasilping_125.22.1.25
hasilping_192.168.2.1
hasilping_202.73.96.70
script... (3 Replies)
Discussion started by: adi0926
3 Replies
6. Shell Programming and Scripting
Hi,
Please help me to write cron job for calling sql function
daily. I have Postgres database. (1 Reply)
Discussion started by: kulbhushan
1 Replies
7. Shell Programming and Scripting
I have a script that does db query in postgres. I'm trying to put in some error checking in the script. I keep running into the password prompt problem where when invalid credentials/or database is put it, it would prompt me for a password which hangs the script. Is there a way that I can check for... (0 Replies)
Discussion started by: zerofire123
0 Replies
8. Shell Programming and Scripting
Hi,
I'm working with postgres. Now I found a script to backup my databases.
# #!/bin/bash
#
# # setup environment
PG_PORT=5432
PG_HOME=/usr/lib/postgresql/8.3
PG_VAR=/backup
PG_DATA=/backup/data
PG_BACKUPS=/backup/backup
PG_LOGS=/backup/logs
... (6 Replies)
Discussion started by: karl_ha
6 Replies
9. Shell Programming and Scripting
hi friends,
i have script to take backup of postgresql server ....i am getting error like access denied
myscript.sh
sendEmail=/home/backup/scripts/sendEmail.pl
DAY=`/bin/date +%d-%m-%y`
DIR=/home/backup/psql/$DAY
test -d $DIR | mkdir -p $DIR
dblist="test test1 postgres"
for db in... (8 Replies)
Discussion started by: jagnikam
8 Replies
10. Shell Programming and Scripting
I have got the solution so just closing this issue. (3 Replies)
Discussion started by: jambesh
3 Replies
Alzabo::PostgreSQL(3pm) User Contributed Perl Documentation Alzabo::PostgreSQL(3pm)
NAME
Alzabo::PostgreSQL - Alzabo and PostgreSQL
DESCRIPTION
This documentation is about what special support Alzabo has for PostgreSQL, as well as what is lacking.
Postgres support is based on the 7.3.x version of Postgres. Alzabo should work with the 7.1 and 7.2 series, and may even work with the 7.0
series.
Mixed-case Table or Column Names
By default, Postgres treats table and column names case-insensitively. Because of this, Alzabo always quotes these names when generating
DDL SQL. If you are using tables or columns that contain upper-case characters, you should always call "$schema->set_quote_identifiers(1)"
as soon as you load your schema object. Otherwise, any method which generates DML SQL will fail.
Reverse Engineering
o Alzabo cannot determine from the existence of a sequence that the sequence is meant to be used for a particular column unless the
sequence was created as a result of making a column's type SERIAL.
This is because there is no link between the two in the Postgres' data dictionary tables and will probably never change.
Transactions
o Transactions are fully supported with Postgres.
Outer joins
o Left and right outer joins are supported.
o Full outer joins are not supported.
Constraints
Column constraints can be specified as column attributes. Table constraints can be specified as table attributes.
Foreign key constraints are generated automatically based on the relationships defined by your schema.
perl v5.8.8 2007-12-23 Alzabo::PostgreSQL(3pm)