Re: [ADMIN] Application gui

2005-03-01 Thread Andreas Motzkus
Am Dienstag, 1. März 2005 19:48 schrieben Sie: If you like C++ the Qt - package from Troll is a good choice too. You have generic database - objects like cursors and queries. Shipped with Qt there are libraries for postgresql and other databases like Oracle. Qt is also available for Windows. You

Re: [ADMIN] Error when trying to do a recovery

2005-03-01 Thread Tom Lane
Warren Little <[EMAIL PROTECTED]> writes: > When I start postgres (pg_ctl -l logfile start). The following text is > all that exists in the logfile: > <2005-03-01 14:21:43 MST>FATAL: incorrect checksum in control file > What control file is it referring to? $PGDATA/global/pg_control. I think t

[ADMIN] ALTER TABLE help.

2005-03-01 Thread Marco Rademeyer
Hi I am quite new to PostgreSQL. Could someone please help or gide me in the right direction. My problem is that I have a table with about 15 billion entries. I need to auto increment the table for the start and then every entry after that. I have create the field "num" that has the auto

[ADMIN] Running multiple postmaster instances in the same machine

2005-03-01 Thread Balaji Ganesan
Hi, I'm trying to run multiple postmaster instances on the same machine. I want to start and stop the server from inside of my application. However, for each of these instances, I want to specify a different "storage cluster". I understand that I can do that while initializing (initdb -D ). But

[ADMIN] Scheduling/Automated Jobs in Postgre

2005-03-01 Thread Aravindhan G.D
Hi All,   I need to do some user defined jobs when ever the Postgre server gets restarted. These tasks should be automated one i.e) When ever I restart the server the PL/SQL functions I have defined should be executed automatically without my intervention. This is to record some information

[ADMIN] Procedures, rules & UDF's....

2005-03-01 Thread Greg Patnude
Is there a quick and dirty SQL query where I can locate the rules, procudures and user-defined functions in the system catalogs ??? there ain't a ton of documentation on the pg_catalog tables & view TIA ---(end of broadcast)--- TIP 8: e

Re: [ADMIN] Database Name

2005-03-01 Thread Dorian Büttner
Envbop wrote: Can someone tell me where I can find the database names. login using psql and type \l ;-) chances are you have root access to the linux box, then you could modify pg_hba.conf to gain some access Do you have any account information at all? ---(end of broadcast

[ADMIN] ALTER TABLE help.

2005-03-01 Thread Marco Rademeyer
Hi I am quite new to PostgreSQL. Could someone please help or gide me in the right direction. My problem is that I have a table with about 15 billion entries. I need to auto increment the table for the start and then every entry after that. I have create the field "num" that has the auto i

[ADMIN] Database Name

2005-03-01 Thread Envbop
Hi I've just inherited a PostgreSQL database, for which I do not have any details of, like database name or the users. This used to be a library database which was managed via a web page written in php. Its running on a Linux box. The front end was also written in php. The original writers of this

[ADMIN] I have elaborated some useful views...

2005-03-01 Thread Martha Cecilia Ayala Hernández
Hello: I have elaborated some useful views for administration purposes: create or replace view pga_functions as select l.lanname as language, n.nspname || '.' || p.proname || '(' || pg_catalog.oidvectortypes(p.proargtypes) || ')' as name, t.typname as returntype, '\n\n'||

[ADMIN] Error when trying to do a recovery

2005-03-01 Thread Warren Little
Hello, I trying to do a restore using from the online backups. I have restored the data backup (untarred) and removed all files from the pg_xlog directory. I also deleted and recreated the archive_status directory under pg_xlog. I created the recovery.conf file with only the restore_command in i

[ADMIN] pgAdmin III on Slackware 10.0

2005-03-01 Thread Van Ingen, Lane
Does anyone know if the current versions of pgAdmin III posted at the download sites work OK under Slackware 10.0 ? They say they are for 9.0 / 9.1 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Application gui

2005-03-01 Thread Richard_D_Levine
Note this (currently active) thread from the archives: http://archives.postgresql.org/pgsql-general/2005-03/msg00025.php Rick Scott

Re: [ADMIN] Application gui

2005-03-01 Thread Scott Marlowe
On Tue, 2005-03-01 at 12:48, Philip Pinkerton wrote: > I am looking for an application builder to create an application to > enter client data into the database. > > any suggestions ? If you like java, netbeans is a nice simple development enviro. ---(end of broadcast)--

[ADMIN] Application gui

2005-03-01 Thread Philip Pinkerton
I am looking for an application builder to create an application to enter client data into the database. any suggestions ? thanks ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister You

Re: [ADMIN] Trouble using plpgsql after 8.0 install

2005-03-01 Thread Aaron Craig
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Embarassingly, I realize that I should have actually shut down and restarted the server before complaining that the install didn't work. Having shut down the machine for the night, I discovered that the problem disappeared when I restarted the machine t

[ADMIN] Error

2005-03-01 Thread Allan Kamau
Be sure you've supplied the username, password and database name when connecting, also check to see you don't have a “reject” policy that may impede your connection attempt. Be sure to instruct postgresql to reload the configuration files once you've modified the pg_hba.conf file. You may start by

Re: [ADMIN] Whats the file extention for custom format in pg_dump

2005-03-01 Thread Richard Sitompul
You can try pg_dump -U postgres -d -O databasename > databasename.sql Thanks, Richard Sitompul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gourish Singbal Sent: Tuesday, March 01, 2005 14:37 To: PgSQL Admin Subject: [ADMIN] Whats the file extenti