Re: [ADMIN] PGadmin PostgresSQL

2012-03-30 Thread Dick Visser
What do you mean by 'uploading databases'? I.e. what commands do you issue? Dick Sent from my Iphone On 31 mrt. 2012, at 03:09, Tim Dons wrote: Dear PGAdmin support, We have some troubles with uploading databases to a server of a client on the internet. If we upload the database the conn

[ADMIN] about encoding

2012-03-30 Thread superman0920
hello i want to insert a report to postgresql，the report contain something Chinese characters and the postgresql is utf-8. the response from db is this: ERROR: invalid byte sequence for encoding "UTF8": 0xb1 how can i fix it ? thx superman0920

[ADMIN] PGadmin PostgresSQL

2012-03-30 Thread Tim Dons
Dear PGAdmin support, We have some troubles with uploading databases to a server of a client on the internet. If we upload the database the connection drops after several minutes. We think that the firewall is the problem, but we don't know how to change the right settings in the firewa

[ADMIN] Postgres Zip init not creating db user windows

2012-03-30 Thread sagarika rao
Hi, Ive downloaded the postgres extractable version of windows(32 and 64) .These are the steps i followed 1.extracted the postgres zip file 2. create a new network user ( serviceaccount) 3. gave the owner ship permissions on the datadir 4. gave logon as service permissions to the user 5. ran t

[ADMIN] Windows client only psql install

2012-03-30 Thread Laura Moloney
Hi All, This is my first post, so if I am doing something wrong, feel free to let me know. 1) I am looking to use psql from my remote Windows 7 desktop, connecting to a backend Postgres server at another location. I have worked extensively with Oracle and there is a client side SQLPlus to

[ADMIN] Warnings in Standby Logs

2012-03-30 Thread Eric Simon
Hi, I'm on 9.1.2 and occasionally get what are probably harmless warning messages in my logs, but because I have the responsibility of ensuring we haven't lost a bit of data between our master and standby, I feel I should know exactly what they mean. I occasionally see "invalid record length" an

Re: [ADMIN] pg_database_size() and actual disk space usage

2012-03-30 Thread Alexander Fortin
On 3/30/12 12:39 PM, Vladimir Rusinov wrote: > Are you rotating postgresql log files? If so, how do you do that? > > Do you have archive_command set in postgresql.conf? Hi Vladimir. Yes, I'm using the packaged Postgres 9.1.2 version shipped with Ubuntu 11.10. From my understanding, it's logrotat

Re: [ADMIN] pg_database_size() and actual disk space usage

2012-03-30 Thread Vladimir Rusinov
On Fri, Mar 30, 2012 at 2:34 PM, Alexander Fortin < alexander.for...@gmail.com> wrote: > On 3/30/12 12:14 PM, Bernhard Schrader wrote: > > # df -h /var/lib/postgresql > FilesystemSize Used Avail Use% Mounted on > /dev/md_d0128G 44G 85G 35% /var/lib/postgresql > > #

Re: [ADMIN] pg_database_size() and actual disk space usage

2012-03-30 Thread Alexander Fortin
On 3/30/12 12:14 PM, Bernhard Schrader wrote: > i hope this will help you. Thanks Bernhard, I'll check the thread right now. In the meanwhile I've noticed this strange behavior too and I was already going to post it, maybe it's related to what you're suggesting: # df -h /var/lib/postgresql Filesy

Re: [ADMIN] pg_database_size() and actual disk space usage

2012-03-30 Thread Bernhard Schrader
On 03/30/2012 09:20 AM, Alexander Fortin wrote: On 3/29/12 3:24 PM, Bernhard Schrader wrote: Hi, which filesystem do you use, and which kernel is running? Hi Bernhard, it's XFS on Ubuntu server 11.10, Kernel is 3.0.0-16-virtual (m1.large Ec2 instances) Ok, well with Kernel 2.6.38 xfs intr

Re: [ADMIN] pg_database_size() and actual disk space usage

2012-03-30 Thread Alexander Fortin
On 3/29/12 3:24 PM, Bernhard Schrader wrote: > Hi, > > which filesystem do you use, and which kernel is running? Hi Bernhard, it's XFS on Ubuntu server 11.10, Kernel is 3.0.0-16-virtual (m1.large Ec2 instances) -- Alexander Fortin http://about.me/alexanderfortin/ -- Sent via pgsql-admin mail