Re: [ADMIN] Help me understanding the schema

Hi Scott, >> 7. we can set the privilege of user x for schema y >> ie. database aaa contains schema a1, a2 and a3. user xx can query from >> schema a1 only, user yy can query from schema a2 only? > No, perms on schemas control schema actions like create. perms on > tables control user access.

Re: [ADMIN] Help With Database Backup

Hi, Hello there, I am new to PostgreSQL, succeded in running a little database on my dev. machine and now I am having problems exporting the local database to the one I want to use on my site online. I am getting errors when I try to run the SQL online with phpPgAdmin. What errors are

Re: [ADMIN] Avoid duplicated rows when restoring data from pg_dumpall ??

Hi Pablo - As regards the duplicated rows, no, I don't get duplicated rows in all the tables stored in the database because some tables have primary-keys (and/or UNIQUE) constraints. These constraints don't allow the restore process to duplicate rows. In fact, it is a kind of "solution" I've t

Re: [ADMIN] Background color in query tool

Hi Benoit, Hello, The new option to define a background color for each server in PgAdmin 1.10 is very cool (to distinguish test servers from production servers). It would be very nice to have a reminder of this background color in the query module. You might like to post this q

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

FWIW, it does appear that 8.4 makes this better. OK cheers, I have got plans to migrate over the next month or two; just wanted to point out the issue. Andy -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

That sounds like you hadn't yet figured out to set CFLAGS too. Google or no Google, you're setting the wrong variable. I had to install PG 8.3.7 on another couple of machines today, and got exactly the same issue (setting all 3 variables) again on the SPI module. Please see as follows

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

Tom, That sounds like you hadn't yet figured out to set CFLAGS too. Actually if you see my first post, the only thing I'd changed was replaced "LDFLAGS="-m32"" with the "LD" variable and I had also tried adding that back in alongside CFLAGS and LD but to no avail. I compiled the module by

Re: [ADMIN] Compile errors when building 32-bit on 64-bit system

Tom, Doubtless, your problem is that you're setting LD not LDFLAGS. Nope, I originally had LDFLAGS set to "-m32" instead of LD, and it failed with another error trying to link the localtime.o object (which it had compiled as 64-bit) to create SYS-something-or-other.o (which it was trying

[ADMIN] Compile errors when building 32-bit on 64-bit system

I was going to post this to pgsql-hackers but figured it might be more suitable on this list first. I'm trying to compile a 32-bit PostgreSQL client on a 64-bit system, however the SPI module is not respecting the CFLAGS and LDFLAGS option "-m32." My configure line is as follows: CFLAGS="-m3

Re: [ADMIN] PHP cann't access to postgres databse

If it was trying to get that sort of connection, rather than TCP/IP, the message would be different. Something like: # could not connect to server: No such file or directory # Is the server running locally and accepting # connections on Unix domain socket "/tmp/.s.PGSQL.5432"? Ah ye

Re: [ADMIN] PHP cann't access to postgres databse

Because the error is "Permission denied", I'm guessing it's permissions on the /tmp/.s.PGSQL.5432 socket that will need checking? The OP's PHP script when run standalone is probably running as root. don...@caltech.edu wrote: the error message in Apache error-log is " PHP Warning: pg_connect()

Re: [ADMIN] Yum upgrade of PostgreSQL 8.4 from to rc1 rendered data unusable

Hi, As Scott wrote: This is **not** yum's fault. It is your fault actually. Even if you did this upgrade from sources, it would still be broken. PostgreSQL does not guarantee not to change on-disk data structure between development snapshots. I sort of agree with both sides of the issue - i

Re: [ADMIN] pg_dump not appending sequence to default values

No, it isn't. If the search_path was "product" when the table definition was loaded, No it wasn't. When the table was initially created (from scratch not from the dump) the search path was the default of "$user", public. I've just re-created this using the following steps on a blank data

Re: [ADMIN] pg_dump not appending sequence to default values

Hi Tom The reason it's printed as just 'tax_id' is that that relation should be first in the search_path at this point. Yes, that's true - it's in the search path because (so I believe) pg_dump is adding a "SET search_path..." line before it carries out the commands in the schema, which wor

[ADMIN] pg_dump not appending sequence to default values

