[ADMIN] PostgreSQL 8.0.x on Windows XPe

Hello, Has anyone tried using PostgreSQL 8.0.x on Windows XPe? I tried installing and it failed on the Initialise database cluster step saying that it could not open the Secondary Logon service. The message indicated that the specified service does not exist as an installed service. The

[ADMIN] 7.0.3 - 7.1.2; pg_setlocale error

Hi, I am trying to migrate from 7.0.3 to 7.1.2. I just got the rpms from rawhide of redhat. While loading the 7.0.3 dump_file to 7.1.2, I got these errors... ERROR: stat failed on file '/usr/lib/pgsql/plpgsql.so': No such file or directory ERROR: PL handler function plpgsql_call_handler()

Re(2): [ADMIN] Re: cannot create new user in postgres

[EMAIL PROTECTED] writes: Dear Mike, I am trying to create the user but it was giving folllowing errors [postgres@ns data]$ su siddharta su: user siddharta does not exist This is how I created the user [postgres@ns data]$ createuser siddharta Enter user's

Re: [ADMIN] Use of the LIMIT clause ?

it's like SELECT * FROM :table WHERE :condition LIMIT :limit OFFSET :offset Sherwin [EMAIL PROTECTED] writes: I read on a website dedicated to MySQL, that the limit clause allows someone to restrict the result of a query to a certain domain. Exemple : "select

Re(3): [ADMIN] Postgres/Postmaster logging and log rotation

Thank you anyway. I have solve my problem in 6.5.3 (too old server) by creating pg_options verbose=2 query=1 syslog=0 hostlookup showportnumber I I set syslog=0 'coz I can't make it log to /var/log/postgresql. I removed "-d 2" in /etc/rc.d/init.d/postgresql: su -l

Re(2): [ADMIN] Postgres/Postmaster logging and log rotation

[EMAIL PROTECTED] writes: William L James writes: script - su -l postgresql -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start /var/log/postgresql 21"), but when the weekly logrotate.d function kicks in, Postgres logging stops. The logging probably continues to go to the

[ADMIN] Postgresql, DB2, replication

Hello All! Somebody told me that DB2 has replication. Does PostgreSQL has it also? Anyway, does anybody here know the difference between PostgreSQL and DB2? Thanks. Sherwin ---(end of broadcast)--- TIP 2: you can get off all lists at once with

Re: [ADMIN] Copying a Database

[EMAIL PROTECTED] writes: Is there an SQL command to inherit an entire database. Sean. AFAIK, there is none but you can use 'pg_dump'. Sherwin

Re(2): [ADMIN] Copying a Database

a followup to my reply... you can try 'copy'. database=# \h copy Command: COPY Description: Copies data between files and tables Syntax: COPY [ BINARY ] table [ WITH OIDS ] FROM { 'filename' | stdin } [ [USING] DELIMITERS 'delimiter' ] [ WITH NULL AS 'null string' ] COPY [ BINARY

Re(2): Re(2): [ADMIN] db server is too slow, real slow

[EMAIL PROTECTED] writes: On Fri, 20 Oct 2000, pgsql-admin wrote: The postgres server was started with the command: /usr/bin/postmaster -i -S -D/var/lib/pgsql Have you tried changing the values of -B to see if increasing the number of buffers helps? tried it already. i start postmaster

[ADMIN] db server is too slow, real slow

I'm using PostgreSQL 6.5.3 on i686-pc-linux-gnu. I have a backup of our database (sql dump and large object) backup.tar.bz2 with the size of 10121985. We have users accessing our database from http and odbc (ms excel). Can someone pls tell how to solve this problem? Thank you very much.

Re(2): [ADMIN] db server is too slow, real slow

settings did you start the server with, what queries are you running that are slow (with schema, index information), what does explain show for the queries? Stephan Szabo [EMAIL PROTECTED] On Thu, 19 Oct 2000, pgsql-admin wrote: I'm using PostgreSQL 6.5.3 on i686-pc-linux-gnu. I have a backup

Re(2): [ADMIN] Crontab and PostgreSQL Backup

you can also try this: #!/bin/sh # Backing up each database... pg_dumpall -o | bzip2 /var/lib/pgsql/backups/pgdumpall_`date "+%Y%m%d"`.bz2 # Removing backups of last seven days... find /var/lib/pgsql/backups -mtime +7 -exec rm -f {} \; Sherwin [EMAIL PROTECTED] writes: I use PostgreSQL

Re(2): [ADMIN] backup large Pg databases with large objects

date check_images set image = lo_import(textcat(textcat(ttext,''/''),image::text)) where image = tci.image; raise notice ''% %'', tint, tci.image; tint := tint + 1; end loop; update check_images set image = t1.image from check_images t1 where t1.n

[ADMIN] backup large Pg databases with large objects

Has anyone tried to backup all Pg databases with large objects? Pls share. Thanks. Sherwin

No Subject