Re: [ADMIN] cluster or database?

server and create the users/groups they will use then create the database for them with the structure you want in it. You only need to transfer the one database structure from your development server not your entire cluster. -- Shane Ambler [EMAIL PROTECTED] Get Sheek

Re: [ADMIN] Postgres is not starting or stopping

there -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] how to add a new data partition

ctive/ddl-partitioning.html -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [ADMIN] Disconnecting non active (IDLE ) users

LE users if they excided some time or some program which will purge memory from non active posgres.exe -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignor

Re: [ADMIN] Problems with precompiled pgsql on mac

them directly, console.log is in /Library/Logs/Console and system.log is in /var/log -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] Problems with precompiled pgsql on mac

at you will see on the terminal if you run pg_ctl directly. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail c

Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4

e familiar with the terminal then ps aux | grep postgres will list any processes running. If there are any stop postgresql and if the .pid file remains delete it then start postgresql. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(e

Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4

run in the background. (that would include a space and then the & after the last character in the command) If you have a startupitems folder to start postgresql on startup then you can also use that to start/stop postgresql manually with - sudo /Library/StartupItems/PostgreSQL/PostgreSQL

Re: [ADMIN] Possibilities of PgSQL

client is updating this data? I would think that the client could keep track of changes as they are typed and save this info with the updated data thus removing the time to compare the before and after data at the DB end. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://

Re: [ADMIN] Possibilities of PgSQL

by character) and records the differences. Shane Ambler pí¹e v Èt 23. 08. 2007 v 22:21 +0930: Karel Bøinda wrote: Hi, I have a question about PgSQL. I am working at some project and I want to have few tables with special properties: There would be many rows and these would be changed every

Re: [ADMIN] Installing PostgreSQL admin package

n the windows machine that has a compatible version of php enabled. Then just place the files within the web server directories as you would any other web pages and follow the config steps to get it to connect to the postgres server. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheek

Re: [ADMIN] MacOS X 10.5.1 and compiling for multiple Architectures

e that may help you for now is http://www.entropy.ch/blog/Software/2006/02/04/PostgreSQL-Universal-Binary-Build-Tips.html and http://www.entropy.ch/phpbb2/viewtopic.php?p=9579#9579 -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end of

Re: [ADMIN] MacOS X 10.5.1 and compiling for multiple Architectures

pplies fat binary libs with osx. From there to postgresql is a network connection (or local socket) so each program is just sending data to the other - they don't need to be the same architecture any more than you need a 64 bit sparc browser to connect to a 64 bit sparc web server. -- Sha

Re: [ADMIN] no entry on pg_database for a live database

with 7.4.19 (using a copy of your data files of course) As well as planning an upgrade to 8.1 or 8.2 -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [ADMIN] How to create a new user with password in commandline with no prompt for password

in Postgresql? Also if I create a new user with su postgres -c "createuser -A -d globus" .Will it set any default password while creating the user ?? No password is stored unless you specify it. As much as these are ways around your inconveniences, you should also consider t

Re: [ADMIN] after initdb - Re: How to CREATEDB in commandline with no prompt for password

ss file. If you are at a point where you want to automate setting up a large number of new systems and you don't know enough about *nix systems to create these scripts yourself then you should take a few steps back and learn more about *nix sysadmin before you move on. -- Shane Ambler

Re: [ADMIN] Postgres database and firewall

ernal network? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] Postgres database and firewall

h is what the firewall would need. I do know that some systems will not allow a program to change this setting so it must be done in the system config. Thanks Paramjeet Kaur -Original Message----- From: Shane Ambler [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 12:48 AM

Re: [ADMIN] create db from a template

asename2 in this case) -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] weird network issue

the other? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] weird network issue

s the other entries that can be refined to that) -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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]store different tables in different locations

appear to come from? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] Retore Postgres DB without dump

and new server you can pipe the dump output to psql sending it straight to the new server. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] What is the difference in storage between a blank string and null?

orage but most of the details will be found in the source. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] Server format and recovery