I've come across an issue with pg_dump from 8.3.7 (running on Windows.) I'm using pg_dump to dump the schema only of the database for a system I'm currently displaying. The other day I had to re-create the database using the latest dump, and for a lot of the tables I now get the error "relati

Re: [ADMIN] reindexdb -t schema.table name

Hi Tom No. What would work is REINDEX TABLE "system"."supplier"; Ah, thanks for pointing that out, I never clicked on the quoting of the table name. reindexdb isn't designed to support schema-qualified names. You'd need another switch to pass the schema name. Could it be an option

Re: [ADMIN] reindexdb -t schema.table name

Hi, I've also replicated DjK's issue using a table called "supplier" in my "system" schema. # andyshel bin (networkmail): ./reindexdb -h localhost -d mydb -t "system.supplier" reindexdb: reindexing of table "system.supplier" in database "mydb " failed: ERROR: relation "system.supplier" does

Re: [ADMIN] Security question UNIX Sockets vs CIDR style access

I think you're confusing the here. PS. That should have been "I think you're confusing concepts here" - deleted the wrong word! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Security question UNIX Sockets vs CIDR style access

Hi Kevin, Kevin Kempter wrote: Hi All; I'm looking for thoughts/feedback on the use of UNIX Sockets vs standard CIDR style access (i,e, Ident, MD5, etc) to a Postgres Cluster. What are the pros/cons, which is more secure and why, etc... I think you're confusing the here. CIDR refers to a me

Re: [ADMIN] Getting image from a DB

Hi Felix, I've not written an image specifically, but I have read/written byte data which is all an image is. Your PostgreSQL database column that holds the image should be of type "bytea." Your PHP application must then use the following functions: Writing to the database - http://uk2.php

Re: [ADMIN] How to run PostgreSQL?

Hi Jan initdb: directory "/usr/local/pgsql/data" exists but is not empty If you want to create a new database system, either remove or empty the directory "/usr/local/pgsql/data" or run initdb with an argument other than "/usr/local/pgsql/data" ---

Re: [ADMIN] 8.3 RC1 - Logging and filenames

Hi all, But surely if the rotation is disabled, PostgreSQL will just append to the log if it exists (hence the extra option of "truncate on rotation?") Many services use a single log file and just keep adding to it - that's the way I'd prefer to set PostgreSQL up, simply so I can predict what the

[ADMIN] 8.3 RC1 - Logging and filenames

Hi, I'm just trying out the RC1 release of 8.3, and I'm seeing something strange with the logging configuration. What I want PostgreSQL to do is put a log file "postgresql.log" in "/var/log/pgsql" - I have an application that handles log rotations, so would prefer to do it with that, rather than h

Re: [ADMIN] Configure pg_hba.conf

Hi Alexander, Use 0.0.0.0/0. You can of course add multiple lines to match all your ranges (e.g. 192.168.0.0/24, 10.0.0.0/8 etc.) Regards, Andy. Alexander B. wrote: Hi people, I would like to configure pg_hba for any IP. I have several network mask, some times 192..., or 10, or 1

Re: [ADMIN] Parse the DF file to table

I think you need to provide more information on what you're trying to do, and the version of PostgreSQL you're using, which environment etc. If you're talking about reading a comma-delimited or tab-delimited text file, then see the COPY FROM command. http://www.postgresql.org/docs/8.2/static/s

Re: [Spam] Re: [ADMIN] How to compile with different MAXALIGN?

id a situation where I'll have to bring the db down long enough to pull a backup dump onto portable media, drive to the colo, and restore it... (I'll do a pre-live test run of whatever procedure I go with, but...) Sean Andy Shellam wrote: From experience I would say NEVER NEVER t

Re: [ADMIN] How to compile with different MAXALIGN?

From experience I would say NEVER NEVER try and do a direct copy across different platforms (Windows -> Linux.) Someone may contradict me, but I think a dump/restore would be the way to go. What sort of size of data are we talking? You'll need to factor in the time it takes to dump the data,

Re: [ADMIN] security question

One quick point - you don't need to alter anything in the template1 database to set user's passwords. In PgAdmin III - use the "Login roles" section to set the passwords - that way everything will get committed correctly. Also, have you restarted PostgreSQL since changing pg_hba.conf? Andy. D

Re: [ADMIN] Running in single instance mode

