[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 prob

Re: [ADMIN] Problems getting rserv working properly

[EMAIL PROTECTED] writes: >Hello: > >I am trying to get rserv working, so that I can do replication between a >master and a slave DB. I seem to be getting an error when I attempt >replication: > > ./Replicate testmaster testslave > > > ERROR Try this. ./Replicate --snapshot=/tmp/_

[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() doe

[ADMIN]

[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

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

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 : "selec

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 postgre

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 2>&1"), but >> when the weekly logrotate.d function kicks in, Postgres logging >> stops. > >The logging probably continues to go to

[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(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: [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: [ADMIN] Populating a Table

try INSERT INTO table2 SELECT DISTINCT ON key key, name, field1, field2 FROM table1; sherwin [EMAIL PROTECTED] writes: >Hello, > >I'm sure I'll be flagged as a moron for asking this question, so be it. > >I have some tables of info with no primary keys. As a result the field I >want to key

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?

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

ly need some additional information: > >What 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-adm

[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. Sherwi

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

t(text); >create function image_import(text) returns int4 as ' >declare > tci check_images%rowtype; > ttext alias for $1; > tint int4; >begin > update check_images set image = 0 from check_images t1 where t1.number = >0 and check_images.num

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 ve

[ADMIN] backup large Pg databases with large objects

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

[ADMIN] src/pl/tcl/mkMakefile.tcldefs.sh.in

For Digital UNIX 4.0D, shared libraries are created by: $ ld -shared -expect_unresolved "*" -o foo.so [objects] This presents a problem for mkMakefile.tcldefs.sh.in. In tclConfig.sh: TCL_SHLIB_LD='ld -shared -expect_unresolved "*"' >From mkMakefile.tcldefs.sh.in cat @TCL_

[ADMIN] PG 6.5 and src/interfaces/libpq++/Makefile.in

A few questions about src/interfaces/libpq++/Makefile.in: 1. How about changing: ifeq ($(CXX), g++) CXXFLAGS= -Wno-error else CXXFLAGS= endif to ifeq ($(CXX), g++) CXX

No Subject