from source? If you built from source before you need to assign the same ./configure options as you did previously. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your sub

Re: [ADMIN] COPY errors when trying to convert from 7.4.19 to 8.3.1

our table defs in 8.3 and see if the fk constraints are in place. You would have two choices - clean up the data in 7.4 before the export or clean up after the import and before the fk constraints are added. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent

Re: [ADMIN] How to configure Postgre 8.2 to put the data base in a especific directory

diferent directory and drive than Postgre's. Did you specify the tablespace when creating the db? or create the tablespace after the db? Is the drive NTFS or FAT32? (system and the tablespace drive) What version of windows? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @

Re: [ADMIN] Postgresql Service Failed Error

Is postgres already running? are you running the postgresql restart as root? In your data dir you should find serverlog that should give more info - also try system or console logs -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-admin mailing l

Re: [ADMIN] how to get a number of seconds in some interval ?

march march has 31 days so 1st of march plus 1 month puts you at 1st of april. Try a leap year - select ('2008-02-01 12:00:00'::timestamp + '1 month'::interval) - '2008-02-01 12:00:00'::timestamp; ?column? -- 29 days (1 row) -- Shane Ambler pgSQL

Re: [ADMIN] insert a -1 into a bigint ?

are trying to enter - "t8.episode_name -1::bigint" into the column hence - "character varying - bigint" does not work -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to

Re: [ADMIN] ]To estimate the size of db

s you also get issues like data alignment and unused space on a page that doesn't fit a row... -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscrip

Re: [ADMIN] pgpass.conf

dir it is located in and the one running the software that will use it) is the only one that can access the data in the file. Normal permissions setup on windows will match this. It's use is a convenience and I think for the most part not highly recommended. -- Shane Ambler pgSQL (at) S

Re: [ADMIN] Connecting from xp to linux server

ou edit it on windows with cr/nl characters and copy it across to linux? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] Connecting from xp to linux server

. Note that "password" sends passwords # in clear text; "md5" is preferred since it sends encrypted passwords. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- 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] performance cost for varchar(20), varchar(255), and text

systems, it has no such advantages in PostgreSQL. In most situations text or character varying should be used instead. http://www.postgresql.org/docs/8.3/static/datatype-character.html -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-admin mailing list

Re: [ADMIN] conditional logging based on client

sent. You could then filter these sql statements out of the logs leaving you with hand crafted sql. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.post

Re: [ADMIN] conditional logging based on client

ql.org/docs/8.3/interactive/sql-createfunction.html Another option would be to have them use a different user name when using psql. Probably not an option unless the app runs with it's own username. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via

Re: [ADMIN] Postgres database as a client/server architecture

m the synchronising. You will either want a list of changed records per client or modified timestamps to determine what has changed since the last synchronise, as well as define actions upon conflicts. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-admin ma

Re: [ADMIN] 32bit data on 64bit machine?

will not read from the same data files. You will need to dump and restore to transfer the data across. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http

[ADMIN] Schema migration-cvs

Migrations currently supports Derby Oracle PostgreSQL Patches for other databases are welcome. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz -- 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] How to size a log file partition

look into other options for log file rotation. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz -- 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] Sql Anywhere to PostgreSQL?

) -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Backing Up Partial Databases

y you want to do it. You will need to do a find and replace on the INSERT's to change the table name though. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 1: if posting/reading thr

Re: [ADMIN] Uninstalling on Mac OS X 10.4

pgsql folder from there then goto /Library/StartupItems and delete the PostgreSQL folder. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] Can somebody help me on adding so file

ll need to give some more information - are you trying to CREATE FUNCTION? or something else? What steps have you tried so far and what errors have you got? Is the .so file readable by the same user that is running PostgreSQL? -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://

Re: [ADMIN] dump from 8.x restore to 7.3.x

g any schema changes until you are happy to stay with 8.x will help and you could just dump data only to go back. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---(end of broadcast)--- TIP 6: explain analyze is your friend