Remove other users' entries in pg_hba.conf so it only allows your username from your machine. Andy. Karthikeyan Sundaram wrote: Hi Everybody, We are using postgres 8.1.0. I want to do some maintenance work. Hence, I want to run postgres in single user mode so that external people won'

Re: [ADMIN] pg_hba.conf & putty

What address are you using for "server.ip.address"? I believe this is the address you should put in your pg_hba.conf, not 127.0.0.1. Then in PgAdmin, connect to localhost:5432. You can always check your PostgreSQL logs and see what source address the request is coming from. Andy. Moritz Bay

Re: [ADMIN] [INTERFACES] where postgres 8.1.8 log messages go

ar/log/pgsql the same thing happen. what else I need to do to make things right? jing - Original Message From: Andy Shellam (Mailing Lists) <[EMAIL PROTECTED]> To: jing han <[EMAIL PROTECTED]>; [EMAIL PROTECTED] Sent: Tuesday, February 27, 2007 10:57:09 AM Subject: Re: [INTERFAC

Re: [ADMIN] host name?

Igor Neyman wrote: Is there a function (or catalog view) that I can call in psql and that will tell me host name of the machine on which Postgres database is running? Igor Surely you need to know this to connect to it in the first place?

Re: [ADMIN] PostgreSQL and VB.net

Vishal Mailinglist wrote: Hi , I have a program already working on LAMP architecture. Now since the business logic is in PostgreSQL. We were interested to build the front end on VB.net. Would like to know the readiness of PostgreSQL working with VB.net . Would appreciate If anyone can sugge

Re: [ADMIN] [pgadmin-support] UNSUBSCRIBE

To all who want unsubscribing, it is best to fill out this form: http://www.postgresql.org/community/lists/subscribe Regards, Andy. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs

Re: [ADMIN] log_duration?

Ray Stell wrote: I toggle log_duration: wiki=# \!date Mon Feb 19 11:14:35 EST 2007 wiki=# set log_duration=off; SET wiki=# SELECT current_setting('log_duration'); current_setting - off (1 row) yet duration continues to be logged: wiki,13190,wiki,2007-02-19 11:16:00.926 EST,4

Re: [ADMIN] 8.2 Admin Pack broken?

Peter Eisentraut wrote: Andy Shellam (Mailing Lists) wrote: Not particularly!! Don't know what it is but it doesn't _appear_ to be GNU. According to "man make" it is a "FreeBSD General Command." I can tell you that "./configure && make &&

Re: [ADMIN] 8.2 Admin Pack broken?

Tom Lane wrote: "Andy Shellam (Mailing Lists)" <[EMAIL PROTECTED]> writes: FYI: Reports on Google are wrong - they say that you need to use "gmake" to build the PostgreSQL server source. You don't. I can assure you that you need GNU make to build any

Re: [ADMIN] 8.2 Admin Pack broken?

sion of make exists under "/usr/bin/make." Just typing "make" builds PostgreSQL just fine with the Unix make. However, the contrib modules *won't* build with the Unix make - I had to run "/usr/local/bin/make" instead of just "make." HTH someone, An

[ADMIN] 8.2 Admin Pack broken?

I'm trying to compile in the "adminpack" into PostgreSQL 8.2.3, but it doesn't want to build. According to the instructions, I change into "contrib/adminpack" and run "make" followed by "make install." However, make fails: [EMAIL PROTECTED] /endeavour/software/cache/postgresql-8.2.3/contrib

Re: [ADMIN] Debug (is it PostgreSQL?)

cking for jobs to run DEBUG: Sleeping... DEBUG: Clearing inactive connections DEBUG: Connection stats: total - 1, free - 0, deleted - 0 DEBUG: Checking for jobs to run DEBUG: Sleeping... Can someone tell me what is it ? !DSPAM:37,45d5ff7518515849972366! -- Andy Shellam NetServe Support Team

Re: [ADMIN] WAL files backup

Chad Wagner wrote: On 2/15/07, *Eduardo J. Ortega* <[EMAIL PROTECTED] > wrote: After erasing the "less than names" WAL files, we add to tar the remaining WAL records (0003B, 0003C and so on on the example). The more WAL files you have after 0003B,

Re: [ADMIN] rename a cluster

It comes under Server Startup: http://www.postgresql.org/docs/8.2/static/server-start.html Ray Stell wrote: Many thx. It that in the doc? On Thu, Feb 15, 2007 at 06:21:05PM +, Andy Shellam (Mailing Lists) wrote: The cluster's "name" is only the file-system's

Re: [ADMIN] rename a cluster

--(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster !DSPAM:37,45d4a8511420134615! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834

Re: [ADMIN] PgAdmin : table backup problem

Tom Lane wrote: "Cassiano, Marco" <[EMAIL PROTECTED]> writes: If I understand well, PgAdmin fails in composing the correct pg_dump command. The switch combination -t collezioni -n anamat doesn't work. The manual says that the -n switch is ignored when -t is used The right (at least, working)

[ADMIN] Re: Θέμα: Re: [ADMIN] possi ble Bug in windows version ?

(spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων http://login.yahoo.com/config/mail?.intl=gr Χρησιμοποιείτε Yahoo! Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μη

Re: [ADMIN] Postgres is not starting or stopping

ous fares is fun. Let Yahoo! FareChase search your favorite travel sites <http://farechase.yahoo.com/promo-generic-14795097;_ylc=X3oDMTFtNW45amVpBF9TAzk3NDA3NTg5BF9zAzI3MTk0ODEEcG9zAzEEc2VjA21haWx0YWdsaW5lBHNsawNxMS0wNw--> to find flight and hotel bargains. !DSPAM:37,45c34f2c118211085466303! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834

Re: [ADMIN] unsubscribe

are not necessarily the views of the RTA. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. !DSPAM:37,45c11c5f118218703124696! -- Andy

Re: [ADMIN] Another way to Replicate

Andy Shellam (Mailing Lists) wrote: Chad Wagner wrote: On 1/19/07, *Alexander B.* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: I would like to know if is possible to replicate in postgres applying binary logs (wal logs) like the same way is done on Oracle!!

Re: [ADMIN] Another way to Replicate

Chad Wagner wrote: On 1/19/07, *Alexander B.* <[EMAIL PROTECTED] > wrote: I would like to know if is possible to replicate in postgres applying binary logs (wal logs) like the same way is done on Oracle!! Did anybody tried to do that? You could do it, yes,

Re: [ADMIN] Incremental Backup of a particular database

new WAL logs to arrive and apply them on top of a base backup. There is a project in PgFoundry to allow for warm-standby in the 8.0 and 8.1 series, however this is reportedly built-in to 8.2 now. - Shoaib Mir EnterpriseDB (www.enterprisedb.com <http://www.enterprisedb.com>) On 1

Re: [ADMIN] Incremental Backup of a particular database

I believe the option for a "warm standby" (which sounds like it is what you need) was made available in 8.2.0. You'd have to look at the manual though, I haven't had time to investigate, and I'm not sure whether it's cluster-wide, or database-specific. Yogvinder Singh wrote: Hi Ppl, I have

Re: [ADMIN] windows silent installer .msi file

TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate !DSPAM:37,45a79d8913710645842! -- Andy Shellam Net

Re: [ADMIN] configuring the postmaster.log

I set redirect_stderr = on in postgresql.conf ? Setting "redirect_stderr = on" will mean that all errors that would normally appear on the console that started the Postmaster will be sent to log_filename instead.. -- Andy Shellam NetServe Support Team the Mail Network "an alt

Re: [ADMIN] Can not connect to database in Workgroup-Net on Windows-XP

D-85640 Putzbrunn Phone Office +49 (0)89 600 6920 Phone Fax +49 (0)89 600 69220 Web Web http://www.joops.com JOOPS *-- the software company --* !DSPAM:37,45a60e36137102078430163! -- And

Re: [ADMIN] Database Create Date

Andy Shellam (Mailing Lists) wrote: Bruno Wolff III wrote: On Wed, Jan 10, 2007 at 10:00:37 +0200, Achilleas Mantzios <[EMAIL PROTECTED]> wrote: Στις Τρίτη 09 Ιανουάριος 2007 18:10, ο/η Andy Shellam (Mailing Lists) έγραψε: Achilleas Mantzios wrote: I was able to find t

Re: [ADMIN] Database Create Date

Bruno Wolff III wrote: On Wed, Jan 10, 2007 at 10:00:37 +0200, Achilleas Mantzios <[EMAIL PROTECTED]> wrote: Στις Τρίτη 09 Ιανουάριος 2007 18:10, ο/η Andy Shellam (Mailing Lists) έγραψε: Achilleas Mantzios wrote: I was able to find that in FreeBSD the -U in ls (1) do

Re: [ADMIN] Database Create Date

w the last modified time using "ls -l --time=atime" Also in FreeBSD (at least, 6.1) there is no "-U" option to ls; there is a "-u" option but this shows the last access, not the creation time. -- Andy Shellam NetServe Support Team the Mail Network

Re: [ADMIN] Database Create Date

Negandhi, Nishith wrote: Hi, I need to know the create date of databases on PosegreSQL. PG_DATABASE does not provide this information. Are there any other system catalogs that can provide the above information?? Thanks !DSPAM:37,45a3b385137101969839670! I'm sure there is (not known to me atm)

Re: [ADMIN] Can't See Data - Plz Help!

One other thing I've just thought of, if you issue a manual query from within pgAdmin - does this succeed? Also roughly how big are the tables (i.e. number of rows) - does it help if you set a LIMIT in the SQL clause (by default I think it's 1000 rows but try setting a LIMIT of 1 row and see if

Re: [ADMIN] Can't See Data - Plz Help!

---- TIP 2: Don't 'kill -9' the postmaster !DSPAM:37,459e7bd3137101637590987! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] Recovering a deleted database problem

that Tom, after glancing through the online documentation, I've enabled logging of checkpoints etc. by setting "log_min_messages" to "log" - is this enough to log the times that transactions are committed, so I can find this info should I need it again in the future? Thanks

Re: [ADMIN] Recovering a deleted database problem

relevant, or is it just when dropping a complete database? Many thanks, Andy. Tom Lane wrote: "Andy Shellam (Mailing Lists)" <[EMAIL PROTECTED]> writes: (Note, after writing this, I tried restoring to a minute earlier (ie. 18:57:40) and still have the same problem. The

Re: [ADMIN] Connectionstring

Hmm OK was worth a shot - probably best bet would be to ask on pgsql-interfaces. Andy. Sistemas C.M.P. wrote: With or without asterisks it doesn't work. This string work on ODBC but not with pgOLEDB - Original Message - From: "Andy Shellam (Mailing Lists)" <[EMA

Re: [ADMIN] Connectionstring

Excuse the asterisks - they were added in by my mail client - it should be "Encoding=UNICODE" Andy Shellam (Mailing Lists) wrote: Doing a quick Google search, it appears to be, you add "*Encoding*=UNICODE" or whatever you want your encoding to be, in your connection str

Re: [ADMIN] Connectionstring

uot;Encoding" in the connectionString using pgOleDB with Visual Basic.? !DSPAM:37,459e5d08137101549039207! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" ---(end of broadcast)---

[ADMIN] Recovering a deleted database problem

t exist DETAIL: The database subdirectory "base/35290" is missing. But the [dbname] database is still in the system catalogues: /usr/local/pgsql/bin/psql -U postgresql -d postgres -c "select datname from pg_database;" datname postgres [db1] template1 tem

Re: [ADMIN] Windows Dependency Issue

ugh the silent install process? Or is there another way to accomplish this without requiring the user to set this after the installation process? Any help would be appreciated. Thanks, Pete !DSPAM:37,459d40d631947254553576! -- Andy Shellam NetServe Support Team the Mail Network "

Re: [ADMIN] Frustrating LO problem

Hi Sean, I'm certainly not a PostgreSQL expert when it comes to large objects etc, but there's one thing that jumps out at me here (perhaps someone else can see the same line of thought and into more depth as I can't think of much else to suggest?) The logfile lines when it doesn't: { WARNI

Re: [ADMIN] Postgres and Firewall

lient library using the PostgreSQL protocol that does the talking. You sound like you're using a fairly restrictive firewall, generally allowing traffic from/to a certain IP and port number is all that is required - is there a "generic TCP" option at all in your firewall? -- A

Re: [ADMIN] How do you upgrade for production servers?

the latest version and after you restore? any other procedure? I'd like to have my production server down as less time as possible. Thank you very much and have a great new year :D -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world"

Re: [ADMIN] Dump and Query

me | sur_name -++-- CUS002 | Andy | Shellam Or you can dump a specific table: # /usr/local/pgsql/bin/pg_dump --table=[tablename] [database] Regards, Andy. Enrico wrote: Is there any way to make a dump from a query? For example if my query is: select field1,field2 from table Do

Re: [ADMIN] pgAdmin crashes

give them more to go on and they'll be more likely to answer you. Thanks, Andy. Iannsp wrote: Andy Shellam (Mailing Lists) escreveu: Hi Bobby, I'd ask on the pgadmin-support list - PgAdmin's developers live there more-so than here. Regards, Andy Bobby Gontarski wrot

Re: [ADMIN] pgAdmin crashes

rted after installing the new 8.2 version it didn't do it with the earlier versions. What do I have wrong? Thanks ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster !DSPAM:37,45913b9f31942113013226! -- Andy Shellam N

Re: [ADMIN] DB problem

-i -D /var/lib/pg When you install the DB, the logs are enabled by default? Would you pls tell me still what setting need to be done? Thanks, Vinayak V. Raikar Extn : 143 !DSPAM:37,4590b56931941914011633! -- Andy Shellam NetServe Support Team the Mail Network "an altern

Re: [ADMIN] Backup

konqueror, and I use it for everything." -- Linus Torvalds ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834 ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] pgadmin firewall configuration

ree Edition. Version: 7.5.430 / Virus Database: 268.15.7/569 - Release Date: 12/5/2006 3:00 AM -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834 --

Re: [ADMIN] how to recover database back from /data folder [ Possibly

ted to too liberal permissions. Probably the original poster was doing the same mistake. Regds mallah. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster !DSPAM:37,457d667230861609539772! -- Andy Shellam NetServe Suppor

Re: [ADMIN] .bat file to access postgreSQL command line from C:\

bat ending. Or, when you go to Save As in Notepad, wrap the filename in quotes, e.g. File > Save As > "pgsql.bat" This will tell Notepad that you've already added the extension and don't need .txt adding on as well. -- Andy Shellam NetServe Support Team the Mail Netwo

Re: [ADMIN] Lost password to user postgres

need. I prefer option 2, as you don't have to take down your database to do it. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org !DSPAM:37,45720b9840411059761709! -- Andy

Re: [ADMIN] Postgres at startup

(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq !DSPAM:37,455c14a340413711078630! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world"

Re: [ADMIN] Checkpoint Location Format

WAL LOCATION). I've yet to run a restore test, but the backup and automatic archive clearout is working nicely. I'm not too worried about the SQL function to find the current WAL file, although I can see this could be useful too. Thanks, Andy. Simon Riggs wrote: On Tue, 2006-11-0

Re: [ADMIN] Finding out free space?

--- TIP 4: Have you searched our list archives? http://archives.postgresql.org !DSPAM:37,4559da5e40419901994390! -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0

Re: [ADMIN] Checkpoint Location Format

aracters before and after the "/", which works. Andy. Jim C. Nasby wrote: On Tue, Nov 07, 2006 at 01:12:53PM +, Andy Shellam (Mailing Lists) wrote: Hi, I'm writing an automated file-system level backup application for use with WAL archiving, that will issue the pg_st

[ADMIN] [Fwd: Checkpoint Location Format]

ost 6 digits). Can someone confirm this is the correct case? Thanks, Andy. Original Message Subject:Checkpoint Location Format Date: Tue, 07 Nov 2006 13:12:53 + From: Andy Shellam (Mailing Lists) <[EMAIL PROTECTED]> To: pgsql-admin@postgresql.org Hi,

[ADMIN] Checkpoint Location Format

Hi, I'm writing an automated file-system level backup application for use with WAL archiving, that will issue the pg_start_backup call, tar and gzip the cluster data directory, issue the pg_stop_backup call, and remove all previous un-needed WAL files from the archive. I need to write a regu

Re: [ADMIN] installation into virtual server

On a standard Windows client connecting to a 2003 server, you can run "mstsc /console" to force Windows to re-direct the console to you. Andy. [EMAIL PROTECTED] wrote: Hi, hope to not be OT. I'm trying to install PostGresql into a virtual sever, I've set the ConnectionName = Console as suggest

Re: [ADMIN] problem with initlocation

Compile it from source - 8.1.4 is the latest stable version. The 6.5 series is not just old, it's ancient. It hasn't been updated since 1999. There are some serious bugs in the earlier versions, even in the early 7.x series that do and have resulted in data loss. At least get and test out a

Re: [ADMIN] Why so long between archive calls?

Chris, I take it you've checked that the archive_command is actually succeeding (check the postgresql log file.) Perhaps try running it manually with an early log file as the PostgreSQL user account? When you say you're 500 files behind, how old is the earliest log? Andy. Chris Hoover wrote

Re: [ADMIN] CMS - portal server Question

We've just taken on ModX (www.modxcms.com) as our corporate CMS system. You can manage documents, and even write your own php "snippets" - similar idea to Webparts in M$ SharePoint and modules in Mambo, but they're much easier to create and use. You can design your site from the ground up if

Re: [ADMIN] Installing Postgres 8.1.4 on Linux RedHat

The links work for me (downloading from australia 2.) Are you using a proxy server? I do at times from work, and the PG mirrors don't seem to like proxies - or my proxy doesn't like the PG mirrors which is probably closer to the point :P (the proxy server always reports an error contacting t

Re: [ADMIN] WAL log switch: 8.1.4 and current log

Hi Robin, No there is no command to switch the current WAL file. There are a number of things you could do. You could rsync the current WAL file (i.e. the last modified file in the pg_xlog directory) every 5 minutes or so. However, depending on server usage, it isn't going to be long after a

Re: [ADMIN] On-line backup - /bin/tar: Error exit delayed from previous

We occasionally get the "file changed while being read" error, usually only once or twice a month (and we run nightly backups.) It's nothing to be concerned about, as someone else mentioned, the WAL logs will fix any internal inconsistencies. Regarding the file sizes, because it's zipped (I b

Re: [ADMIN] online backup - v810 vs. v814

in archive_status shows up. I was wondering if that was by design or I have a problem. ~DjK From: Andy Shellam <[EMAIL PROTECTED]> Reply-To: Andy Shellam <[EMAIL PROTECTED]> To: "Mr. Dan" <[EMAIL PROTECTED]> CC: pgsql-admin@postgresql.org Subject: Re: [ADMIN

Re: [ADMIN] online backup - v810 vs. v814

That looks to be a file hanging around from a previous PITR backup. That file should be in your xlog archive. cat the contents and you'll see which backup it belongs to. Andy. Mr. Dan wrote: Hi, I do an online backup with v814 and v810. I've noticed that there is a file showing up in the

Re: [ADMIN] libpqxx + postgresql connection

You might be better off asking this on the pgsql-interfaces list - that's geared more towards programming with libpq and other interfaces. Andy. LiveShell wrote: Hi all,   I am using libpqxx to connct to Pgsql database. Following is my code in a connect method of a class  

Re: [ADMIN] Read db files directly

var/lib/pgsql/data/base/1061329089 -> /seagate400/1061329089 Restarted many times. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org !DSPAM:14,44cb30f5143291875220417! --

Re: [ADMIN] Starting PostgreSQL from a windows application

brary, ODBC connection or other technology. Thanks in advance for your support, Hovik Avedian Senior Consultant Ebase Technology Ltd. !DSPAM:14,44c7a9ac143291148420564! -- Andy Shellam <mailto:[EMAIL PROTECTED]>, the Mail Network <http://www.mailnetwork.co.uk/> NetServe Support -

Re: [ADMIN] Ora2Pg and export of Multbyte UTF8 characters

Is your database and client encoding set to UTF-8? That's about all I can think of. Chaun Keating wrote: Hello, I have gotten Ora2pg to work fairly well for me, but I am having an issue where mutibyte characters are being substituted with replacement characters on export from Oracle. I used

Re: [ADMIN] 8.1 Unique Index Issue/Bug???

PostgreSQL does not consider a NULL value to be an equal value, therefore it cannot be a duplicate. If you must have a blank value in a column and need it to be unique, you'd need to do something like an empty string, or a string/figure your application will know is a null value that makes sen

Re: [ADMIN] Where are the temporary work / sort files please

These do exist as the documentation says - I found them in my 8.1.3 install, but only for a couple of databases. Perhaps they're only used when there has a need to be swapping data to disk? adey wrote: The postgresql parameter explanation for work_mem say :- "Another way to set this value

  1   2   >