On Sep 29, 2010, at 7:56 PM, Tom Lane wrote:
> pg_controldata would tell you approximately where the OID counter is.
Just what I needed. Thank you so much Tom.
Dianne
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgr
Hello everyone,
We have PostgreSQL 8.1.21 on CentOS 5.5 and some of our older programs still
use OIDs to identify a row. I'm planning on adding a serial column to the
tables and modifying the code to use the serial column instead. But I am
curious to find out how close we are before the OID w
Would an EAV model work? I'm thinking something like
. For example:
formA,ckbox1,true
formA,input1,initial value
formB,textarea1,enter your long comment here
You could easily extend this to , or
normalize it as you see fit.
This would work great too. If we go this route, we'll keep it simpl
which webserver does your client want to implement?
Apache, sorry I forgot to mention.
If JSLibrary = Dojo I would look at JSON (JavaScript Object
Notation language)
I would serialize to JSON instead of XML.
http://www.aurore.net/projects/php-json/
A simple json_encode($_POST) might do th
First, I want to thank you for your help. You have made great points
and I just want to respond to some of your questions.
My first thought is that if you use a combined "info" field, you'll
lose the ability to easily do any kind of meaningful data analysis
based on which boxes are checked. I
Hello,
I have some html forms that I save the settings into the database,
things like which item was selected in the menu and if a checkbox was
checked. The table looks like this:
user_id | report_id | info
-+---+
Hello list,
I downloaded the 8.0.10 rpms for FC4 yesterday and after installing
it, postgresql won't start. I get the following error: "An old
version of the database format was found" My previous postgresql
version was 8.0.8 and I read nothing on the release notes about a
dump/resto
Thanks for the response.
does the global directory exist on the drive you are syncing from? If
so ...
then it's a problem with your rsync.
check the options you are using with the rsync command.
check the rsync configurations in /etc/rsyncd.conf on the drive.
what user are you running the rsy
Args looks like this:
pg_dump -Ft -b -v the_db_name > the_output_file.tar
pg_restore restores the database. i.e.:
pg_restore -d the_db_name the_output_file.tar
Hope this helps -
Scott
On Nov 10, 2005, at 2:41 PM, Dianne Yumul wrote:
Hello to everybody.
I just have a couple o
Hello to everybody.
I just have a couple of newbie questions. I'm trying to restore our
databases from a file system backup. The backups are done with rsync,
the postgresql service is stopped before backups are done on the
server. The system is Fedora Core 4 with Postgresql 8.0.3.
Now back
May be you want the FM prefix, i.e. to_char(current_timestamp,
'FMMonth'). See the docs for more info:
http://www.postgresql.org/docs/8.0/interactive/functions-
formatting.html#FUNCTIONS-FORMATTING-EXAMPLES-TABLE
On Sep 19, 2005, at 8:20 AM, Alex Turner wrote:
Shiver me timbers, whats up w
Hello,
We have Fedora Core 4, but I'm pretty sure it's the same. To start the
service we use
/etc/rc.d/init.d/postgresql start
Now if you want postgresql to start automatically on boot you do:
chkconfig postgresql on
Read the man pages for chkconfig for more details.
Hope this helps.
On A
oh, and for installation instructions, please check out the very fine documentation at:
http://www.postgresql.org/docs/8.0/interactive/index.html
: )
On Jul 15, 2005, at 7:38 AM, Dinesh Pandey wrote:
From where can I download?
“Postgres 8.x” + required packages and “installation instruction”
Here:
http://www.postgresql.org/ftp/binary/v8.0.3/linux/rpms/fedora/fedora-core-2/
If you go to www.postgresql.org, under Downloads, you'll find directions and a link to the FTP mirrors.
On Jul 15, 2005, at 7:38 AM, Dinesh Pandey wrote:
From where can I download?
“Postgres 8.x” + required pac
Just an update . . . I tried upgrading kernel to 2.6.11.11 (kernel.org) but was unsuccessful (due to i2c and gcc 4.0 issue). So I settled for the one on the fedora development repository. But that didn't help, upgraded other stuff too like selinux-policy-targeted and initscripts. Beginning to pull
ll the help.
Dianne
On Jun 7, 2005, at 10:58 AM, Tom Lane wrote:
Dianne Yumul <[EMAIL PROTECTED]> writes:
# rm -f pgstartup.log
# /etc/rc.d/init.d/postgresql start
/usr/bin/chcon: can't apply partial context to unlabeled file
/home/postgres/pgstartup.log
Starting postgresql service:
tmaster -p 5432 -D /var/lib/pgsql/data
Many thanks for the help.
Dianne
On Jun 7, 2005, at 9:02 AM, Tom Lane wrote:
Dianne Yumul <[EMAIL PROTECTED]> writes:
Um, exactly which Postgres RPMs do you have installed?
Thanks for the response. I have the following installed:
post
used to
have 8.0.2 installed but I upgraded to 8.0.3, hoping that would fix it
but it didn't.
Thank you.
Dianne
On Jun 6, 2005, at 8:00 PM, Tom Lane wrote:
Dianne Yumul <[EMAIL PROTECTED]> writes:
We have Fedora Core 4 Test 3 installed on a development box and just
recentl
Hello list,
We have Fedora Core 4 Test 3 installed on a development box and just
recently installed Postgresql 8.0.3. Sometimes, when starting
postgresql with the /etc/rc.d/init.d/postgresql script, it gives me the
following:
/usr/bin/chcon: can't apply partial context to unlabeled file
/ho
Sorry, I did not see your email off-list until after I sent the other
one.
On Mar 18, 2005, at 11:56 AM, Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 18 Mar 2005, Dianne Yumul wrote:
Why don't you try yum, it will install the dependencies for you ; )
Yup, I didn't see your email off-list till after I re-sent the other
email. But thanks for the info.
On Mar 18, 2005, at 11:56 AM, Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 18 Mar 2005, Dianne Yumul wrote:
Why don't you try yum, it will i
Why don't you try yum, it will install the dependencies for you ; )
http://linux.duke.edu/projects/yum/
On Mar 18, 2005, at 11:32 AM, Devrim GUNDUZ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 18 Mar 2005, Edgar Amorim wrote:
I'm a kind new bye with linux & related stuffs. I'm t
hi,
I think it works for me. what version of postgres do you have? maybe
you just need to upgrade : )
test=# select cust_id, 'TEST' as test, cust_address from customers;
cust_id | test | cust_address
+--+--
11 | TEST | 200 Maple Lane
100
23 matches
Mail list logo
