My Requirement is some thing like this.
I have two database servers PG1 and PG2
I need to transfer one table from PG1 db server to PG2 db server. Table name i will get as parameter to p...
Hi Experts,
I just used the following commands to create a database and then assign a user to it:
createdb -U postgres MyServer
psql -U postgres -W -c "CREATE USER MyUser WITH NOCREATED...
Hello experts,
I had to install a database script on a Postgres 7.3 server, but I get an error when installing stored procedures.
The error stated that the language plpgsql was not supported...
im working on a site and im worried that if it takes off im gonna need to setup slony. ive never used replication before. im using Spring MVC/Tomcat 5.5. i have a few questions:
1) do...
My database backup failed last night (pg_dump): missing pg_database entry for database "accounting".
When I log into postgreSQL using psql, I cannot see any databases using "\l" but I can c...
hello. how can i get records between year? e.g 2008 to 2009? im using timestampz as the date field.
select * from records where date BETWEEN 01/01/2007 AND ????
i cant actually put 30/1...
Hi,
we need to create Replication on the Postgres 8.2 Version databases, located on the same LINUX server. Please help .
Regards,
I need to grant one of my users "SELECT" access to several (20-50) tables in our Postgresql database. I'm having to do it manually by entering each table at a time, per statement. There has to...
Hello experts,
i'm running postgresql on windows 2003 server.
i have installed pgAgent,
i have created a function in a database,
my function output values in a table of the same data...
how do I transfer the postgre database to another partition/directory?
source directory is in sdb1, target is a directory in sdc1.
how do I configure the server to point to the new locat...
I have a table containing IP ranges. It is being accessed frequently, each time page is loaded to check if customer's IP comes from allowed to visit country. Naturally it is very important to ...
I thought it would be better to ask my question by the following examples rather than a wordy explanation.
If I have a table that looks like this
Location Equipment id
----------...
i need to workd with jobs in postgresql,
i've installed pgAgent, script, service....create user postgres to logon....start it ....i have followed tutorials.
i can see the pgAgent Catalog ...
I am planning on upgrading postgres 7.4 to 8.1. I have both database versions current installed and running on different ports. I assume I can do a pg_dump of the 7.4 database and import int...
Hi,
like in mysql you have
use database db that selects the current database.
what is the equivalent in postgres ? it refuses "use database". In pg admin in the query editor how do I wr...
CREATE OR REPLACE FUNCTION level_of_day() RETURNS VOID AS
$$
DECLARE
vSQLQuery text;
vSQLInsert text;
vResult integer;
BEGIN
vSQLQuery := 'SELECT count(*) from rf_card';
EXECUTE v...
I have an array that has been collected from a user. It has a variable number of elements. I want to insert that array into the database into a column that is type int[] for example.
Is t...
Hi,
I've been a web developer for a number of years and I've subscribed to the methodology of creating PHP / Perl libraries which contains sql statements, doing all sorts of escapes an...
Hi
I wonder if any one would be able to help. I am trying to do the following as requested by client.
Setup 2 database servers with:
1. DRBD
2. heartbeat
3. PostgreSQL 2 seperate...
hello experts,
i need to create views with a pgAgent job.
i need a documentation or tutorial something to start with,
i can not find a good documentation on internet,
can anyone giv...
I am extracting data out of a PostgreSQL database using Cyrstal Reports. When I contacted the creator of the database because I couldn't get all of the info I needed, they told me the field I...
Hi Everyone,
I'm using a DLZ build of Bind. This allows a Bind DNS server to read DNS records from an database using in this case an ODBC connector. Most of the queries work sucessfully but...
I am looking for a way to set up a site where users can play around with a sample site and then when they leave have it revert back to the default data.
I already have a site with a Postgre...
If I run pgadmin, the error message is:
Error: Unable to initialize gtk, is DISPLAY set properly?
I think this means its expecting to run via X Windows, which is not running.
...
Hi experts,
I need to write a function that returns a recordset from a query based on the results of a prior query. something like this (I assume that this will NOT work, but something tha...
